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_state_id > :p2 or (district_state_id = :p2 and rowid > :p1)) order by district_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
2763956	CT	school		1030011	Norwalk School District		1031111	Norwalk 18-21 Next Steps (NNS)	Program						2020	grade_3	0	0
2763957	CT	school		1030011	Norwalk School District		1030611	Norwalk 18-21 Project SEARCH	Program						2020	grade_3	0	0
2765395	CT	school	903090	1030011	Norwalk School District	90309000640	1030211	Brookside Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_4	65	65
2765396	CT	school	903090	1030011	Norwalk School District	90309000645	1032011	Fox Run Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_4	52	52
2765397	CT	school	903090	1030011	Norwalk School District	90309000648	1030711	Jefferson Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_4	85	85
2765398	CT	school	903090	1030011	Norwalk School District	90309000649	1030811	Kendall Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_4	99	99
2765399	CT	school	903090	1030011	Norwalk School District	90309000652	1032111	Naramake Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_4	68	68
2765400	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0	0
2765401	CT	school	903090	1030011	Norwalk School District	90309000642	1030311	Columbus Magnet School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_4	64	64
2765402	CT	school	903090	1030011	Norwalk School District	90309000643	1030411	Cranbury Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_4	75	75
2765403	CT	school	903090	1030011	Norwalk School District	90309000651	1032211	Marvin Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_4	59	59
2765404	CT	school	903090	1030011	Norwalk School District	90309000658	1031311	Rowayton School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_4	88	88
2765405	CT	school	903090	1030011	Norwalk School District	90309000659	1032311	Silvermine Dual Language Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_4	78	78
2765406	CT	school	903090	1030011	Norwalk School District	90309000660	1031411	Tracey Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_4	74	74
2765407	CT	school	903090	1030011	Norwalk School District	90309000662	1032411	Wolfpit School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_4	39	39
2765408	CT	school	903090	1030011	Norwalk School District	90309000653	1035211	Nathan Hale Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_4	0	0
2765409	CT	school	903090	1030011	Norwalk School District	90309000656	1035311	Ponus Ridge Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_4	0	0
2765410	CT	school	903090	1030011	Norwalk School District	90309000657	1035511	Roton Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_4	0	0
2765411	CT	school	903090	1030011	Norwalk School District	90309000661	1035411	West Rocks Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_4	0	0
2765412	CT	school	903090	1030011	Norwalk School District	90309000638	1036211	Brien McMahon High School	Public Schools	Regular School	No	High	09	12	2020	grade_4	0	0
2765413	CT	school	903090	1030011	Norwalk School District	90309001917	1030511	Center for Global Studies	Public Schools	Regular School	No	High	09	12	2020	grade_4	0	0
2765414	CT	school		1030011	Norwalk School District		1031011	Norwalk Alternative Opportunity Program	Program						2020	grade_4	0	0
2765415	CT	school	903090	1030011	Norwalk School District	90309000655	1036111	Norwalk High School	Public Schools	Regular School	No	High	09	12	2020	grade_4	0	0
2765416	CT	school	903090	1030011	Norwalk School District	90309001923	1030911	P-TECH Norwalk	Public Schools	Regular School	No	High	09	12	2020	grade_4	0	0
2765417	CT	school		1030011	Norwalk School District		1031111	Norwalk 18-21 Next Steps (NNS)	Program						2020	grade_4	0	0
2765418	CT	school		1030011	Norwalk School District		1030611	Norwalk 18-21 Project SEARCH	Program						2020	grade_4	0	0
2766856	CT	school	903090	1030011	Norwalk School District	90309000640	1030211	Brookside Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_5	83	83
2766857	CT	school	903090	1030011	Norwalk School District	90309000645	1032011	Fox Run Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_5	63	63
2766858	CT	school	903090	1030011	Norwalk School District	90309000648	1030711	Jefferson Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_5	97	97
2766859	CT	school	903090	1030011	Norwalk School District	90309000649	1030811	Kendall Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_5	92	92
2766860	CT	school	903090	1030011	Norwalk School District	90309000652	1032111	Naramake Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_5	65	65
2766861	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0	0
2766862	CT	school	903090	1030011	Norwalk School District	90309000642	1030311	Columbus Magnet School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_5	62	62
2766863	CT	school	903090	1030011	Norwalk School District	90309000643	1030411	Cranbury Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_5	68	68
2766864	CT	school	903090	1030011	Norwalk School District	90309000651	1032211	Marvin Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_5	84	84
2766865	CT	school	903090	1030011	Norwalk School District	90309000658	1031311	Rowayton School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_5	80	80
2766866	CT	school	903090	1030011	Norwalk School District	90309000659	1032311	Silvermine Dual Language Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_5	89	89
2766867	CT	school	903090	1030011	Norwalk School District	90309000660	1031411	Tracey Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_5	63	63
2766868	CT	school	903090	1030011	Norwalk School District	90309000662	1032411	Wolfpit School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_5	55	55
2766869	CT	school	903090	1030011	Norwalk School District	90309000653	1035211	Nathan Hale Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_5	0	0
2766870	CT	school	903090	1030011	Norwalk School District	90309000656	1035311	Ponus Ridge Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_5	0	0
2766871	CT	school	903090	1030011	Norwalk School District	90309000657	1035511	Roton Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_5	0	0
2766872	CT	school	903090	1030011	Norwalk School District	90309000661	1035411	West Rocks Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_5	0	0
2766873	CT	school	903090	1030011	Norwalk School District	90309000638	1036211	Brien McMahon High School	Public Schools	Regular School	No	High	09	12	2020	grade_5	0	0
2766874	CT	school	903090	1030011	Norwalk School District	90309001917	1030511	Center for Global Studies	Public Schools	Regular School	No	High	09	12	2020	grade_5	0	0
2766875	CT	school		1030011	Norwalk School District		1031011	Norwalk Alternative Opportunity Program	Program						2020	grade_5	0	0
2766876	CT	school	903090	1030011	Norwalk School District	90309000655	1036111	Norwalk High School	Public Schools	Regular School	No	High	09	12	2020	grade_5	0	0
2766877	CT	school	903090	1030011	Norwalk School District	90309001923	1030911	P-TECH Norwalk	Public Schools	Regular School	No	High	09	12	2020	grade_5	0	0
2766878	CT	school		1030011	Norwalk School District		1031111	Norwalk 18-21 Next Steps (NNS)	Program						2020	grade_5	0	0
2766879	CT	school		1030011	Norwalk School District		1030611	Norwalk 18-21 Project SEARCH	Program						2020	grade_5	0	0
2768317	CT	school	903090	1030011	Norwalk School District	90309000640	1030211	Brookside Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_6	0	0
2768318	CT	school	903090	1030011	Norwalk School District	90309000645	1032011	Fox Run Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_6	0	0
2768319	CT	school	903090	1030011	Norwalk School District	90309000648	1030711	Jefferson Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_6	0	0
2768320	CT	school	903090	1030011	Norwalk School District	90309000649	1030811	Kendall Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_6	0	0
2768321	CT	school	903090	1030011	Norwalk School District	90309000652	1032111	Naramake Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_6	0	0
2768322	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
2768323	CT	school	903090	1030011	Norwalk School District	90309000642	1030311	Columbus Magnet School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_6	18	18
2768324	CT	school	903090	1030011	Norwalk School District	90309000643	1030411	Cranbury Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_6	0	0
2768325	CT	school	903090	1030011	Norwalk School District	90309000651	1032211	Marvin Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_6	0	0
2768326	CT	school	903090	1030011	Norwalk School District	90309000658	1031311	Rowayton School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_6	0	0
2768327	CT	school	903090	1030011	Norwalk School District	90309000659	1032311	Silvermine Dual Language Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_6	0	0
2768328	CT	school	903090	1030011	Norwalk School District	90309000660	1031411	Tracey Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_6	0	0
2768329	CT	school	903090	1030011	Norwalk School District	90309000662	1032411	Wolfpit School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_6	0	0
2768330	CT	school	903090	1030011	Norwalk School District	90309000653	1035211	Nathan Hale Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_6	180	180
2768331	CT	school	903090	1030011	Norwalk School District	90309000656	1035311	Ponus Ridge Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_6	230	230
2768332	CT	school	903090	1030011	Norwalk School District	90309000657	1035511	Roton Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_6	175	175
2768333	CT	school	903090	1030011	Norwalk School District	90309000661	1035411	West Rocks Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_6	248	248
2768334	CT	school	903090	1030011	Norwalk School District	90309000638	1036211	Brien McMahon High School	Public Schools	Regular School	No	High	09	12	2020	grade_6	0	0
2768335	CT	school	903090	1030011	Norwalk School District	90309001917	1030511	Center for Global Studies	Public Schools	Regular School	No	High	09	12	2020	grade_6	0	0
2768336	CT	school		1030011	Norwalk School District		1031011	Norwalk Alternative Opportunity Program	Program						2020	grade_6	0	0
2768337	CT	school	903090	1030011	Norwalk School District	90309000655	1036111	Norwalk High School	Public Schools	Regular School	No	High	09	12	2020	grade_6	0	0
2768338	CT	school	903090	1030011	Norwalk School District	90309001923	1030911	P-TECH Norwalk	Public Schools	Regular School	No	High	09	12	2020	grade_6	0	0
2768339	CT	school		1030011	Norwalk School District		1031111	Norwalk 18-21 Next Steps (NNS)	Program						2020	grade_6	0	0
2768340	CT	school		1030011	Norwalk School District		1030611	Norwalk 18-21 Project SEARCH	Program						2020	grade_6	0	0
2769778	CT	school	903090	1030011	Norwalk School District	90309000640	1030211	Brookside Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_7	0	0
2769779	CT	school	903090	1030011	Norwalk School District	90309000645	1032011	Fox Run Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_7	0	0
2769780	CT	school	903090	1030011	Norwalk School District	90309000648	1030711	Jefferson Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_7	0	0
2769781	CT	school	903090	1030011	Norwalk School District	90309000649	1030811	Kendall Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_7	0	0
2769782	CT	school	903090	1030011	Norwalk School District	90309000652	1032111	Naramake Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_7	0	0
2769783	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0	0
2769784	CT	school	903090	1030011	Norwalk School District	90309000642	1030311	Columbus Magnet School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_7	17	17
2769785	CT	school	903090	1030011	Norwalk School District	90309000643	1030411	Cranbury Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_7	0	0
2769786	CT	school	903090	1030011	Norwalk School District	90309000651	1032211	Marvin Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_7	0	0
2769787	CT	school	903090	1030011	Norwalk School District	90309000658	1031311	Rowayton School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_7	0	0
2769788	CT	school	903090	1030011	Norwalk School District	90309000659	1032311	Silvermine Dual Language Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_7	0	0
2769789	CT	school	903090	1030011	Norwalk School District	90309000660	1031411	Tracey Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_7	0	0
2769790	CT	school	903090	1030011	Norwalk School District	90309000662	1032411	Wolfpit School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_7	0	0
2769791	CT	school	903090	1030011	Norwalk School District	90309000653	1035211	Nathan Hale Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_7	218	218
2769792	CT	school	903090	1030011	Norwalk School District	90309000656	1035311	Ponus Ridge Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_7	209	209
2769793	CT	school	903090	1030011	Norwalk School District	90309000657	1035511	Roton Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_7	195	195
2769794	CT	school	903090	1030011	Norwalk School District	90309000661	1035411	West Rocks Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_7	257	257
2769795	CT	school	903090	1030011	Norwalk School District	90309000638	1036211	Brien McMahon High School	Public Schools	Regular School	No	High	09	12	2020	grade_7	0	0
2769796	CT	school	903090	1030011	Norwalk School District	90309001917	1030511	Center for Global Studies	Public Schools	Regular School	No	High	09	12	2020	grade_7	0	0
2769797	CT	school		1030011	Norwalk School District		1031011	Norwalk Alternative Opportunity Program	Program						2020	grade_7	0	0
2769798	CT	school	903090	1030011	Norwalk School District	90309000655	1036111	Norwalk High School	Public Schools	Regular School	No	High	09	12	2020	grade_7	0	0
2769799	CT	school	903090	1030011	Norwalk School District	90309001923	1030911	P-TECH Norwalk	Public Schools	Regular School	No	High	09	12	2020	grade_7	0	0
2769800	CT	school		1030011	Norwalk School District		1031111	Norwalk 18-21 Next Steps (NNS)	Program						2020	grade_7	0	0
2769801	CT	school		1030011	Norwalk School District		1030611	Norwalk 18-21 Project SEARCH	Program						2020	grade_7	0	0
2771239	CT	school	903090	1030011	Norwalk School District	90309000640	1030211	Brookside Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_8	0	0
2771240	CT	school	903090	1030011	Norwalk School District	90309000645	1032011	Fox Run Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_8	0	0
2771241	CT	school	903090	1030011	Norwalk School District	90309000648	1030711	Jefferson Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_8	0	0