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 order by total_int 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
2775039	CT	school	901020	340011	Danbury School District	90102000150	346111	Danbury High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	827	827
2754624	CT	school	901020	340011	Danbury School District	90102000150	346111	Danbury High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	762	762
2449032	CT	school	901020	340011	Danbury School District	90102000150	346111	Danbury High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	754	754
2754793	CT	school	901710	570011	Greenwich School District	90171000300	576111	Greenwich High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	698	698
2449195	CT	school	901710	570011	Greenwich School District	90171000300	576111	Greenwich High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	695	695
2775201	CT	school	901710	570011	Greenwich School District	90171000300	576111	Greenwich High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	666	666
2450238	CT	school	905371	9010022	Norwich Free Academy District	90537101221	9016122	Norwich Free Academy	Endowed and Incorporated Academies Schools	Regular School	No	High	09	12	2019	grade_11	601	601
2776252	CT	school	905371	9010022	Norwich Free Academy District	90537101221	9016122	Norwich Free Academy	Endowed and Incorporated Academies Schools	Regular School	No	High	09	12	2020	grade_11	577	577
2755535	CT	school	904620	1440011	Trumbull School District	90462000937	1446111	Trumbull High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	564	564
2755465	CT	school	904320	1350011	Stamford School District	90432000871	1356311	Westhill High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	544	544
2755837	CT	school	905371	9010022	Norwich Free Academy District	90537101221	9016122	Norwich Free Academy	Endowed and Incorporated Academies Schools	Regular School	No	High	09	12	2021	grade_11	528	528
2775948	CT	school	904620	1440011	Trumbull School District	90462000937	1446111	Trumbull High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	523	523
2775878	CT	school	904320	1350011	Stamford School District	90432000871	1356311	Westhill High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	522	522
2449877	CT	school	904320	1350011	Stamford School District	90432000871	1356311	Westhill High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	521	521
2449843	CT	school	904230	1310011	Southington School District	90423000838	1316211	Southington High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	520	520
2775499	CT	school	902670	890011	New Britain School District	90267000521	896111	New Britain High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	494	494
2775181	CT	school	901620	540011	Glastonbury School District	90162000283	546111	Glastonbury High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	493	493
2449175	CT	school	901620	540011	Glastonbury School District	90162000283	546111	Glastonbury High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	491	491
2754773	CT	school	901620	540011	Glastonbury School District	90162000283	546111	Glastonbury High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	491	491
2775844	CT	school	904230	1310011	Southington School District	90423000838	1316211	Southington High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	488	488
2755431	CT	school	904230	1310011	Southington School District	90423000838	1316211	Southington High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	487	487
2449949	CT	school	904620	1440011	Trumbull School District	90462000937	1446111	Trumbull High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	482	482
2776117	CT	school	905040	1580011	Westport School District	90504001058	1586111	Staples High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	475	475
2755463	CT	school	904320	1350011	Stamford School District	90432000867	1356111	Stamford High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	466	466
2755087	CT	school	902670	890011	New Britain School District	90267000521	896111	New Britain High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	458	458
2755698	CT	school	905040	1580011	Westport School District	90504001058	1586111	Staples High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	458	458
2775080	CT	school	901260	430011	East Hartford School District	90126000200	436211	East Hartford High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	455	455
2449501	CT	school	902670	890011	New Britain School District	90267000521	896111	New Britain High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	449	449
2449875	CT	school	904320	1350011	Stamford School District	90432000867	1356111	Stamford High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	449	449
2775639	CT	school	903090	1030011	Norwalk School District	90309000638	1036211	Brien McMahon High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	446	446
2450115	CT	school	905040	1580011	Westport School District	90504001058	1586111	Staples High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	441	441
2754959	CT	school	902310	770011	Manchester School District	90231000424	776111	Manchester High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	438	438
2754665	CT	school	901260	430011	East Hartford School District	90126000200	436211	East Hartford High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	432	432
2449607	CT	school	902910	970011	Newtown School District	90291000615	976111	Newtown High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	426	426
2449072	CT	school	901260	430011	East Hartford School District	90126000200	436211	East Hartford High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	419	419
2775771	CT	school	903810	1180011	Ridgefield School District	90381000779	1186111	Ridgefield High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	413	413
2775876	CT	school	904320	1350011	Stamford School District	90432000867	1356111	Stamford High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	410	410
2755229	CT	school	903090	1030011	Norwalk School District	90309000638	1036211	Brien McMahon High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	409	409
2755232	CT	school	903090	1030011	Norwalk School District	90309000655	1036111	Norwalk High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	406	406
2754750	CT	school	901530	510011	Fairfield School District	90153001379	516011	Fairfield Ludlowe High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	403	403
2775372	CT	school	902310	770011	Manchester School District	90231000424	776111	Manchester High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	402	402
2776082	CT	school	904920	1550011	West Hartford School District	90492001015	1556211	Hall High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	398	398
2448897	CT	school	900450	150011	Bridgeport School District	90045000056	156211	Central High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	397	397
2449773	CT	school	903810	1180011	Ridgefield School District	90381000779	1186111	Ridgefield High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	390	390
2755792	CT	school	903660	2050012	Regional School District 05	90366000770	2056112	Amity Regional High School	Regional Schools	Regular School	No	High	09	12	2021	grade_11	387	387
2775570	CT	school	902790	930011	New Haven School District	90279000585	936111	Wilbur Cross High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	385	385
2755359	CT	school	903810	1180011	Ridgefield School District	90381000779	1186111	Ridgefield High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	384	384
2755680	CT	school	904950	1560011	West Haven School District	90495001041	1566111	West Haven High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	384	384
2775604	CT	school	902910	970011	Newtown School District	90291000615	976111	Newtown High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	384	384
2450194	CT	school	903660	2050012	Regional School District 05	90366000770	2056112	Amity Regional High School	Regional Schools	Regular School	No	High	09	12	2019	grade_11	382	382
2775159	CT	school	901530	510011	Fairfield School District	90153000256	516211	Fairfield Warde High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	381	381
2449644	CT	school	903090	1030011	Norwalk School District	90309000655	1036111	Norwalk High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	379	379
2754838	CT	school	901860	620011	Hamden School District	90186000339	626111	Hamden High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	378	378
2449152	CT	school	901530	510011	Fairfield School District	90153001379	516011	Fairfield Ludlowe High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	377	377
2449375	CT	school	902310	770011	Manchester School District	90231000424	776111	Manchester High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	376	376
2449799	CT	school	904050	1260011	Shelton School District	90405000806	1266111	Shelton High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	374	374
2754573	CT	school	900750	250011	Cheshire School District	90075000123	256111	Cheshire High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	374	374
2449239	CT	school	901860	620011	Hamden School District	90186000339	626111	Hamden High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	368	368
2755665	CT	school	904920	1550011	West Hartford School District	90492001015	1556211	Hall High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	367	367
2775246	CT	school	901860	620011	Hamden School District	90186000339	626111	Hamden High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	367	367
2775506	CT	school	902700	900011	New Canaan School District	90270000531	906111	New Canaan High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	367	367
2775139	CT	school	901470	490011	Enfield School District	90147000243	496111	Enfield High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	366	366
2776207	CT	school	903660	2050012	Regional School District 05	90366000770	2056112	Amity Regional High School	Regional Schools	Regular School	No	High	09	12	2020	grade_11	366	366
2754632	CT	school	901050	350011	Darien School District	90105000164	356111	Darien High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	364	364
2449809	CT	school	904110	1280011	Simsbury School District	90411000813	1286111	Simsbury High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	361	361
2776081	CT	school	904920	1550011	West Hartford School District	90492001013	1556111	Conard High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	361	361
2450080	CT	school	904920	1550011	West Hartford School District	90492001015	1556211	Hall High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	360	360
2449153	CT	school	901530	510011	Fairfield School District	90153000256	516211	Fairfield Warde High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	359	359
2449642	CT	school	903090	1030011	Norwalk School District	90309000638	1036211	Brien McMahon High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	359	359
2755664	CT	school	904920	1550011	West Hartford School District	90492001013	1556111	Conard High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	359	359
2449040	CT	school	901050	350011	Darien School District	90105000164	356111	Darien High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	358	358
2775158	CT	school	901530	510011	Fairfield School District	90153001379	516011	Fairfield Ludlowe High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	357	357
2450096	CT	school	904950	1560011	West Haven School District	90495001041	1566111	West Haven High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	355	355
2755194	CT	school	902910	970011	Newtown School District	90291000615	976111	Newtown High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	353	353
2774989	CT	school	900750	250011	Cheshire School District	90075000123	256111	Cheshire High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	350	350
2449591	CT	school	902850	960011	New Milford School District	90285000602	966111	New Milford High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	349	349
2755013	CT	school	902490	830011	Middletown School District	90249000465	836211	Middletown High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	348	348
2774902	CT	school	900450	150011	Bridgeport School District	90045000056	156211	Central High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	344	344
2775801	CT	school	904050	1260011	Shelton School District	90405000806	1266111	Shelton High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	344	344
2448982	CT	school	900750	250011	Cheshire School District	90075000123	256111	Cheshire High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	343	343
2754488	CT	school	900450	150011	Bridgeport School District	90045000056	156211	Central High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	341	341
2754761	CT	school	901560	520011	Farmington School District	90156000273	526111	Farmington High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	341	341
2450079	CT	school	904920	1550011	West Hartford School District	90492001013	1556111	Conard High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	339	339
2755398	CT	school	904110	1280011	Simsbury School District	90411000813	1286111	Simsbury High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	339	339
2776134	CT	school	905130	1610011	Wilton School District	90513001076	1616111	Wilton High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	338	338
2449132	CT	school	901470	490011	Enfield School District	90147000243	496111	Enfield High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	337	337
2449575	CT	school	902790	930011	New Haven School District	90279000585	936111	Wilbur Cross High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	337	337
2755176	CT	school	902850	960011	New Milford School District	90285000602	966111	New Milford High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	337	337
2775427	CT	school	902490	830011	Middletown School District	90249000465	836211	Middletown High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	335	335
2775642	CT	school	903090	1030011	Norwalk School District	90309000655	1036111	Norwalk High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	333	333
2449822	CT	school	904170	1320011	South Windsor School District	90417000826	1326211	South Windsor High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	330	330
2775588	CT	school	902850	960011	New Milford School District	90285000602	966111	New Milford High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	329	329
2775811	CT	school	904110	1280011	Simsbury School District	90411000813	1286111	Simsbury High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	329	329
2755623	CT	school	904830	1510011	Waterbury School District	90483000979	1516411	John F. Kennedy High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	327	327
2754730	CT	school	901470	490011	Enfield School District	90147000243	496111	Enfield High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	326	326
2775169	CT	school	901560	520011	Farmington School District	90156000273	526111	Farmington High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	324	324
2776099	CT	school	904950	1560011	West Haven School District	90495001041	1566111	West Haven High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	324	324
2449740	CT	school	903537	2150012	Regional School District 15	90353700749	2156212	Pomperaug Regional High School	Regional Schools	Regular School	No	High	09	12	2019	grade_11	321	321
2754751	CT	school	901530	510011	Fairfield School District	90153000256	516211	Fairfield Warde High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	321	321
2775047	CT	school	901050	350011	Darien School District	90105000164	356111	Darien High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	321	321
2755184	CT	school	902880	940011	Newington School District	90288000610	946111	Newington High School	Public Schools	Regular School	No	High	09	12	2021	grade_11	320	320