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
2436346	CT	school	902400	800011	Meriden School District	90240000448	800711	Nathan Hale School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	99	99
2436734	CT	school	903840	1190011	Rocky Hill School District	90384000784	1190411	Myrtle H. Stevens School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	99	99
2436429	CT	school	902640	880011	Naugatuck School District	90264001223	880311	Maple Hill School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_2	98	98
2436820	CT	school	904320	1350011	Stamford School District	90432000858	1351211	Julia A. Stark School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	98	98
2436899	CT	school	904620	1440011	Trumbull School District	90462000929	1440811	Daniels Farm School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	98	98
2435872	CT	school	900510	170011	Bristol School District	90051001624	172011	West Bristol School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_2	97	97
2435936	CT	school	900750	250011	Cheshire School District	90075000127	250411	Highland School	Public Schools	Regular School	No	Elementary	KG	06	2019	grade_2	97	97
2436653	CT	school	903390	1130011	Portland School District	90339000711	1130411	Gildersleeve School	Public Schools	Regular School	No	Elementary	02	04	2019	grade_2	97	97
2435945	CT	school	900810	270011	Clinton School District	90081000132	270311	Lewin G. Joel Jr. School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_2	96	96
2436701	CT	school	903538	2160012	Regional School District 16	90353801811	2160512	Prospect Elementary School	Regional Schools	Regular School	No	Elementary	PK	05	2019	grade_2	96	96
2436819	CT	school	904320	1350011	Stamford School District	90432000167	1352211	Hart School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	96	96
2436859	CT	school	904440	1380011	Stratford School District	90444000892	1381511	Stratford Academy - Johnson House	Public Schools	Regular School	No	Elementary	02	06	2019	grade_2	96	96
2435762	CT	school	900060	20011	Ansonia School District	90006001020	20811	Prendergast School	Public Schools	Regular School	No	Elementary	KG	06	2019	grade_2	95	95
2436441	CT	school	902670	890011	New Britain School District	90267000515	890811	Lincoln Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	95	95
2436663	CT	school	903510	1170011	Redding School District	90351000722	1170111	Redding Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_2	95	95
2436814	CT	school	904320	1350011	Stamford School District	90432000852	1352011	Davenport Ridge School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	95	95
2437131	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_2	95	95
2437133	CT	school	900024	2790013	Amistad Academy District	90002400981	2795113	Amistad Academy	Public Charter Schools	Regular School	Yes	Other	KG	12	2019	grade_2	95	95
2436117	CT	school	901560	520011	Farmington School District	90156001206	520411	East Farms School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_2	94	94
2436150	CT	school	901710	570011	Greenwich School District	90171000308	571011	Riverside School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	94	94
2436463	CT	school	902700	900011	New Canaan School District	90270000534	900311	West School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_2	94	94
2436818	CT	school	904320	1350011	Stamford School District	90432000861	1351811	Northeast School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	94	94
2436923	CT	school	904740	1480011	Wallingford School District	90474000950	1481011	Cook Hill School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_2	94	94
2437046	CT	school	904950	1560011	West Haven School District	90495001038	1561411	Savin Rock Community School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_2	94	94
2436067	CT	school	901440	480011	Ellington School District	90144000239	480611	Windermere School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_2	93	93
2436537	CT	school	902820	950011	New London School District	90282000591	950311	C.B. Jennings International Elementary Magnet	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	93	93
2436826	CT	school	904320	1350011	Stamford School District	90432000008	1351911	Toquam Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	93	93
2436971	CT	school	904830	1510011	Waterbury School District	90483000974	1511111	Margaret M. Generali Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	93	93
2436541	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_2	92	92
2436949	CT	school	904830	1510011	Waterbury School District	90483000977	1510711	H. S. Chase School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	92	92
2436589	CT	school	903090	1030011	Norwalk School District	90309000648	1030711	Jefferson Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	91	91
2436762	CT	school	904110	1280011	Simsbury School District	90411000814	1280711	Squadron Line School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_2	91	91
2436817	CT	school	904320	1350011	Stamford School District	90432000865	1350911	Roxbury School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	91	91
2436103	CT	school	901530	510011	Fairfield School District	90153000262	510611	McKinley School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	90	90
2436742	CT	school	903990	1240011	Seymour School District	90399001642	1240211	Chatfield-LoPresti School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	90	90
2436821	CT	school	904320	1350011	Stamford School District	90432000860	1350611	Newfield School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	90	90
2437042	CT	school	904950	1560011	West Haven School District	90495001040	1561211	Washington School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_2	90	90
2436200	CT	school	901890	630011	Hampton School District	90189000351	630111	Hampton Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_2	9	9
2436440	CT	school		890011	New Britain School District		891611	Gaffney KEY Elementary	Program						2019	grade_2	9	9
2436910	CT	school	904650	1450011	Union School District	90465000938	1450111	Union School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_2	9	9
2437143	CT	school	904020	1250011	Sharon School District	90402000795	1250111	Sharon Center School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_2	9	9
2435979	CT	school	901020	340011	Danbury School District	90102000161	341211	Shelter Rock School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	89	89
2435980	CT	school	901020	340011	Danbury School District	90102000163	341611	Stadley Rough School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	89	89
2436352	CT	school	902400	800011	Meriden School District	90240000440	801111	Casimir Pulaski School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	89	89
2436540	CT	school	902820	950011	New London School District	90282000594	950911	Nathan Hale Arts Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	89	89
2436822	CT	school	904320	1350011	Stamford School District	90432000864	1350811	Rogers International School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_2	89	89
2437132	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_2	89	89
2436209	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_2	88	88
2436284	CT	school	903450	2450014	Learn	90345000079	2450114	Regional Multicultural Magnet School	Regional Education Service Center Schools	Regular School	No	Elementary	KG	05	2019	grade_2	88	88
2436950	CT	school	904830	1510011	Waterbury School District	90483000541	1513111	Maloney Interdistrict Magnet School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	88	88
2436953	CT	school	904830	1510011	Waterbury School District	90483001131	1513311	Rotella Interdistrict Magnet School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	88	88
2437025	CT	school	904920	1550011	West Hartford School District	90492001014	1550611	Duffy School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	88	88
2436438	CT	school	902670	890011	New Britain School District	90267000510	891111	DiLoreto Elementary & Middle School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_2	87	87
2436659	CT	school	903480	1160011	Putnam School District	90348000718	1160311	Putnam Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	87	87
2436770	CT	school	904140	1290011	Somers School District	90414000526	1290411	Somers Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	87	87
2435997	CT	school	901050	350011	Darien School District	90105000498	350711	Holmes Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	86	86
2436049	CT	school	901350	470011	East Windsor School District	90135000228	470111	Broad Brook Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_2	86	86
2436815	CT	school	904320	1350011	Stamford School District	90432000859	1350511	K. T. Murphy School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	86	86
2436924	CT	school	904740	1480011	Wallingford School District	90474000952	1480911	Evarts C. Stevens School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_2	86	86
2436412	CT	school	902550	850011	Monroe School District	90255000488	850511	Fawn Hollow Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	85	85
2436451	CT	school	902670	890011	New Britain School District	90267000524	891311	Smith Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	85	85
2436778	CT	school	904170	1320011	South Windsor School District	90417000825	1320211	Pleasant Valley School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	85	85
2436749	CT	school	904050	1260011	Shelton School District	90405000803	1260811	Long Hill School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_2	84	84
2436966	CT	school	904830	1510011	Waterbury School District	90483000975	1511411	F. J. Kingsbury School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	84	84
2437114	CT	school	905220	1640011	Windsor School District	90522001093	1640511	Poquonock Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_2	84	84
2435841	CT	school	900450	150011	Bridgeport School District	90045000080	152511	Read School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_2	83	83
2435993	CT	school	901050	350011	Darien School District	90105000165	350211	Hindley Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	81	81
2436452	CT	school	902670	890011	New Britain School District	90267000527	891511	Vance Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	81	81
2436552	CT	school	902880	940011	Newington School District	90288000611	940611	Anna Reynolds School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_2	81	81
2436943	CT	school	904830	1510011	Waterbury School District	90483000966	1512111	B. W. Tinker School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	81	81
2435788	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	80	80
2435823	CT	school	900450	150011	Bridgeport School District	90045000049	150111	Barnum School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_2	80	80
2436344	CT	school	902400	800011	Meriden School District	90240000443	800411	Israel Putnam School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	80	80
2436637	CT	school	903270	1090011	Plainfield School District	90327000692	1090111	Moosup Elementary School	Public Schools	Regular School	No	Elementary	KG	03	2019	grade_2	80	80
2436743	CT	school	903990	1240011	Seymour School District	90399000790	1240111	Bungay School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	80	80
2437068	CT	school	905040	1580011	Westport School District	90504001055	1580511	King's Highway Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	80	80
2437134	CT	school	900217	2950013	Booker T. Washington Academy District	90021701750	2950113	Booker T. Washington Academy	Public Charter Schools	Regular School	Yes	Elementary	KG	05	2019	grade_2	80	80
2436671	CT	school	903515	2060012	Regional School District 06	90351500726	2060312	Warren Elementary School	Regional Schools	Regular School	No	Elementary	PK	06	2019	grade_2	8	8
2437135	CT	school	900630	210011	Canaan School District	90063000115	210111	Lee H. Kellogg School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_2	8	8
2435761	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_2	79	79
2435898	CT	school	900570	190011	Brooklyn School District	90057000113	190111	Brooklyn Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_2	79	79
2435984	CT	school	901020	340011	Danbury School District	90102000162	341011	South Street School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	79	79
2436042	CT	school	901320	450011	East Lyme School District	90132000225	450111	Flanders School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_2	79	79
2436118	CT	school	901560	520011	Farmington School District	90156000275	520211	Noah Wallace School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_2	79	79
2436149	CT	school	901710	570011	Greenwich School District	90171000304	570711	North Mianus School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	79	79
2436444	CT	school	902670	890011	New Britain School District	90267000509	890311	Chamberlain Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	79	79
2436491	CT	school	902790	930011	New Haven School District	90279000554	931611	Fair Haven School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_2	79	79
2437069	CT	school	905040	1580011	Westport School District	90504001056	1580711	Long Lots School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	79	79
2435830	CT	school	900450	150011	Bridgeport School District	90045000058	150511	Columbus School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_2	78	78
2436099	CT	school	901530	510011	Fairfield School District	90153000269	511311	Sherman School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	78	78
2436128	CT	school	901620	540011	Glastonbury School District	90162000286	540611	Hopewell School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	78	78
2436345	CT	school	902400	800011	Meriden School District	90240000445	800511	John Barry School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	78	78
2436443	CT	school	902670	890011	New Britain School District	90267000513	890611	Holmes Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	78	78
2436555	CT	school	902880	940011	Newington School District	90288000612	940711	Ruth Chaffee School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_2	78	78
2436636	CT	school	903270	1090011	Plainfield School District	90327000047	1090411	Shepard Hill Elementary School	Public Schools	Regular School	No	Elementary	PK	03	2019	grade_2	78	78
2436674	CT	school	903520	2100012	Regional School District 10	90352000729	2100212	Lake Garda Elementary School	Regional Schools	Regular School	No	Elementary	PK	04	2019	grade_2	78	78
2437019	CT	school	904920	1550011	West Hartford School District	90492001012	1550511	Charter Oak International Academy	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	78	78
2436058	CT	school	901410	460011	Easton School District	90141000234	460111	Samuel Staples Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_2	77	77
2436595	CT	school	903090	1030011	Norwalk School District	90309000659	1032311	Silvermine Dual Language Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	77	77
2436823	CT	school	904320	1350011	Stamford School District	90432000866	1351111	Springdale School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	77	77
2436897	CT	school	904620	1440011	Trumbull School District	90462000927	1440111	Booth Hill School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_2	77	77