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 "grade" = :p0 and "state" = :p1 and (school_state_id > :p3 or (school_state_id = :p3 and rowid > :p2)) order by school_state_id, 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	total	total_int
2763215	CT	school	900450	150011	Bridgeport School District	90045001633	151511	Information Technology & Software Engineering Magnet High School	Public Schools	Regular School	No	High	09	12	2020	grade_3	0	0
2437304	CT	school	900450	150011	Bridgeport School District	90045001631	151611	Bridgeport Military Academy	Public Schools	Regular School	No	High	09	12	2019	grade_3	0	0
2742935	CT	school	900450	150011	Bridgeport School District	90045001631	151611	Bridgeport Military Academy	Public Schools	Regular School	No	High	09	12	2021	grade_3	0	0
2763213	CT	school	900450	150011	Bridgeport School District	90045001631	151611	Bridgeport Military Academy	Public Schools	Regular School	No	High	09	12	2020	grade_3	0	0
2437288	CT	school	900450	150011	Bridgeport School District	90045000071	151711	Park City Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_3	56	56
2742919	CT	school	900450	150011	Bridgeport School District	90045000071	151711	Park City Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_3	54	54
2763197	CT	school	900450	150011	Bridgeport School District	90045000071	151711	Park City Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_3	57	57
2437299	CT	school	900450	150011	Bridgeport School District	90045000074	152011	Madison School	Public Schools	Regular School	No	Elementary	KG	06	2019	grade_3	62	62
2742928	CT	school	900450	150011	Bridgeport School District	90045000074	152011	Madison School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_3	60	60
2763206	CT	school	900450	150011	Bridgeport School District	90045000074	152011	Madison School	Public Schools	Regular School	No	Elementary	KG	06	2020	grade_3	69	69
2437278	CT	school	900450	150011	Bridgeport School District	90045000075	152111	Classical Studies Academy	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_3	50	50
2742909	CT	school	900450	150011	Bridgeport School District	90045000075	152111	Classical Studies Academy	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_3	48	48
2763187	CT	school	900450	150011	Bridgeport School District	90045000075	152111	Classical Studies Academy	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_3	50	50
2437285	CT	school	900450	150011	Bridgeport School District	90045000076	152211	Jettie S. Tisdale School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_3	57	57
2742916	CT	school	900450	150011	Bridgeport School District	90045000076	152211	Jettie S. Tisdale School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_3	60	60
2763194	CT	school	900450	150011	Bridgeport School District	90045000076	152211	Jettie S. Tisdale School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_3	55	55
2437290	CT	school	900450	150011	Bridgeport School District	90045000080	152511	Read School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_3	79	79
2742921	CT	school	900450	150011	Bridgeport School District	90045000080	152511	Read School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_3	75	75
2763199	CT	school	900450	150011	Bridgeport School District	90045000080	152511	Read School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_3	83	83
2437291	CT	school	900450	150011	Bridgeport School District	90045000081	152611	Roosevelt School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_3	60	60
2742922	CT	school	900450	150011	Bridgeport School District	90045000081	152611	Roosevelt School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_3	59	59
2763200	CT	school	900450	150011	Bridgeport School District	90045000081	152611	Roosevelt School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_3	66	66
2437308	CT	school		150011	Bridgeport School District		152811	The Transition Academy	Program						2019	grade_3	0	0
2742939	CT	school		150011	Bridgeport School District		152811	The Transition Academy	Program						2021	grade_3	0	0
2763217	CT	school		150011	Bridgeport School District		152811	The Transition Academy	Program						2020	grade_3	0	0
2437292	CT	school	900450	150011	Bridgeport School District	90045000086	153011	Waltersville School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_3	52	52
2742923	CT	school	900450	150011	Bridgeport School District	90045000086	153011	Waltersville School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_3	52	52
2763201	CT	school	900450	150011	Bridgeport School District	90045000086	153011	Waltersville School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_3	55	55
2437280	CT	school	900450	150011	Bridgeport School District	90045001918	153111	Geraldine Claytor Magnet Academy	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_3	54	54
2742911	CT	school	900450	150011	Bridgeport School District	90045001918	153111	Geraldine Claytor Magnet Academy	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_3	43	43
2763189	CT	school	900450	150011	Bridgeport School District	90045001918	153111	Geraldine Claytor Magnet Academy	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_3	46	46
2437281	CT	school	900450	150011	Bridgeport School District	90045000087	153211	Geraldine Johnson School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_3	79	79
2742912	CT	school	900450	150011	Bridgeport School District	90045000087	153211	Geraldine Johnson School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_3	82	82
2763190	CT	school	900450	150011	Bridgeport School District	90045000087	153211	Geraldine Johnson School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_3	73	73
2437286	CT	school	900450	150011	Bridgeport School District	90045000090	153611	John Winthrop School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_3	74	74
2742917	CT	school	900450	150011	Bridgeport School District	90045000090	153611	John Winthrop School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_3	66	66
2763195	CT	school	900450	150011	Bridgeport School District	90045000090	153611	John Winthrop School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_3	70	70
2437284	CT	school	900450	150011	Bridgeport School District	90045001590	153711	Interdistrict Discovery Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_3	44	44
2742915	CT	school	900450	150011	Bridgeport School District	90045001590	153711	Interdistrict Discovery Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_3	45	45
2763193	CT	school	900450	150011	Bridgeport School District	90045001590	153711	Interdistrict Discovery Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_3	44	44
2437293	CT	school	900450	150011	Bridgeport School District	90045000059	153911	Wilbur Cross School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_3	38	38
2742930	CT	school	900450	150011	Bridgeport School District	90045000059	153911	Wilbur Cross School	Public Schools	Regular School	No	Elementary	KG	08	2021	grade_3	38	38
2763208	CT	school	900450	150011	Bridgeport School District	90045000059	153911	Wilbur Cross School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_3	30	30
2437275	CT	school	900450	150011	Bridgeport School District	90045000053	154011	Blackham School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_3	109	109
2742906	CT	school	900450	150011	Bridgeport School District	90045000053	154011	Blackham School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_3	103	103
2763184	CT	school	900450	150011	Bridgeport School District	90045000053	154011	Blackham School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_3	117	117
2437289	CT	school	900450	150011	Bridgeport School District	90045001161	154111	Paul Laurence Dunbar School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_3	34	34
2742920	CT	school	900450	150011	Bridgeport School District	90045001161	154111	Paul Laurence Dunbar School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_3	20	20
2763198	CT	school	900450	150011	Bridgeport School District	90045001161	154111	Paul Laurence Dunbar School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_3	36	36
2437298	CT	school	900450	150011	Bridgeport School District	90045001162	154211	James J. Curiale School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_3	64	64
2742927	CT	school	900450	150011	Bridgeport School District	90045001162	154211	James J. Curiale School	Public Schools	Regular School	No	Elementary	KG	08	2021	grade_3	50	50
2763205	CT	school	900450	150011	Bridgeport School District	90045001162	154211	James J. Curiale School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_3	61	61
2437271	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	grade_3	0	0
2742902	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2021	grade_3	0	0
2763180	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2437283	CT	school	900450	150011	Bridgeport School District	90045001163	154511	High Horizons Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_3	50	50
2742914	CT	school	900450	150011	Bridgeport School District	90045001163	154511	High Horizons Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_3	47	47
2763192	CT	school	900450	150011	Bridgeport School District	90045001163	154511	High Horizons Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_3	50	50
2437300	CT	school	900450	150011	Bridgeport School District	90045001127	154611	Multicultural Magnet School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_3	51	51
2742929	CT	school	900450	150011	Bridgeport School District	90045001127	154611	Multicultural Magnet School	Public Schools	Regular School	No	Elementary	KG	08	2021	grade_3	46	46
2763207	CT	school	900450	150011	Bridgeport School District	90045001127	154611	Multicultural Magnet School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_3	50	50
2437302	CT	school	900450	150011	Bridgeport School District	90045000050	156111	Bassick High School	Public Schools	Regular School	No	High	09	12	2019	grade_3	0	0
2742933	CT	school	900450	150011	Bridgeport School District	90045000050	156111	Bassick High School	Public Schools	Regular School	No	High	09	12	2021	grade_3	0	0
2763211	CT	school	900450	150011	Bridgeport School District	90045000050	156111	Bassick High School	Public Schools	Regular School	No	High	09	12	2020	grade_3	0	0
2437305	CT	school	900450	150011	Bridgeport School District	90045000056	156211	Central High School	Public Schools	Regular School	No	High	09	12	2019	grade_3	0	0
2742936	CT	school	900450	150011	Bridgeport School District	90045000056	156211	Central High School	Public Schools	Regular School	No	High	09	12	2021	grade_3	0	0
2763214	CT	school	900450	150011	Bridgeport School District	90045000056	156211	Central High School	Public Schools	Regular School	No	High	09	12	2020	grade_3	0	0
2437307	CT	school	900450	150011	Bridgeport School District	90045000067	156311	Warren Harding High School	Public Schools	Regular School	No	High	09	12	2019	grade_3	0	0
2742938	CT	school	900450	150011	Bridgeport School District	90045000067	156311	Warren Harding High School	Public Schools	Regular School	No	High	09	12	2021	grade_3	0	0
2763216	CT	school	900450	150011	Bridgeport School District	90045000067	156311	Warren Harding High School	Public Schools	Regular School	No	High	09	12	2020	grade_3	0	0
2437295	CT	school		150011	Bridgeport School District	90045001472	159011	Bridgeport Learning Center	Program						2019	grade_3	8	8
2742931	CT	school		150011	Bridgeport School District	90045001472	159011	Bridgeport Learning Center	Program						2021	grade_3	*
2763209	CT	school		150011	Bridgeport School District	90045001472	159011	Bridgeport Learning Center	Program						2020	grade_3	14	14
2437341	CT	school		170011	Bristol School District		170211	ACCESS	Program						2019	grade_3	0	0
2742974	CT	school		170011	Bristol School District		170211	ACCESS	Program						2021	grade_3	0	0
2763252	CT	school		170011	Bristol School District		170211	ACCESS	Program						2020	grade_3	0	0
2437316	CT	school	900510	170011	Bristol School District	90051000096	170311	Edgewood School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_3	46	46
2742947	CT	school	900510	170011	Bristol School District	90051000096	170311	Edgewood School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_3	45	45
2763225	CT	school	900510	170011	Bristol School District	90051000096	170311	Edgewood School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_3	50	50
2437310	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2019	grade_3	0	0
2742941	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2021	grade_3	0	0
2763219	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2437312	CT	school	900510	170011	Bristol School District	90051000098	170511	Greene-Hills School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_3	96	96
2742943	CT	school	900510	170011	Bristol School District	90051000098	170511	Greene-Hills School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_3	86	86
2763221	CT	school	900510	170011	Bristol School District	90051000098	170511	Greene-Hills School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_3	116	116
2437332	CT	school		170011	Bristol School District		170811	Chippens Hilll Middle School Extended Resource	Program						2019	grade_3	0	0
2742965	CT	school		170011	Bristol School District		170811	Chippens Hilll Middle School Extended Resource	Program						2021	grade_3	0	0
2763243	CT	school		170011	Bristol School District		170811	Chippens Hilll Middle School Extended Resource	Program						2020	grade_3	0	0
2437336	CT	school		170011	Bristol School District	90051001661	170911	Greene-Hills GOAL	Program						2019	grade_3	0	0
2742970	CT	school		170011	Bristol School District	90051001661	170911	Greene-Hills GOAL	Program						2021	grade_3	0	0
2763245	CT	school		170011	Bristol School District	90051001661	170911	Greene-Hills GOAL	Program						2020	grade_3	0	0
2437330	CT	school		170011	Bristol School District	90051001748	171011	Chippens Hill Middle School Functional Program	Program						2019	grade_3	0	0
2742963	CT	school		170011	Bristol School District	90051001748	171011	Chippens Hill Middle School Functional Program	Program						2021	grade_3	0	0
2763241	CT	school		170011	Bristol School District	90051001748	171011	Chippens Hill Middle School Functional Program	Program						2020	grade_3	0	0
2437315	CT	school	900510	170011	Bristol School District	90051000105	171111	South Side School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_3	64	64
2742946	CT	school	900510	170011	Bristol School District	90051000105	171111	South Side School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_3	88	88
2763224	CT	school	900510	170011	Bristol School District	90051000105	171111	South Side School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_3	66	66
2437320	CT	school	900510	170011	Bristol School District	90051000106	171211	Stafford School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_3	71	71
2742952	CT	school	900510	170011	Bristol School District	90051000106	171211	Stafford School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_3	52	52
2763231	CT	school	900510	170011	Bristol School District	90051000106	171211	Stafford School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_3	61	61
2437311	CT	school	900510	170011	Bristol School District	90051000097	171411	Ellen P. Hubbell School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_3	61	61