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 ccd_school_high_grade 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
266453	NH	school		457	Rivendell		29196	Rivendell Academy (E)	Interstate Schools						2020	grade_9	0.0	0
266454	NH	school		457	Rivendell		29197	Rivendell Academy (H)	Interstate Schools						2020	grade_9	12.0	12
266103	NH	school	3302990	174	Fall Mountain Regional	330299000121	23010	Walpole Primary School		Regular School	No	Elementary	PK	01	2020	grade_9	0.0	0
266166	NH	school	3303930	267	Hudson	330393000180	21045	Dr. H. O. Smith Elementary School		Regular School	No	Elementary	PK	01	2020	grade_9	0.0	0
266275	NH	school	3304830	357	Milford	330483000507	26580	Jacques Memorial Elementary School		Regular School	No	Elementary	PK	01	2020	grade_9	0.0	0
266045	NH	school	3302460	111	Concord	330246000056	20250	Mill Brook School		Regular School	No	Elementary	PK	02	2020	grade_9	0.0	0
266091	NH	school	3302970	173	Exeter	330297000109	20575	Main Street School		Regular School	No	Elementary	PK	02	2020	grade_9	0.0	0
266138	NH	school	3303510	225	Hampton	330351000469	20770	Hampton Centre School		Regular School	No	Elementary	PK	02	2020	grade_9	0.0	0
266159	NH	school	3303870	261	Hooksett	330387000173	20550	Fred C. Underhill School		Regular School	No	Elementary	PK	02	2020	grade_9	0.0	0
266286	NH	school	3304890	363	Monadnock Regional	330489000302	21695	Mt. Caesar Elementary School		Regular School	No	Elementary	PK	02	2020	grade_9	0.0	0
266399	NH	school	3306240	491	Somersworth	330624000732	29202	Idlehurst Elementary School		Regular School	No	Elementary	PK	02	2020	grade_9	0.0	0
266447	NH	school	3307300	582	Winnisquam Regional	330730000467	22945	Union Sanborn School		Regular School	No	Elementary	PK	02	2020	grade_9	0.0	0
266026	NH	school	3302070	71	Brookline	330207000031	21800	Richard Maghakian Memorial School		Regular School	No	Elementary	PK	03	2020	grade_9	0.0	0
266106	NH	school	3303000	175	Farmington	330300000597	27980	Valley View Community School		Regular School	No	Elementary	PK	03	2020	grade_9	0.0	0
266109	NH	school	3303090	185	Franklin	330309000130	20650	Paul A. Smith School		Regular School	No	Elementary	PK	03	2020	grade_9	0.0	0
266124	NH	school	3303330	208	Governor Wentworth Regional	330333000144	22430	Carpenter Elementary School		Regular School	No	Elementary	KG	03	2020	grade_9	0.0	0
266143	NH	school	3303660	238	Haverhill Cooperative	330366000159	20905	Woodsville Elementary School		Regular School	No	Elementary	PK	03	2020	grade_9	0.0	0
266154	NH	school	3303840	259	Hollis	330384000171	21815	Hollis Primary School		Regular School	No	Elementary	PK	03	2020	grade_9	0.0	0
266161	NH	school	3303900	263	Hopkinton	330390000176	20975	Harold Martin School		Regular School	No	Elementary	PK	03	2020	grade_9	0.0	0
266201	NH	school	3304170	291	Landaff	330417000216	21410	Landaff Blue School		Regular School	No	Elementary	PK	03	2020	grade_9	0.0	0
265997	NH	school	3301380	9	Allenstown	330138000001	22580	Allenstown Elementary School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266001	NH	school	3301470	17	Amherst	330147000006	21750	Clark-Wilkins School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266006	NH	school	3301650	33	Barrington	330165000013	22045	Barrington Elementary School		Regular School	No	Elementary	01	04	2020	grade_9	0.0	0
266013	NH	school	3301740	41	Bedford	330174000018	20990	Memorial School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266014	NH	school	3301740	41	Bedford	330174000019	21000	Peter Woodbury School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266015	NH	school	3301740	41	Bedford	330174000580	27680	Riddle Brook School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266021	NH	school	3301950	57	Bow	330195000480	20680	Bow Elementary School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266047	NH	school	3302480	112	Contoocook Valley	330248000065	22215	Antrim Elementary School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266049	NH	school	3302480	112	Contoocook Valley	330248000068	22230	Dublin Consolidated School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266050	NH	school	3302480	112	Contoocook Valley	330248000069	22245	Francestown Elementary School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266052	NH	school	3302480	112	Contoocook Valley	330248000070	22250	Greenfield Elementary School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266053	NH	school	3302480	112	Contoocook Valley	330248000071	22260	Hancock Elementary School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266054	NH	school	3302480	112	Contoocook Valley	330248000072	22310	Peterborough Elementary School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266055	NH	school	3302480	112	Contoocook Valley	330248000074	22225	Pierce Elementary School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266057	NH	school	3302480	112	Contoocook Valley	330248000075	22330	Temple Elementary School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266064	NH	school	3302550	117	Croydon	330255000081	21960	Croydon Village School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266076	NH	school	3302640	141	Dover	330264000090	20430	Garrison School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266077	NH	school	3302640	141	Dover	330264000091	20445	Horne Street School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266078	NH	school	3302640	141	Dover	330264000094	20460	Woodman Park School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266092	NH	school	3302990	174	Fall Mountain Regional	330299000112	22960	Acworth Elementary School		Regular School	No	Elementary	01	04	2020	grade_9	0.0	0
266093	NH	school	3302990	174	Fall Mountain Regional	330299000113	22965	Alstead Primary School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266099	NH	school	3302990	174	Fall Mountain Regional	330299000118	23005	North Walpole School		Regular School	No	Elementary	02	04	2020	grade_9	0.0	0
266100	NH	school	3302990	174	Fall Mountain Regional	330299000119	22995	Sarah Porter School		Regular School	No	Elementary	01	04	2020	grade_9	0.0	0
266112	NH	school	3303180	191	Gilford	330318000133	21245	Gilford Elementary School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266116	NH	school	3303240	199	Goffstown	330324000138	20695	Bartlett Elementary School		Regular School	No	Elementary	01	04	2020	grade_9	0.0	0
266119	NH	school	3303240	199	Goffstown	330324000139	20690	Maple Avenue School		Regular School	No	Elementary	01	04	2020	grade_9	0.0	0
266134	NH	school	3303480	223	Hampstead	330348000153	22755	Hampstead Central School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266202	NH	school	3304230	295	Lebanon	330423000217	21335	Hanover Street School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266205	NH	school	3304230	295	Lebanon	330423000220	21355	Mt. Lebanon School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266214	NH	school	3304350	315	Litchfield	330435000228	21095	Griffin Memorial School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266229	NH	school	3304590	335	Manchester	330459000246	21530	Gossler Park School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266243	NH	school	3304590	335	Manchester	330459000505	26435	Northwest Elementary School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266244	NH	school	3304590	335	Manchester	330459000254	21540	Parker-Varney School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266252	NH	school	3304670	342	Mascenic Regional	330467000697	90393	Highbridge Hill Elementary School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266254	NH	school	3304680	343	Mascoma Valley Regional	330468000273	21315	Canaan Elementary School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266255	NH	school	3304680	343	Mascoma Valley Regional	330468000274	21325	Enfield Village School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266259	NH	school	3304740	351	Merrimack	330474000276	21020	James Mastricola Elementary School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266263	NH	school	3304740	351	Merrimack	330474000279	21015	Reeds Ferry School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266264	NH	school	3304740	351	Merrimack	330474000280	21035	Thorntons Ferry School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266291	NH	school	3304960	369	Moultonborough	330496000147	22115	Moultonborough Central School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266335	NH	school	3305520	423	Oyster River Coop	330552000352	22805	Mast Way School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266336	NH	school	3305520	423	Oyster River Coop	330552000520	26660	Moharimet School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266344	NH	school	3305580	427	Pembroke	330558000361	22615	Pembroke Hill School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266364	NH	school	3305880	453	Raymond	330588000384	21385	Lamprey River Elementary School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266372	NH	school	3305940	461	Rochester	330594000522	22660	Nancy Loud School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266374	NH	school	3305940	461	Rochester	330594000393	22720	School Street School		Regular School	No	Elementary	KG	04	2020	grade_9	0.0	0
266379	NH	school	3306030	471	Rye	330603000398	22475	Rye Elementary School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266393	NH	school	3306150	485	Seabrook	330615000410	20810	Seabrook Elementary School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266395	NH	school	3306180	486	Shaker Regional	330618000490	22135	Belmont Elementary School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266440	NH	school	3307170	575	Windham	330717000461	21130	Golden Brook Elementary School		Regular School	No	Elementary	PK	04	2020	grade_9	0.0	0
266492	NH	school	3303314	712	Windham Academy Public Charter School	330331400730	29193	Windham Academy Public Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	04	2020	grade_9	0.0	0
266017	NH	school	3301860	51	Berlin	330186000163	27035	Berlin Elementary School		Regular School	No	Elementary	PK	05	2020	grade_9	0.0	0
266024	NH	school	3302010	63	Brentwood	330201000030	20555	Swasey Central School		Regular School	No	Elementary	PK	05	2020	grade_9	0.0	0
266032	NH	school	3302340	101	Claremont	330234000038	20145	Bluff School		Regular School	No	Elementary	KG	05	2020	grade_9	0.0	0
266035	NH	school	3302340	101	Claremont	330234000488	20165	Disnard Elementary School		Regular School	No	Elementary	KG	05	2020	grade_9	0.0	0
266036	NH	school	3302340	101	Claremont	330234000040	20160	Maple Avenue School		Regular School	No	Elementary	KG	05	2020	grade_9	0.0	0
266040	NH	school	3302460	111	Concord	330246000054	20240	Abbot-Downing School		Regular School	No	Elementary	KG	05	2020	grade_9	0.0	0
266041	NH	school	3302460	111	Concord	330246000496	26490	Beaver Meadow School		Regular School	No	Elementary	PK	05	2020	grade_9	0.0	0
266042	NH	school	3302460	111	Concord	330246000053	20260	Broken Ground School		Regular School	No	Elementary	03	05	2020	grade_9	0.0	0
266043	NH	school	3302460	111	Concord	330246000060	20305	Christa McAuliffe School		Regular School	No	Elementary	KG	05	2020	grade_9	0.0	0
266067	NH	school	3302610	131	Derry Cooperative	330261000083	20380	Derry Village School		Regular School	No	Elementary	KG	05	2020	grade_9	0.0	0
266068	NH	school	3302610	131	Derry Cooperative	330261000497	20370	East Derry Memorial Elementary School		Regular School	No	Elementary	KG	05	2020	grade_9	0.0	0
266069	NH	school	3302610	131	Derry Cooperative	330261000607	28465	Ernest P. Barka Elementary School		Regular School	No	Elementary	KG	05	2020	grade_9	0.0	0
266071	NH	school	3302610	131	Derry Cooperative	330261000085	20390	Grinnell School		Regular School	No	Elementary	KG	05	2020	grade_9	0.0	0
266072	NH	school	3302610	131	Derry Cooperative	330261000087	20405	South Range Elementary School		Regular School	No	Elementary	KG	05	2020	grade_9	0.0	0
266082	NH	school	3302790	153	East Kingston	330279000100	20565	East Kingston Elementary School		Regular School	No	Elementary	KG	05	2020	grade_9	0.0	0
266083	NH	school	3302880	165	Epping	330288000102	26510	Epping Elementary School		Regular School	No	Elementary	PK	05	2020	grade_9	0.0	0
266090	NH	school	3302970	173	Exeter	330297000108	20595	Lincoln Street Elementary School		Regular School	No	Elementary	03	05	2020	grade_9	0.0	0
266095	NH	school	3302990	174	Fall Mountain Regional	330299000115	22985	Charlestown Primary School		Regular School	No	Elementary	PK	05	2020	grade_9	0.0	0
266098	NH	school	3302990	174	Fall Mountain Regional	330299000117	22980	N. Charlestown Community School		Regular School	No	Elementary	01	05	2020	grade_9	0.0	0
266121	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500141	20745	Edward Fenn School		Regular School	No	Elementary	KG	05	2020	grade_9	0.0	0
266136	NH	school	3303510	225	Hampton	330351000470	20795	Adeline C. Marston School		Regular School	No	Elementary	03	05	2020	grade_9	0.0	0
266140	NH	school	3303600	233	Hanover	330360000155	20830	Bernice A. Ray School		Regular School	No	Elementary	KG	05	2020	grade_9	0.0	0
266147	NH	school	3303750	251	Hillsboro-Deering Cooperative	330375000165	20955	Hillsboro-Deering Elementary School		Regular School	No	Elementary	PK	05	2020	grade_9	0.0	0
266150	NH	school	3303780	255	Hinsdale	330378000167	21680	Hinsdale Elementary School		Regular School	No	Elementary	PK	05	2020	grade_9	0.0	0
266160	NH	school	3303870	261	Hooksett	330387000175	20540	Hooksett Memorial School		Regular School	No	Elementary	03	05	2020	grade_9	0.0	0
266167	NH	school	3303930	267	Hudson	330393000593	27900	Hills Garrison Elementary School		Regular School	No	Elementary	02	05	2020	grade_9	0.0	0
266169	NH	school	3303930	267	Hudson	330393000513	26765	Nottingham West Elementary School		Regular School	No	Elementary	02	05	2020	grade_9	0.0	0
266176	NH	school	3304030	274	Jaffrey-Rindge Cooperative	330403000189	22275	Jaffrey Grade School		Regular School	No	Elementary	PK	05	2020	grade_9	0.0	0
266178	NH	school	3304030	274	Jaffrey-Rindge Cooperative	330403000191	22320	Rindge Memorial School		Regular School	No	Elementary	PK	05	2020	grade_9	0.0	0
266181	NH	school	3304040	276	Kearsarge Regional	330404000195	21980	Kearsarge Reg. Elem. School at New London		Regular School	No	Elementary	KG	05	2020	grade_9	0.0	0