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
2760757	CT	school	902310	770011	Manchester School District	90231000430	771311	Waddell School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_1	99	99
2761255	CT	school	904320	1350011	Stamford School District	90432000868	1352111	Stillmeadow School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	99	99
2761354	CT	school	904740	1480011	Wallingford School District	90474000952	1480911	Evarts C. Stevens School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	99	99
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
2760262	CT	school	900450	150011	Bridgeport School District	90045000053	154011	Blackham School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_1	97	97
2760372	CT	school	900750	250011	Cheshire School District	90075000127	250411	Highland School	Public Schools	Regular School	No	Elementary	KG	06	2020	grade_1	97	97
2760857	CT	school	902640	880011	Naugatuck School District	90264001223	880311	Maple Hill School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_1	97	97
2761130	CT	school	903538	2160012	Regional School District 16	90353801811	2160512	Prospect Elementary School	Regional Schools	Regular School	No	Elementary	PK	05	2020	grade_1	97	97
2761568	CT	school	900212	2880013	Achievement First Hartford Academy District	90021201528	2880113	Achievement First Hartford Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2020	grade_1	97	97
2761569	CT	school	900024	2790013	Amistad Academy District	90002400981	2795113	Amistad Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2020	grade_1	97	97
2761567	CT	school	900208	2850013	Achievement First Bridgeport Academy District	90020801493	2850113	Achievement First Bridgeport Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2020	grade_1	96	96
2760229	CT	school	900270	90011	Bethel School District	90027000027	90111	Frank A. Berry School	Public Schools	Regular School	No	Elementary	PK	03	2020	grade_1	95	95
2760336	CT	school	900570	190011	Brooklyn School District	90057000113	190111	Brooklyn Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	95	95
2760586	CT	school	901710	570011	Greenwich School District	90171000304	570711	North Mianus School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	95	95
2760587	CT	school	901710	570011	Greenwich School District	90171000308	571011	Riverside School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	95	95
2760461	CT	school	901260	430011	East Hartford School District	90126000196	431011	Dr. Thomas S. O'Connell School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	94	94
2761084	CT	school	903390	1130011	Portland School District	90339000714	1130211	Valley View School	Public Schools	Regular School	No	Elementary	PK	01	2020	grade_1	94	94
2761253	CT	school	904320	1350011	Stamford School District	90432000864	1350811	Rogers International School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_1	94	94
2761377	CT	school	904830	1510011	Waterbury School District	90483000966	1512111	B. W. Tinker School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	94	94
2760230	CT	school	900270	90011	Bethel School District	90027000023	90411	Anna H. Rockwell School	Public Schools	Regular School	No	Elementary	KG	03	2020	grade_1	93	93
2760310	CT	school	900510	170011	Bristol School District	90051001624	172011	West Bristol School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_1	93	93
2761254	CT	school	904320	1350011	Stamford School District	90432000866	1351111	Springdale School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	93	93
2761480	CT	school	904950	1560011	West Haven School District	90495001038	1561411	Savin Rock Community School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	93	93
2761251	CT	school	904320	1350011	Stamford School District	90432000860	1350611	Newfield School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	92	92
2761385	CT	school	904830	1510011	Waterbury School District	90483000541	1513111	Maloney Interdistrict Magnet School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	92	92
2760268	CT	school	900450	150011	Bridgeport School District	90045000087	153211	Geraldine Johnson School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_1	91	91
2760299	CT	school	900510	170011	Bristol School District	90051000098	170511	Greene-Hills School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_1	90	90
2760777	CT	school	902400	800011	Meriden School District	90240000448	800711	Nathan Hale School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	90	90
2760840	CT	school	902550	850011	Monroe School District	90255000488	850511	Fawn Hollow Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	90	90
2760782	CT	school		800011	Meriden School District		800911	STEP - ES	Program						2020	grade_1	9	9
2760996	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_1	9	9
2760195	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_1	88	88
2760744	CT	school	902280	760011	Madison School District	90228000410	760111	J. Milton Jeffrey Elementary School	Public Schools	Regular School	No	Elementary	KG	03	2020	grade_1	88	88
2760778	CT	school	902400	800011	Meriden School District	90240000440	801111	Casimir Pulaski School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	88	88
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
2761164	CT	school	903840	1190011	Rocky Hill School District	90384000784	1190411	Myrtle H. Stevens School	Public Schools	Regular School	No	Elementary	PK	03	2020	grade_1	88	88
2761476	CT	school	904950	1560011	West Haven School District	90495001040	1561211	Washington School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	88	88
2760512	CT	school	901470	490011	Enfield School District	90147000244	490211	Enfield Street School	Public Schools	Regular School	No	Elementary	KG	02	2020	grade_1	87	87
2760877	CT	school	902670	890011	New Britain School District	90267000524	891311	Smith Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	87	87
2760919	CT	school	902790	930011	New Haven School District	90279000554	931611	Fair Haven School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_1	87	87
2761203	CT	school	904140	1290011	Somers School District	90414000526	1290411	Somers Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	87	87
2760259	CT	school	900450	150011	Bridgeport School District	90045000049	150111	Barnum School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_1	86	86
2760965	CT	school	902820	950011	New London School District	90282000591	950311	C.B. Jennings International Elementary Magnet	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	86	86
2761248	CT	school	904320	1350011	Stamford School District	90432000865	1350911	Roxbury School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	86	86
2761330	CT	school	904620	1440011	Trumbull School District	90462000929	1440811	Daniels Farm School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	86	86
2760719	CT	school	903450	2450014	Learn	90345000079	2450114	Regional Multicultural Magnet School	Regional Education Service Center Schools	Regular School	No	Elementary	KG	05	2020	grade_1	85	85
2760867	CT	school	902670	890011	New Britain School District	90267000513	890611	Holmes Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	85	85
2760879	CT	school	902670	890011	New Britain School District	90267000527	891511	Vance Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	85	85
2760969	CT	school	902820	950011	New London School District	90282000597	950811	Winthrop STEM Elementary Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	85	85
2761353	CT	school	904740	1480011	Wallingford School District	90474000950	1481011	Cook Hill School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	85	85
2760196	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2020	grade_1	84	84
2760493	CT	school	901410	460011	Easton School District	90141000234	460111	Samuel Staples Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	84	84
2760563	CT	school	901620	540011	Glastonbury School District	90162000280	540211	Buttonball Lane School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	84	84
2760567	CT	school	901620	540011	Glastonbury School District	90162001447	540911	Nayaug Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	84	84
2760968	CT	school	902820	950011	New London School District	90282000594	950911	Nathan Hale Arts Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	84	84
2761355	CT	school	904740	1480011	Wallingford School District	90474000953	1480211	Highland School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	84	84
2761388	CT	school	904830	1510011	Waterbury School District	90483001131	1513311	Rotella Interdistrict Magnet School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	84	84
2761459	CT	school	904920	1550011	West Hartford School District	90492001014	1550611	Duffy School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	84	84
2760733	CT	school	902160	720011	Ledyard School District	90216000397	720211	Gales Ferry School	Public Schools	Regular School	No	Elementary	KG	02	2020	grade_1	83	83
2761122	CT	school	903537	2150012	Regional School District 15	90353700708	2150712	Long Meadow Elementary School	Regional Schools	Regular School	No	Elementary	PK	05	2020	grade_1	83	83
2761379	CT	school	904830	1510011	Waterbury School District	90483000969	1510611	Bunker Hill School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	83	83
2761400	CT	school	904830	1510011	Waterbury School District	90483000975	1511411	F. J. Kingsbury School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	83	83
2760422	CT	school	901020	340011	Danbury School District	90102000163	341611	Stadley Rough School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	82	82
2760554	CT	school	901560	520011	Farmington School District	90156001206	520411	East Farms School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_1	82	82
2760732	CT	school	902160	720011	Ledyard School District	90216000398	720411	Gallup Hill School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	82	82
2760894	CT	school	902700	900011	New Canaan School District	90270000533	900211	South School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_1	82	82
2761181	CT	school	904050	1260011	Shelton School District	90405000798	1260511	Elizabeth Shelton School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	82	82
2761452	CT	school	904920	1550011	West Hartford School District	90492001012	1550511	Charter Oak International Academy	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	82	82
2761477	CT	school	904950	1560011	West Haven School District	90495001027	1560811	Alma E. Pagels School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	82	82
2760431	CT	school	901050	350011	Darien School District	90105000165	350211	Hindley Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	81	81
2760488	CT	school	901350	470011	East Windsor School District	90135000228	470111	Broad Brook Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	81	81
2760565	CT	school	901620	540011	Glastonbury School District	90162000286	540611	Hopewell School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	81	81
2761174	CT	school	903990	1240011	Seymour School District	90399001642	1240211	Chatfield-LoPresti School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	81	81
2761381	CT	school	904830	1510011	Waterbury School District	90483000972	1510911	Driggs School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	81	81
2760871	CT	school	902670	890011	New Britain School District	90267000514	890711	Jefferson Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	80	80
2760982	CT	school	902880	940011	Newington School District	90288000606	940811	John Paterson School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	80	80
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
2761095	CT	school	903510	1170011	Redding School District	90351000722	1170111	Redding Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	80	80
2761125	CT	school	903537	2150012	Regional School District 15	90353700750	2150512	Pomperaug School	Regional Schools	Regular School	No	Elementary	KG	05	2020	grade_1	80	80
2761182	CT	school	904050	1260011	Shelton School District	90405000803	1260811	Long Hill School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	80	80
2761479	CT	school	904950	1560011	West Haven School District	90495001035	1560311	Forest School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	80	80
2761481	CT	school	904950	1560011	West Haven School District	90495001039	1560411	Seth G. Haley School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	80	80
2760202	CT	school		2440014	Area Cooperative Educational Services	90007001499	2449514	Village School	Program						2020	grade_1	8	8
2760630	CT	school		620011	Hamden School District		621811	West Woods IIC	Program						2020	grade_1	8	8
2760674	CT	school		640011	Hartford School District	90192001732	645711	iGOAL 1 - M.D. Fox School	Program						2020	grade_1	8	8
2761408	CT	school		1510011	Waterbury School District	90483000958	1519011	State Street School	Program						2020	grade_1	8	8
2761575	CT	school	900930	310011	Cornwall School District	90093000140	310111	Cornwall Consolidated School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_1	8	8
2760539	CT	school	901530	510011	Fairfield School District	90153000262	510611	McKinley School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	79	79
2760651	CT	school	901920	640011	Hartford School District	90192000364	640811	M. D. Fox School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_1	79	79
2761332	CT	school	904620	1440011	Trumbull School District	90462000931	1440411	Jane Ryan School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	79	79
2761565	CT	school	905370	1690011	Woodstock School District	90537001110	1690211	Woodstock Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	79	79
2761570	CT	school	900217	2950013	Booker T. Washington Academy District	90021701750	2950113	Booker T. Washington Academy	Public Charter Schools	Regular School	Yes	Elementary	KG	06	2020	grade_1	79	79
2760873	CT	school	902670	890011	New Britain School District	90267000510	891111	DiLoreto Elementary & Middle School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_1	78	78
2761334	CT	school	904620	1440011	Trumbull School District	90462000936	1440911	Tashua School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	78	78
2761451	CT	school	904920	1550011	West Hartford School District	90492000004	1551611	Aiken School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	78	78
2761503	CT	school	905040	1580011	Westport School District	90504001056	1580711	Long Lots School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	78	78
2760749	CT	school	902310	770011	Manchester School District	90231000418	770311	Buckley School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	77	77
2760872	CT	school	902670	890011	New Britain School District	90267000509	890311	Chamberlain Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	77	77
2760892	CT	school	902700	900011	New Canaan School District	90270000534	900311	West School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	77	77
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
2761054	CT	school	903180	1060011	Old Saybrook School District	90318000681	1060211	Kathleen E. Goodwin School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_1	77	77