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
2759573	CT	school		1030011	Norwalk School District		1031111	Norwalk 18-21 Next Steps (NNS)	Program						2020	kindergarten	0	0
2759574	CT	school		1030011	Norwalk School District		1030611	Norwalk 18-21 Project SEARCH	Program						2020	kindergarten	0	0
2761012	CT	school	903090	1030011	Norwalk School District	90309000640	1030211	Brookside Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	65	65
2761013	CT	school	903090	1030011	Norwalk School District	90309000645	1032011	Fox Run Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	72	72
2761014	CT	school	903090	1030011	Norwalk School District	90309000648	1030711	Jefferson Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	68	68
2761015	CT	school	903090	1030011	Norwalk School District	90309000649	1030811	Kendall Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	77	77
2761016	CT	school	903090	1030011	Norwalk School District	90309000652	1032111	Naramake Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	52	52
2761017	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
2761018	CT	school	903090	1030011	Norwalk School District	90309000642	1030311	Columbus Magnet School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_1	44	44
2761019	CT	school	903090	1030011	Norwalk School District	90309000643	1030411	Cranbury Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	76	76
2761020	CT	school	903090	1030011	Norwalk School District	90309000651	1032211	Marvin Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	72	72
2761021	CT	school	903090	1030011	Norwalk School District	90309000658	1031311	Rowayton School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	98	98
2761022	CT	school	903090	1030011	Norwalk School District	90309000659	1032311	Silvermine Dual Language Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	88	88
2761023	CT	school	903090	1030011	Norwalk School District	90309000660	1031411	Tracey Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	80	80
2761024	CT	school	903090	1030011	Norwalk School District	90309000662	1032411	Wolfpit School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	41	41
2761025	CT	school	903090	1030011	Norwalk School District	90309000653	1035211	Nathan Hale Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_1	0	0
2761026	CT	school	903090	1030011	Norwalk School District	90309000656	1035311	Ponus Ridge Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_1	0	0
2761027	CT	school	903090	1030011	Norwalk School District	90309000657	1035511	Roton Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_1	0	0
2761028	CT	school	903090	1030011	Norwalk School District	90309000661	1035411	West Rocks Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_1	0	0
2761029	CT	school	903090	1030011	Norwalk School District	90309000638	1036211	Brien McMahon High School	Public Schools	Regular School	No	High	09	12	2020	grade_1	0	0
2761030	CT	school	903090	1030011	Norwalk School District	90309001917	1030511	Center for Global Studies	Public Schools	Regular School	No	High	09	12	2020	grade_1	0	0
2761031	CT	school		1030011	Norwalk School District		1031011	Norwalk Alternative Opportunity Program	Program						2020	grade_1	0	0
2761032	CT	school	903090	1030011	Norwalk School District	90309000655	1036111	Norwalk High School	Public Schools	Regular School	No	High	09	12	2020	grade_1	0	0
2761033	CT	school	903090	1030011	Norwalk School District	90309001923	1030911	P-TECH Norwalk	Public Schools	Regular School	No	High	09	12	2020	grade_1	0	0
2761034	CT	school		1030011	Norwalk School District		1031111	Norwalk 18-21 Next Steps (NNS)	Program						2020	grade_1	0	0
2761035	CT	school		1030011	Norwalk School District		1030611	Norwalk 18-21 Project SEARCH	Program						2020	grade_1	0	0
2762473	CT	school	903090	1030011	Norwalk School District	90309000640	1030211	Brookside Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_2	76	76
2762474	CT	school	903090	1030011	Norwalk School District	90309000645	1032011	Fox Run Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_2	65	65
2762475	CT	school	903090	1030011	Norwalk School District	90309000648	1030711	Jefferson Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_2	74	74
2762476	CT	school	903090	1030011	Norwalk School District	90309000649	1030811	Kendall Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_2	66	66
2762477	CT	school	903090	1030011	Norwalk School District	90309000652	1032111	Naramake Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_2	65	65
2762478	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0	0
2762479	CT	school	903090	1030011	Norwalk School District	90309000642	1030311	Columbus Magnet School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_2	43	43
2762480	CT	school	903090	1030011	Norwalk School District	90309000643	1030411	Cranbury Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_2	81	81
2762481	CT	school	903090	1030011	Norwalk School District	90309000651	1032211	Marvin Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_2	70	70
2762482	CT	school	903090	1030011	Norwalk School District	90309000658	1031311	Rowayton School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_2	80	80
2762483	CT	school	903090	1030011	Norwalk School District	90309000659	1032311	Silvermine Dual Language Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_2	81	81
2762484	CT	school	903090	1030011	Norwalk School District	90309000660	1031411	Tracey Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_2	70	70
2762485	CT	school	903090	1030011	Norwalk School District	90309000662	1032411	Wolfpit School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_2	56	56
2762486	CT	school	903090	1030011	Norwalk School District	90309000653	1035211	Nathan Hale Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_2	0	0
2762487	CT	school	903090	1030011	Norwalk School District	90309000656	1035311	Ponus Ridge Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_2	0	0
2762488	CT	school	903090	1030011	Norwalk School District	90309000657	1035511	Roton Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_2	0	0
2762489	CT	school	903090	1030011	Norwalk School District	90309000661	1035411	West Rocks Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_2	0	0
2762490	CT	school	903090	1030011	Norwalk School District	90309000638	1036211	Brien McMahon High School	Public Schools	Regular School	No	High	09	12	2020	grade_2	0	0
2762491	CT	school	903090	1030011	Norwalk School District	90309001917	1030511	Center for Global Studies	Public Schools	Regular School	No	High	09	12	2020	grade_2	0	0
2762492	CT	school		1030011	Norwalk School District		1031011	Norwalk Alternative Opportunity Program	Program						2020	grade_2	0	0
2762493	CT	school	903090	1030011	Norwalk School District	90309000655	1036111	Norwalk High School	Public Schools	Regular School	No	High	09	12	2020	grade_2	0	0
2762494	CT	school	903090	1030011	Norwalk School District	90309001923	1030911	P-TECH Norwalk	Public Schools	Regular School	No	High	09	12	2020	grade_2	0	0
2762495	CT	school		1030011	Norwalk School District		1031111	Norwalk 18-21 Next Steps (NNS)	Program						2020	grade_2	0	0
2762496	CT	school		1030011	Norwalk School District		1030611	Norwalk 18-21 Project SEARCH	Program						2020	grade_2	0	0
2763934	CT	school	903090	1030011	Norwalk School District	90309000640	1030211	Brookside Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_3	54	54
2763935	CT	school	903090	1030011	Norwalk School District	90309000645	1032011	Fox Run Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_3	64	64
2763936	CT	school	903090	1030011	Norwalk School District	90309000648	1030711	Jefferson Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_3	86	86
2763937	CT	school	903090	1030011	Norwalk School District	90309000649	1030811	Kendall Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_3	72	72
2763938	CT	school	903090	1030011	Norwalk School District	90309000652	1032111	Naramake Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_3	51	51
2763939	CT	school	903090	1030011	Norwalk School District	90309001914	1030111	Norwalk Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0	0
2763940	CT	school	903090	1030011	Norwalk School District	90309000642	1030311	Columbus Magnet School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_3	42	42
2763941	CT	school	903090	1030011	Norwalk School District	90309000643	1030411	Cranbury Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_3	73	73
2763942	CT	school	903090	1030011	Norwalk School District	90309000651	1032211	Marvin Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_3	61	61
2763943	CT	school	903090	1030011	Norwalk School District	90309000658	1031311	Rowayton School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_3	65	65
2763944	CT	school	903090	1030011	Norwalk School District	90309000659	1032311	Silvermine Dual Language Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_3	79	79
2763945	CT	school	903090	1030011	Norwalk School District	90309000660	1031411	Tracey Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_3	68	68
2763946	CT	school	903090	1030011	Norwalk School District	90309000662	1032411	Wolfpit School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_3	57	57
2763947	CT	school	903090	1030011	Norwalk School District	90309000653	1035211	Nathan Hale Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_3	0	0
2763948	CT	school	903090	1030011	Norwalk School District	90309000656	1035311	Ponus Ridge Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_3	0	0
2763949	CT	school	903090	1030011	Norwalk School District	90309000657	1035511	Roton Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_3	0	0
2763950	CT	school	903090	1030011	Norwalk School District	90309000661	1035411	West Rocks Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_3	0	0
2763951	CT	school	903090	1030011	Norwalk School District	90309000638	1036211	Brien McMahon High School	Public Schools	Regular School	No	High	09	12	2020	grade_3	0	0
2763952	CT	school	903090	1030011	Norwalk School District	90309001917	1030511	Center for Global Studies	Public Schools	Regular School	No	High	09	12	2020	grade_3	0	0
2763953	CT	school		1030011	Norwalk School District		1031011	Norwalk Alternative Opportunity Program	Program						2020	grade_3	0	0
2763954	CT	school	903090	1030011	Norwalk School District	90309000655	1036111	Norwalk High School	Public Schools	Regular School	No	High	09	12	2020	grade_3	0	0
2763955	CT	school	903090	1030011	Norwalk School District	90309001923	1030911	P-TECH Norwalk	Public Schools	Regular School	No	High	09	12	2020	grade_3	0	0
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