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 (ccd_school_high_grade < :p3 or ccd_school_high_grade is null or (ccd_school_high_grade = :p3 and rowid > :p2)) order by ccd_school_high_grade desc, rowid 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
2434710	CT	school	901740	580011	Griswold School District	90174001721	580111	Griswold Alternative School	Public Schools	Alternative School	No	High	09	12	2019	grade_1	0	0
2434711	CT	school	901740	580011	Griswold School District	90174000311	586211	Griswold High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434722	CT	school	901770	590011	Groton School District	90177000318	596111	Robert E. Fitch High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434730	CT	school	901800	600011	Guilford School District	90180000332	606111	Guilford High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434749	CT	school	901860	620011	Hamden School District	90186000339	626111	Hamden High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434756	CT	school	901920	640011	Hartford School District	90192001435	646911	Capital Preparatory Magnet School	Public Schools	Regular School	No	Other	PK	12	2019	grade_1	33	33
2434763	CT	school	901920	640011	Hartford School District	90192000370	641111	Kinsella Magnet School of Performing Arts	Public Schools	Regular School	No	Other	PK	12	2019	grade_1	47	47
2434783	CT	school	901920	640011	Hartford School District	90192001535	643611	Global Communications Academy	Public Schools	Regular School	No	Other	KG	12	2019	grade_1	64	64
2434796	CT	school	901920	640011	Hartford School District	90192001478	646411	Classical Magnet School	Public Schools	Regular School	No	High	06	12	2019	grade_1	0	0
2434797	CT	school	901920	640011	Hartford School District	90192001295	645411	Hartford Magnet Trinity College Academy	Public Schools	Regular School	No	High	06	12	2019	grade_1	0	0
2434800	CT	school	901920	640011	Hartford School District	90192001370	646511	Sport and Medical Sciences Academy	Public Schools	Regular School	No	High	06	12	2019	grade_1	0	0
2434804	CT	school	901920	640011	Hartford School District	90192001572	647111	Bulkeley High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434805	CT	school	901920	640011	Hartford School District	90192001403	647911	Great Path Academy at MCC	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434806	CT	school	901920	640011	Hartford School District	90192001574	647211	HPHS Engineering and Green Technology Academy		Regular School	No	High	09	12	2019	grade_1	0	0
2434807	CT	school	901920	640011	Hartford School District	90192001576	647411	HPHS Law and Government Academy		Regular School	No	High	09	12	2019	grade_1	0	0
2434808	CT	school	901920	640011	Hartford School District	90192001559	647511	HPHS Nursing and Health Sciences Academy		Regular School	No	High	09	12	2019	grade_1	0	0
2434809	CT	school	901920	640011	Hartford School District	90192001552	647611	High School, Inc.		Regular School	No	High	09	12	2019	grade_1	0	0
2434810	CT	school	901920	640011	Hartford School District	90192001562	647711	Journalism and Media Academy		Regular School	No	High	09	12	2019	grade_1	0	0
2434811	CT	school	901920	640011	Hartford School District	90192001479	646611	Pathways Academy of Technology and Design	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434814	CT	school	901920	640011	Hartford School District	90192001381	646711	University High School of Science and Engineering	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434817	CT	school	901920	640011	Hartford School District	90192001522	646011	Culinary Arts Academy at Weaver High School		Regular School	No	High	11	12	2019	grade_1	0	0
2434818	CT	school	901920	640011	Hartford School District	90192001650	643911	Capital Community College Magnet Academy		Regular School	No	High	12	12	2019	grade_1	0	0
2434823	CT	school	900207	2860013	Highville Charter School District	90020700907	2860113	Highville Charter School	Public Charter Schools	Regular School	Yes	Other	PK	12	2019	grade_1	39	39
2434825	CT	school	900007	2610013	Jumoke Academy District	90000700747	2610113	Jumoke Academy	Public Charter Schools	Regular School	Yes	Other	PK	12	2019	grade_1	73	73
2434831	CT	school	902070	690011	Killingly School District	90207000392	696111	Killingly High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434843	CT	school	903450	2450014	Learn	90345001581	2456014	Connecticut River Academy at Goodwin University	Regional Education Service Center Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434844	CT	school	903450	2450014	Learn	90345001606	2456114	Marine Science Magnet High School	Regional Education Service Center Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434846	CT	school	903450	2450014	Learn	90345001617	2456214	Three Rivers Middle College Magnet School	Regional Education Service Center Schools	Regular School	No	High	11	12	2019	grade_1	0	0
2434850	CT	school	902130	710011	Lebanon School District	90213000396	716211	Lyman Memorial High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434856	CT	school	902160	720011	Ledyard School District	90216000401	726111	Ledyard High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434862	CT	school	902220	740011	Litchfield School District	90222000406	746111	Litchfield High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434869	CT	school	902280	760011	Madison School District	90228000411	766111	Daniel Hand High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434885	CT	school	902310	770011	Manchester School District	90231000424	776111	Manchester High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434913	CT	school	902400	800011	Meriden School District	90240000441	806111	Francis T. Maloney High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434914	CT	school	902400	800011	Meriden School District	90240000449	806211	Orville H. Platt High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434941	CT	school	902490	830011	Middletown School District	90249000465	836211	Middletown High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434957	CT	school	902520	840011	Milford School District	90252000472	846211	Jonathan Law High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434958	CT	school	902520	840011	Milford School District	90252000473	846311	Joseph A. Foran High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434966	CT	school	902550	850011	Monroe School District	90255000489	856111	Masuk High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434973	CT	school	902580	860011	Montville School District	90258000495	866111	Montville High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2434986	CT	school	902640	880011	Naugatuck School District	90264000505	886111	Naugatuck High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435011	CT	school	902670	890011	New Britain School District	90267000521	896111	New Britain High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435018	CT	school	902700	900011	New Canaan School District	90270000531	906111	New Canaan High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435023	CT	school	902730	910011	New Fairfield School District	90273000537	916111	New Fairfield High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435074	CT	school	902790	930011	New Haven School District	90279001519	931711	Engineering - Science University Magnet School	Public Schools	Regular School	No	High	06	12	2019	grade_1	0	0
2435075	CT	school	902790	930011	New Haven School District	90279001207	936411	Cooperative High School - Inter-District Magnet	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435077	CT	school	902790	930011	New Haven School District	90279000558	936611	High School In The Community	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435078	CT	school	902790	930011	New Haven School District	90279000556	936311	Hill Regional Career High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435079	CT	school	902790	930011	New Haven School District	90279000563	936211	James Hillhouse High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435081	CT	school	902790	930011	New Haven School District	90279001485	936011	Metropolitan Business Academy	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435082	CT	school	902790	930011	New Haven School District	90279000547	937011	New Haven Academy	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435084	CT	school	902790	930011	New Haven School District	90279001216	936711	Sound School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435085	CT	school	902790	930011	New Haven School District	90279000585	936111	Wilbur Cross High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435095	CT	school	902820	950011	New London School District	90282001913	951311	Science and Technology Magnet School of Southeastern Connecticut	Public Schools	Regular School	No	High	06	12	2019	grade_1	0	0
2435096	CT	school	902820	950011	New London School District	90282000595	956111	New London High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435101	CT	school	902850	960011	New Milford School District	90285000602	966111	New Milford High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435109	CT	school	902880	940011	Newington School District	90288000610	946111	Newington High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435117	CT	school	902910	970011	Newtown School District	90291000615	976111	Newtown High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435123	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435131	CT	school	903030	1010011	North Haven School District	90303000631	1016111	North Haven High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435134	CT	school	903060	1020011	North Stonington School District	90306000635	1026111	Wheeler High School	Public Schools	Regular School	No	High	06	12	2019	grade_1	0	0
2435152	CT	school	903090	1030011	Norwalk School District	90309000638	1036211	Brien McMahon High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435153	CT	school	903090	1030011	Norwalk School District	90309001917	1030511	Center for Global Studies	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435154	CT	school	903090	1030011	Norwalk School District	90309000655	1036111	Norwalk High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435176	CT	school	903180	1060011	Old Saybrook School District	90318000684	1066111	Old Saybrook Senior High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435184	CT	school	903240	1080011	Oxford School District	90324001504	1086011	Oxford High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435191	CT	school	903270	1090011	Plainfield School District	90327000695	1096111	Plainfield High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435196	CT	school	903300	1100011	Plainville School District	90330000703	1106111	Plainville High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435201	CT	school	903330	1110011	Plymouth School District	90333001199	1116111	Terryville High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435207	CT	school	903390	1130011	Portland School District	90339000712	1136111	Portland High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435212	CT	school	903480	1160011	Putnam School District	90348000719	1166111	Putnam High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435219	CT	school	903600	2010012	Regional School District 01	90360000766	2016112	Housatonic Valley Regional High School	Regional Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435223	CT	school	903515	2060012	Regional School District 06	90351500725	2066112	Wamogo Regional High School	Regional Schools	Regular School	No	High	07	12	2019	grade_1	0	0
2435227	CT	school	903520	2100012	Regional School District 10	90352000730	2106112	Lewis S. Mills High School	Regional Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435231	CT	school	903530	2120012	Regional School District 12	90353001632	2120312	Shepaug Valley School	Regional Schools	Regular School	No	High	06	12	2019	grade_1	0	0
2435237	CT	school	903535	2130012	Regional School District 13	90353500737	2136112	Coginchaug Regional High School	Regional Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435242	CT	school	903536	2140012	Regional School District 14	90353600745	2146112	Nonnewaug High School	Regional Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435250	CT	school	903537	2150012	Regional School District 15	90353700749	2156212	Pomperaug Regional High School	Regional Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435256	CT	school	903538	2160012	Regional School District 16	90353801356	2166012	Woodland Regional High School	Regional Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435261	CT	school	903539	2170012	Regional School District 17	90353900759	2176112	Haddam-Killingworth High School	Regional Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435267	CT	school	903540	2180012	Regional School District 18	90354000763	2186112	Lyme-Old Lyme High School	Regional Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435283	CT	school	903810	1180011	Ridgefield School District	90381000779	1186111	Ridgefield High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435289	CT	school	903840	1190011	Rocky Hill School District	90384000785	1196111	Rocky Hill High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435296	CT	school	903990	1240011	Seymour School District	90399000793	1246111	Seymour High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435309	CT	school	904050	1260011	Shelton School District	90405000806	1266111	Shelton High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435319	CT	school	904110	1280011	Simsbury School District	90411000813	1286111	Simsbury High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435323	CT	school	904140	1290011	Somers School District	90414000819	1296111	Somers High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435331	CT	school	904170	1320011	South Windsor School District	90417000826	1320311	Alternative Education Program	Program	Regular School	No	High	09	12	2019	grade_1	0	0
2435332	CT	school	904170	1320011	South Windsor School District	90417000826	1326211	South Windsor High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435353	CT	school	904230	1310011	Southington School District	90423000838	1316211	Southington High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435356	CT	school	904260	1330011	Sprague School District	90426000842	1330111	Sayles School	Public Schools	Regular School	No	Other	PK	12	2019	grade_1	30	30
2435361	CT	school	904290	1340011	Stafford School District	90429000845	1346111	Stafford High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435385	CT	school	904320	1350011	Stamford School District	90432000867	1356111	Stamford High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435386	CT	school	904320	1350011	Stamford School District	90432001468	1356411	The Academy of Information, Technology & Engineering	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435387	CT	school	904320	1350011	Stamford School District	90432000871	1356311	Westhill High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435397	CT	school	904380	1370011	Stonington School District	90438000881	1376111	Stonington High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435417	CT	school	904440	1380011	Stratford School District	90444000885	1386211	Bunnell High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435420	CT	school	904440	1380011	Stratford School District	90444000897	1386111	Stratford High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435425	CT	school	904470	1390011	Suffield School District	90447000904	1396111	Suffield High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0
2435428	CT	school	904500	1400011	Thomaston School District	90450000908	1406211	Thomaston High School	Public Schools	Regular School	No	High	07	12	2019	grade_1	0	0
2435432	CT	school	904530	1410011	Thompson School District	90453000911	1416111	Tourtellotte Memorial High School	Public Schools	Regular School	No	High	09	12	2019	grade_1	0	0