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
2439646	CT	school	904050	1260011	Shelton School District	90405000798	1260511	Elizabeth Shelton School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_4	98	98
2439719	CT	school	904320	1350011	Stamford School District	90432000860	1350611	Newfield School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	98	98
2439841	CT	school	904830	1510011	Waterbury School District	90483000966	1512111	B. W. Tinker School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	98	98
2440013	CT	school	905220	1640011	Windsor School District	90522001087	1640111	Clover Street School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_4	98	98
2439349	CT	school	902670	890011	New Britain School District	90267000524	891311	Smith Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	97	97
2439721	CT	school	904320	1350011	Stamford School District	90432000866	1351111	Springdale School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	97	97
2439107	CT	school	901920	640011	Hartford School District	90192000636	643211	Expeditionary Learning Academy at Moylan School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	96	96
2439851	CT	school	904830	1510011	Waterbury School District	90483001131	1513311	Rotella Interdistrict Magnet School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	96	96
2439336	CT	school	902670	890011	New Britain School District	90267000510	891111	DiLoreto Elementary & Middle School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_4	95	95
2439715	CT	school	904320	1350011	Stamford School District	90432000865	1350911	Roxbury School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	95	95
2440030	CT	school	900212	2880013	Achievement First Hartford Academy District	90021201528	2880113	Achievement First Hartford Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2019	grade_4	95	95
2438761	CT	school	900510	170011	Bristol School District	90051000098	170511	Greene-Hills School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_4	94	94
2439493	CT	school	903090	1030011	Norwalk School District	90309000659	1032311	Silvermine Dual Language Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	94	94
2438956	CT	school	901410	460011	Easton School District	90141000234	460111	Samuel Staples Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	93	93
2439241	CT	school	902400	800011	Meriden School District	90240000442	800311	Hanover School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	93	93
2439243	CT	school	902400	800011	Meriden School District	90240000445	800511	John Barry School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	93	93
2439487	CT	school	903090	1030011	Norwalk School District	90309000648	1030711	Jefferson Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	93	93
2439854	CT	school	904830	1510011	Waterbury School District	90483000987	1512211	Walsh School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	93	93
2438659	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_4	92	92
2439720	CT	school	904320	1350011	Stamford School District	90432000864	1350811	Rogers International School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_4	92	92
2438730	CT	school	900450	150011	Bridgeport School District	90045000087	153211	Geraldine Johnson School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_4	91	91
2438965	CT	school	901440	480011	Ellington School District	90144000239	480611	Windermere School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_4	91	91
2439551	CT	school	903390	1130011	Portland School District	90339000711	1130411	Gildersleeve School	Public Schools	Regular School	No	Elementary	02	04	2019	grade_4	91	91
2439828	CT	school	904740	1480011	Wallingford School District	90474001213	1480311	Parker Farms School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_4	91	91
2440031	CT	school	900024	2790013	Amistad Academy District	90002400981	2795113	Amistad Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2019	grade_4	91	91
2438686	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	90	90
2438878	CT	school	901020	340011	Danbury School District	90102000163	341611	Stadley Rough School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	90	90
2439310	CT	school	902550	850011	Monroe School District	90255000488	850511	Fawn Hollow Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	90	90
2439830	CT	school	904740	1480011	Wallingford School District	90474000961	1480411	Rock Hill School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_4	90	90
2440029	CT	school	900208	2850013	Achievement First Bridgeport Academy District	90020801493	2850113	Achievement First Bridgeport Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2019	grade_4	90	90
2438744	CT	school		150011	Bridgeport School District	90045001472	159011	Bridgeport Learning Center	Program						2019	grade_4	9	9
2439338	CT	school		890011	New Britain School District		891611	Gaffney KEY Elementary	Program						2019	grade_4	9	9
2439577	CT	school	903530	2120012	Regional School District 12	90353000734	2120112	The Burnham School	Regional Schools	Regular School	No	Elementary	KG	05	2019	grade_4	9	9
2439876	CT	school		1510011	Waterbury School District		1510111	Bunker Hill BDLC	Program						2019	grade_4	9	9
2438920	CT	school	901260	430011	East Hartford School District	90126000196	431011	Dr. Thomas S. O'Connell School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	89	89
2439492	CT	school	903090	1030011	Norwalk School District	90309000658	1031311	Rowayton School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	89	89
2439676	CT	school	904170	1320011	South Windsor School District	90417000825	1320211	Pleasant Valley School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	89	89
2439684	CT	school	904230	1310011	Southington School District	90423000829	1311511	Derynoski Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	89	89
2439718	CT	school	904320	1350011	Stamford School District	90432000858	1351211	Julia A. Stark School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	89	89
2438660	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2019	grade_4	88	88
2439327	CT	school	902640	880011	Naugatuck School District	90264001223	880311	Maple Hill School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_4	88	88
2439490	CT	school	903090	1030011	Norwalk School District	90309000649	1030811	Kendall Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	88	88
2439599	CT	school	903538	2160012	Regional School District 16	90353801811	2160512	Prospect Elementary School	Regional Schools	Regular School	No	Elementary	PK	05	2019	grade_4	88	88
2439848	CT	school	904830	1510011	Waterbury School District	90483000541	1513111	Maloney Interdistrict Magnet School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	88	88
2440027	CT	school	905370	1690011	Woodstock School District	90537001110	1690211	Woodstock Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_4	88	88
2438879	CT	school	901020	340011	Danbury School District	90102000159	341411	Ellsworth Avenue School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	87	87
2439047	CT	school	901710	570011	Greenwich School District	90171000304	570711	North Mianus School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	87	87
2439246	CT	school	902400	800011	Meriden School District	90240000450	800811	Roger Sherman School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	87	87
2439389	CT	school	902790	930011	New Haven School District	90279000554	931611	Fair Haven School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_4	87	87
2439641	CT	school	903990	1240011	Seymour School District	90399000790	1240111	Bungay School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	87	87
2439015	CT	school	901560	520011	Farmington School District	90156001206	520411	East Farms School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_4	86	86
2439869	CT	school	904830	1510011	Waterbury School District	90483000974	1511111	Margaret M. Generali Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	86	86
2439439	CT	school	902820	950011	New London School District	90282000597	950811	Winthrop STEM Elementary Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	85	85
2439460	CT	school	902910	970011	Newtown School District	90291000614	970311	Middle Gate Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_4	85	85
2439864	CT	school	904830	1510011	Waterbury School District	90483000975	1511411	F. J. Kingsbury School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	85	85
2439968	CT	school	905040	1580011	Westport School District	90504001363	1580811	Saugatuck Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	85	85
2438891	CT	school	901050	350011	Darien School District	90105000165	350211	Hindley Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	84	84
2439341	CT	school	902670	890011	New Britain School District	90267000513	890611	Holmes Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	84	84
2439640	CT	school	903990	1240011	Seymour School District	90399001642	1240211	Chatfield-LoPresti School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	84	84
2438796	CT	school	900570	190011	Brooklyn School District	90057000113	190111	Brooklyn Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_4	83	83
2439024	CT	school	901620	540011	Glastonbury School District	90162000280	540211	Buttonball Lane School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	83	83
2439561	CT	school	903510	1170011	Redding School District	90351000722	1170111	Redding Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_4	83	83
2439572	CT	school	903520	2100012	Regional School District 10	90352000729	2100212	Lake Garda Elementary School	Regional Schools	Regular School	No	Elementary	PK	04	2019	grade_4	83	83
2439751	CT	school	904440	1380011	Stratford School District	90444000898	1381311	Eli Whitney School	Public Schools	Regular School	No	Elementary	KG	06	2019	grade_4	83	83
2439757	CT	school	904440	1380011	Stratford School District	90444000892	1381511	Stratford Academy - Johnson House	Public Schools	Regular School	No	Elementary	02	06	2019	grade_4	83	83
2439800	CT	school	904620	1440011	Trumbull School District	90462000934	1440311	Middlebrook School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	83	83
2439966	CT	school	905040	1580011	Westport School District	90504001055	1580511	King's Highway Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	83	83
2439452	CT	school	902880	940011	Newington School District	90288000606	940811	John Paterson School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_4	82	82
2439491	CT	school	903090	1030011	Norwalk School District	90309000651	1032211	Marvin Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	82	82
2439660	CT	school	904110	1280011	Simsbury School District	90411000814	1280711	Squadron Line School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_4	82	82
2439844	CT	school	904830	1510011	Waterbury School District	90483000972	1510911	Driggs School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	82	82
2439967	CT	school	905040	1580011	Westport School District	90504001056	1580711	Long Lots School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	82	82
2438685	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	81	81
2439169	CT	school	902010	670011	Hebron School District	90201000388	670111	Hebron Elementary School	Public Schools	Regular School	No	Elementary	03	06	2019	grade_4	81	81
2439591	CT	school	903537	2150012	Regional School District 15	90353700708	2150712	Long Meadow Elementary School	Regional Schools	Regular School	No	Elementary	PK	05	2019	grade_4	81	81
2439645	CT	school	904050	1260011	Shelton School District	90405000796	1261011	Booth Hill School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_4	81	81
2439739	CT	school	904380	1370011	Stonington School District	90438000876	1370511	Deans Mill School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_4	81	81
2439797	CT	school	904620	1440011	Trumbull School District	90462000929	1440811	Daniels Farm School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	81	81
2439853	CT	school	904830	1510011	Waterbury School District	90483000986	1512011	Sprague School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	81	81
2439212	CT	school	902280	760011	Madison School District	90228000410	760111	J. Milton Jeffrey Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_4	80	80
2439557	CT	school	903480	1160011	Putnam School District	90348000718	1160311	Putnam Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	80	80
2439996	CT	school	905190	1630011	Windham School District	90519001214	1630311	North Windham School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	80	80
2438665	CT	school		2440014	Area Cooperative Educational Services	90007001499	2449514	Village School	Program						2019	grade_4	8	8
2438857	CT	school		2430014	Cooperative Educational Services	90091001573	2439414	Therapeutic Day Program	Program						2019	grade_4	8	8
2438925	CT	school		430011	East Hartford School District	90126000205	439011	Woodland School	Program						2019	grade_4	8	8
2439476	CT	school	903030	1010011	North Haven School District	90303000633	1010311	Ridge Road Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	79	79
2439795	CT	school	904620	1440011	Trumbull School District	90462000927	1440111	Booth Hill School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	79	79
2438837	CT	school	900750	250011	Cheshire School District	90075000126	250611	Doolittle School	Public Schools	Regular School	No	Elementary	01	06	2019	grade_4	78	78
2438895	CT	school	901050	350011	Darien School District	90105000498	350711	Holmes Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	78	78
2439026	CT	school	901620	540011	Glastonbury School District	90162000286	540611	Hopewell School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	78	78
2439311	CT	school	902550	850011	Monroe School District	90255000491	850311	Stepney Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	78	78
2439450	CT	school	902880	940011	Newington School District	90288000611	940611	Anna Reynolds School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_4	78	78
2439672	CT	school	904170	1320011	South Windsor School District	90417000822	1320711	Eli Terry School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	78	78
2439692	CT	school	904230	1310011	Southington School District	90423000840	1310911	Thalberg Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_4	78	78
2439713	CT	school	904320	1350011	Stamford School District	90432000859	1350511	K. T. Murphy School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	78	78
2439809	CT	school	904680	1460011	Vernon School District	90468000939	1461411	Center Road School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	78	78
2438735	CT	school	900450	150011	Bridgeport School District	90045000090	153611	John Winthrop School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_4	77	77
2438748	CT	school	900450	150011	Bridgeport School District	90045000074	152011	Madison School	Public Schools	Regular School	No	Elementary	KG	06	2019	grade_4	77	77
2438764	CT	school	900510	170011	Bristol School District	90051000105	171111	South Side School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	77	77
2438894	CT	school	901050	350011	Darien School District	90105000172	350611	Tokeneke Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_4	77	77
2439016	CT	school	901560	520011	Farmington School District	90156000275	520211	Noah Wallace School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_4	77	77