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 "year" = :p2 order by total desc 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
2741088	CT	school	904620	1440011	Trumbull School District	90462001469	1441011	Frenchtown Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	99	99
2740018	CT	school	900450	150011	Bridgeport School District	90045000053	154011	Blackham School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_1	98	98
2740020	CT	school	900450	150011	Bridgeport School District	90045000070	151411	Cesar Batalla School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_1	98	98
2740065	CT	school	900510	170011	Bristol School District	90051001624	172011	West Bristol School	Public Schools	Regular School	No	Elementary	KG	08	2021	grade_1	98	98
2740173	CT	school	901020	340011	Danbury School District	90102000157	340811	Park Avenue School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	98	98
2741004	CT	school	904320	1350011	Stamford School District	90432000167	1352211	Hart School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	98	98
2740952	CT	school	904110	1280011	Simsbury School District	90411000814	1280711	Squadron Line School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_1	96	96
2740965	CT	school	904170	1320011	South Windsor School District	90417000825	1320211	Pleasant Valley School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	96	96
2740024	CT	school	900450	150011	Bridgeport School District	90045000087	153211	Geraldine Johnson School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_1	95	95
2740513	CT	school	902310	770011	Manchester School District	90231000429	771211	Verplanck School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_1	95	95
2740514	CT	school	902310	770011	Manchester School District	90231000430	771311	Waddell School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_1	95	95
2740534	CT	school	902400	800011	Meriden School District	90240000440	801111	Casimir Pulaski School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	95	95
2741320	CT	school	900024	2790013	Amistad Academy District	90002400981	2795113	Amistad Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2021	grade_1	95	95
2739972	CT	school	900120	40011	Avon School District	90012000013	40311	Roaring Brook School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_1	94	94
2740727	CT	school	902820	950011	New London School District	90282000597	950811	Winthrop STEM Elementary Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	94	94
2740967	CT	school	904170	1320011	South Windsor School District	90417000824	1320611	Orchard Hill School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	94	94
2741007	CT	school	904320	1350011	Stamford School District	90432000860	1350611	Newfield School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	94	94
2741011	CT	school	904320	1350011	Stamford School District	90432000866	1351111	Springdale School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	94	94
2741318	CT	school	900208	2850013	Achievement First Bridgeport Academy District	90020801493	2850113	Achievement First Bridgeport Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2021	grade_1	94	94
2739963	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2021	grade_1	93	93
2741161	CT	school	904830	1510011	Waterbury School District	90483000974	1511111	Margaret M. Generali Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	93	93
2740264	CT	school	901440	480011	Ellington School District	90144000239	480611	Windermere School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_1	92	92
2740274	CT	school	901470	490011	Enfield School District	90147000244	490211	Enfield Street School	Public Schools	Regular School	No	Elementary	KG	02	2021	grade_1	92	92
2740327	CT	school	901620	540011	Glastonbury School District	90162000286	540611	Hopewell School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	92	92
2740412	CT	school	901920	640011	Hartford School District	90192000364	640811	M. D. Fox School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	92	92
2740596	CT	school	902550	850011	Monroe School District	90255000488	850511	Fawn Hollow Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	92	92
2741009	CT	school	904320	1350011	Stamford School District	90432000864	1350811	Rogers International School	Public Schools	Regular School	No	Elementary	KG	08	2021	grade_1	92	92
2741315	CT	school	905310	1670011	Woodbridge School District	90531001611	1670311	Beecher Road School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_1	92	92
2740055	CT	school	900510	170011	Bristol School District	90051000098	170511	Greene-Hills School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_1	91	91
2740489	CT	school	902160	720011	Ledyard School District	90216000398	720411	Gallup Hill School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	91	91
2740726	CT	school	902820	950011	New London School District	90282000594	950911	Nathan Hale Arts Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	91	91
2740931	CT	school	903990	1240011	Seymour School District	90399001642	1240211	Chatfield-LoPresti School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	91	91
2740533	CT	school	902400	800011	Meriden School District	90240000451	801011	Thomas Hooker School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	90	90
2740613	CT	school	902640	880011	Naugatuck School District	90264001223	880311	Maple Hill School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_1	90	90
2740678	CT	school	902790	930011	New Haven School District	90279000554	931611	Fair Haven School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_1	90	90
2741005	CT	school	904320	1350011	Stamford School District	90432000858	1351211	Julia A. Stark School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	90	90
2741090	CT	school	904620	1440011	Trumbull School District	90462000934	1440311	Middlebrook School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	90	90
2740253	CT	school	901380	390011	Eastford School District	90138000232	390111	Eastford Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_1	9	9
2740930	CT	school	903960	1230011	Scotland School District	90396000789	1230111	Scotland Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_1	9	9
2740170	CT	school	901020	340011	Danbury School District	90102000153	341311	King Street Primary School	Public Schools	Regular School	No	Elementary	KG	03	2021	grade_1	89	89
2740171	CT	school	901020	340011	Danbury School District	90102000154	340511	Mill Ridge Primary School	Public Schools	Regular School	No	Elementary	KG	03	2021	grade_1	89	89
2740975	CT	school	904230	1310011	Southington School District	90423000829	1311511	Derynoski Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	89	89
2741016	CT	school	904320	1350011	Stamford School District	90432000872	1351411	Westover School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	89	89
2740137	CT	school	900810	270011	Clinton School District	90081000132	270311	Lewin G. Joel Jr. School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_1	88	88
2740216	CT	school	901260	430011	East Hartford School District	90126000196	431011	Dr. Thomas S. O'Connell School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	88	88
2740535	CT	school	902400	800011	Meriden School District	90240000443	800411	Israel Putnam School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	88	88
2740854	CT	school	903510	1170011	Redding School District	90351000722	1170111	Redding Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_1	87	87
2740960	CT	school	904140	1290011	Somers School District	90414000526	1290411	Somers Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	87	87
2741131	CT	school	904830	1510011	Waterbury School District	90483000966	1512111	B. W. Tinker School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	87	87
2741138	CT	school	904830	1510011	Waterbury School District	90483000541	1513111	Maloney Interdistrict Magnet School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	87	87
2741231	CT	school	904950	1560011	West Haven School District	90495001035	1560311	Forest School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_1	87	87
2741300	CT	school	905220	1640011	Windsor School District	90522001093	1640511	Poquonock Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_1	87	87
2740169	CT	school	901020	340011	Danbury School District	90102000159	341411	Ellsworth Avenue School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	86	86
2740243	CT	school	901350	470011	East Windsor School District	90135000228	470111	Broad Brook Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_1	86	86
2740478	CT	school	903450	2450014	Learn	90345000079	2450114	Regional Multicultural Magnet School	Regional Education Service Center Schools	Regular School	No	Elementary	KG	05	2021	grade_1	86	86
2740723	CT	school	902820	950011	New London School District	90282000591	950311	C.B. Jennings International Elementary Magnet	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	86	86
2740775	CT	school	903090	1030011	Norwalk School District	90309000649	1030811	Kendall Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	86	86
2741110	CT	school	904740	1480011	Wallingford School District	90474000950	1481011	Cook Hill School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_1	86	86
2741232	CT	school	904950	1560011	West Haven School District	90495001038	1561411	Savin Rock Community School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_1	86	86
2739962	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_1	85	85
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
2740033	CT	school	900450	150011	Bridgeport School District	90045000080	152511	Read School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_1	85	85
2740530	CT	school	902400	800011	Meriden School District	90240000445	800511	John Barry School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	85	85
2740740	CT	school	902880	940011	Newington School District	90288000606	940811	John Paterson School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_1	85	85
2740782	CT	school	903090	1030011	Norwalk School District	90309000659	1032311	Silvermine Dual Language Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	85	85
2740783	CT	school	903090	1030011	Norwalk School District	90309000660	1031411	Tracey Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	85	85
2740922	CT	school	903840	1190011	Rocky Hill School District	90384000784	1190411	Myrtle H. Stevens School	Public Schools	Regular School	No	Elementary	PK	03	2021	grade_1	85	85
2741085	CT	school	904620	1440011	Trumbull School District	90462000927	1440111	Booth Hill School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	85	85
2741316	CT	school	905370	1690011	Woodstock School District	90537001110	1690211	Woodstock Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_1	85	85
2740329	CT	school	901620	540011	Glastonbury School District	90162001447	540911	Nayaug Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	84	84
2740631	CT	school	902670	890011	New Britain School District	90267000515	890811	Lincoln Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	84	84
2740638	CT	school	902670	890011	New Britain School District	90267000527	891511	Vance Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	84	84
2740650	CT	school	902700	900011	New Canaan School District	90270000534	900311	West School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_1	84	84
2740894	CT	school	903539	2170012	Regional School District 17	90353900757	2170212	Burr District Elementary School	Regional Schools	Regular School	No	Elementary	KG	03	2021	grade_1	84	84
2741141	CT	school	904830	1510011	Waterbury School District	90483001131	1513311	Rotella Interdistrict Magnet School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	84	84
2740175	CT	school	901020	340011	Danbury School District	90102000161	341211	Shelter Rock School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	83	83
2740177	CT	school	901020	340011	Danbury School District	90102000163	341611	Stadley Rough School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	83	83
2740630	CT	school	902670	890011	New Britain School District	90267000510	891111	DiLoreto Elementary & Middle School	Public Schools	Regular School	No	Elementary	KG	08	2021	grade_1	83	83
2740781	CT	school	903090	1030011	Norwalk School District	90309000658	1031311	Rowayton School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	83	83
2740092	CT	school	900570	190011	Brooklyn School District	90057000113	190111	Brooklyn Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_1	82	82
2740464	CT	school	902010	670011	Hebron School District	90201000387	670211	Gilead Hill School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_1	82	82
2741254	CT	school	905040	1580011	Westport School District	90504001056	1580711	Long Lots School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	82	82
2740168	CT	school	901020	340011	Danbury School District	90102000152	340211	Hayestown Avenue School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	81	81
2740502	CT	school	902280	760011	Madison School District	90228000413	760311	Kathleen H. Ryerson Elementary School	Public Schools	Regular School	No	Elementary	KG	03	2021	grade_1	81	81
2740531	CT	school	902400	800011	Meriden School District	90240000448	800711	Nathan Hale School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	81	81
2740254	CT	school	901410	460011	Easton School District	90141000234	460111	Samuel Staples Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	80	80
2740490	CT	school	902160	720011	Ledyard School District	90216000397	720211	Gales Ferry School	Public Schools	Regular School	No	Elementary	KG	02	2021	grade_1	80	80
2740942	CT	school	904050	1260011	Shelton School District	90405000798	1260511	Elizabeth Shelton School	Public Schools	Regular School	No	Elementary	KG	04	2021	grade_1	80	80
2740963	CT	school	904170	1320011	South Windsor School District	90417000822	1320711	Eli Terry School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	80	80
2740063	CT	school		170011	Bristol School District	90051001707	173211	Stafford Autism	Program						2021	grade_1	8	8
2741038	CT	school		1380011	Stratford School District	90444001734	1380611	ABA - K-6	Program						2021	grade_1	8	8
2741156	CT	school		1510011	Waterbury School District		1513511	Generali Autism	Program						2021	grade_1	8	8
2741332	CT	school	900630	210011	Canaan School District	90063000115	210111	Lee H. Kellogg School	Public Schools	Regular School	No	Elementary	KG	08	2021	grade_1	8	8
2740058	CT	school	900510	170011	Bristol School District	90051000105	171111	South Side School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	79	79
2740597	CT	school	902550	850011	Monroe School District	90255000491	850311	Stepney Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	79	79
2740862	CT	school	903520	2100012	Regional School District 10	90352000729	2100212	Lake Garda Elementary School	Regional Schools	Regular School	No	Elementary	PK	04	2021	grade_1	79	79
2741113	CT	school	904740	1480011	Wallingford School District	90474000957	1480111	Moses Y. Beach School	Public Schools	Regular School	No	Elementary	PK	02	2021	grade_1	79	79
2740190	CT	school	901050	350011	Darien School District	90105000498	350711	Holmes Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	78	78
2740365	CT	school	901770	590011	Groton School District	90177001488	591911	Northeast Academy Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	78	78
2740774	CT	school	903090	1030011	Norwalk School District	90309000648	1030711	Jefferson Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2021	grade_1	77	77
2740984	CT	school	904230	1310011	Southington School District	90423000840	1310911	Thalberg Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2021	grade_1	77	77