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 (district > :p2 or (district = :p2 and rowid > :p1)) order by district, rowid 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	school_state_type	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	native_hawaiian_pacific_islander	multiracial	male	female	ell	disability	total	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	male_int	female_int	ell_int	disability_int	total_int
2445935	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2019	grade_9												0												0
2447379	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_10												0												0
2447380	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_10												0												0
2447381	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_10												0												0
2447382	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_10												0												0
2447383	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2019	grade_10												245												245
2447384	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2019	grade_10												0												0
2448828	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11												0												0
2448829	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11												0												0
2448830	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_11												0												0
2448831	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_11												0												0
2448832	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2019	grade_11												207												207
2448833	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2019	grade_11												0												0
2450277	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_12												0												0
2450278	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_12												0												0
2450279	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_12												0												0
2450280	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_12												0												0
2450281	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2019	grade_12												230												230
2450282	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2019	grade_12												*
2451726	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2019	pk_12_total	369	11	61	0	18	0	17	238	238	16	98	476	369	11	61	0	18	0	17	238	238	16	98	476
2451727	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	PK	05	2019	pk_12_total	418	*	43	*	13	0	16	257	245	26	59	502	418		43		13	0	16	257	245	26	59	502
2451728	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2019	pk_12_total	163	*	32	0	13	0	*	101	119	22	28	220	163		32	0	13	0		101	119	22	28	220
2451729	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2019	pk_12_total	548	*	83	*	19	0	19	361	324	10	100	685	548		83		19	0	19	361	324	10	100	685
2451730	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2019	pk_12_total	724	23	93	0	35	0	24	487	412	6	94	899	724	23	93	0	35	0	24	487	412	6	94	899
2451731	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2019	pk_12_total	*	0	*	0	0	0	0	*	*	*	*	*		0		0	0	0	0
2738535	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2021	kindergarten												65												65
2738536	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	KG	05	2021	kindergarten												77												77
2738537	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2021	kindergarten												25												25
2738538	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2021	kindergarten												0												0
2738539	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2021	kindergarten												0												0
2738540	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2021	kindergarten												0												0
2739979	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1												57												57
2739980	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1												85												85
2739981	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1												39												39
2739982	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_1												0												0
2739983	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2021	grade_1												0												0
2739984	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2021	grade_1												0												0
2741423	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_2												71												71
2741424	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_2												79												79
2741425	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_2												33												33
2741426	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_2												0												0
2741427	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2021	grade_2												0												0
2741428	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2021	grade_2												0												0
2742867	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_3												65												65
2742868	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_3												89												89
2742869	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_3												41												41
2742870	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_3												0												0
2742871	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2021	grade_3												0												0
2742872	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2021	grade_3												0												0
2744311	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_4												63												63
2744312	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_4												81												81
2744313	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_4												29												29
2744314	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_4												0												0
2744315	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2021	grade_4												0												0
2744316	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2021	grade_4												0												0
2745755	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_5												70												70
2745756	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_5												83												83
2745757	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_5												41												41
2745758	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_5												0												0
2745759	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2021	grade_5												0												0
2745760	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2021	grade_5												0												0
2747199	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_6												0												0
2747200	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_6												0												0
2747201	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_6												0												0
2747202	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_6												195												195
2747203	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2021	grade_6												0												0
2747204	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2021	grade_6												0												0
2748643	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_7												0												0
2748644	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_7												0												0
2748645	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_7												0												0
2748646	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_7												208												208
2748647	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2021	grade_7												0												0
2748648	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2021	grade_7												0												0
2750087	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_8												0												0
2750088	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_8												0												0
2750089	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_8												0												0
2750090	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_8												229												229
2750091	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2021	grade_8												0												0
2750092	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2021	grade_8												0												0
2751531	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_9												0												0
2751532	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_9												0												0
2751533	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_9												0												0
2751534	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_9												0												0
2751535	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2021	grade_9												198												198
2751536	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2021	grade_9												0												0
2752975	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_10												0												0
2752976	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_10												0												0
2752977	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_10												0												0
2752978	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_10												0												0
2752979	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2021	grade_10												240												240
2752980	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2021	grade_10												0												0
2754419	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_11												0												0
2754420	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_11												0												0
2754421	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_11												0												0
2754422	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_11												0												0
2754423	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2021	grade_11												219												219
2754424	CT	school		70011	Berlin School District		70311	Transition Academy	Program						2021	grade_11												0												0
2755863	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_12												0												0
2755864	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_12												0												0
2755865	CT	school	900210	70011	Berlin School District	90021000021	70111	Richard D. Hubbard School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_12												0												0
2755866	CT	school	900210	70011	Berlin School District	90021000017	75111	Catherine M. McGee Middle School	Public Schools	Regular School	No	Middle	06	08	2021	grade_12												0												0