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
353644	NH	school		357	Milford			Milford Early Education Experiences							2021	pk_12_total	36	36
355208	NH	school		453	Raymond			Raymond School District Preschool Program							2021	pk_12_total	38	38
355310	NH	school		457	Rivendell		29196	Rivendell Academy (E)	Interstate School						2021	pk_12_total	25	25
355327	NH	school		457	Rivendell		29197	Rivendell Academy (H)	Interstate School						2021	pk_12_total	51	51
350244	NH	school	3303930	267	Hudson	330393000180	21045	Dr. H. O. Smith Elementary School	Public School	Regular School	No	Elementary	KG	01	2021	pk_12_total	339	339
352063	NH	school	3304830	357	Milford	330483000507	26580	Jacques Memorial Elementary School	Public School	Regular School	No	Elementary	KG	01	2021	pk_12_total	275	275
356500	NH	school	3302990	174	Fall Mountain Regional	330299000121	23010	Walpole Primary School	Public School	Regular School	No	Elementary	PK	01	2021	pk_12_total	79	79
350805	NH	school	3303870	261	Hooksett	330387000173	20550	Fred C. Underhill School	Public School	Regular School	No	Elementary	PK	02	2021	pk_12_total	377	377
351400	NH	school	3303510	225	Hampton	330351000469	20770	Hampton Centre School	Public School	Regular School	No	Elementary	PK	02	2021	pk_12_total	302	302
351961	NH	school	3306240	491	Somersworth	330624000732	29202	Idlehurst Elementary School	Public School	Regular School	No	Elementary	PK	02	2021	pk_12_total	282	282
352624	NH	school	3304170	291	Landaff	330417000216	21410	Landaff Blue School	Public School	Regular School	No	Elementary	KG	02	2021	pk_12_total	10	10
353032	NH	school	3302970	173	Exeter	330297000109	20575	Main Street School	Public School	Regular School	No	Elementary	PK	02	2021	pk_12_total	424	424
353695	NH	school	3302460	111	Concord	330246000056	20250	Mill Brook School	Public School	Regular School	No	Elementary	PK	02	2021	pk_12_total	322	322
353933	NH	school	3304890	363	Monadnock Regional	330489000302	21695	Mt. Caesar Elementary School	Public School	Regular School	No	Elementary	PK	02	2021	pk_12_total	260	260
356381	NH	school	3307300	582	Winnisquam Regional	330730000467	22945	Union Sanborn School	Public School	Regular School	No	Elementary	PK	02	2021	pk_12_total	207	207
349564	NH	school	3303330	208	Governor Wentworth Regional	330333000144	22430	Carpenter Elementary School	Public School	Regular School	No	Elementary	KG	03	2021	pk_12_total	199	199
350074	NH	school	3306080	476	Sanborn Regional	330608000478	20625	Daniel J. Bakie School	Public School	Regular School	No	Elementary	PK	03	2021	pk_12_total	343	343
351468	NH	school	3303900	263	Hopkinton	330390000176	20975	Harold Martin School	Public School	Regular School	No	Elementary	PK	03	2021	pk_12_total	262	262
351791	NH	school	3303840	259	Hollis	330384000171	21815	Hollis Primary School	Public School	Regular School	No	Elementary	PK	03	2021	pk_12_total	335	335
352590	NH	school	3305880	453	Raymond	330588000384	21385	Lamprey River Elementary School	Public School	Regular School	No	Elementary	KG	03	2021	pk_12_total	354	354
354664	NH	school	3303090	185	Franklin	330309000130	20650	Paul A. Smith School	Public School	Regular School	No	Elementary	PK	03	2021	pk_12_total	294	294
355242	NH	school	3302070	71	Brookline	330207000031	21800	Richard Maghakian Memorial School	Public School	Regular School	No	Elementary	PK	03	2021	pk_12_total	315	315
356415	NH	school	3303000	175	Farmington	330300000597	27980	Valley View Community School	Public School	Regular School	No	Elementary	PK	03	2021	pk_12_total	231	231
357027	NH	school	3303660	238	Haverhill Cooperative	330366000159	20905	Woodsville Elementary School	Public School	Regular School	No	Elementary	PK	03	2021	pk_12_total	189	189
348714	NH	school	3302990	174	Fall Mountain Regional	330299000112	22960	Acworth Elementary School	Public School	Regular School	No	Elementary	01	04	2021	pk_12_total	24	24
348748	NH	school	3301380	9	Allenstown	330138000001	22580	Allenstown Elementary School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	189	189
348765	NH	school	3302990	174	Fall Mountain Regional	330299000113	22965	Alstead Primary School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	80	80
348867	NH	school	3302480	112	Contoocook Valley	330248000065	22215	Antrim Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	117	117
348986	NH	school	3301650	33	Barrington	330165000013	22045	Barrington Elementary School	Public School	Regular School	No	Elementary	01	04	2021	pk_12_total	376	376
349020	NH	school	3303240	199	Goffstown	330324000138	20695	Bartlett Elementary School	Public School	Regular School	No	Elementary	01	04	2021	pk_12_total	193	193
349105	NH	school	3306180	486	Shaker Regional	330618000490	22135	Belmont Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	343	343
349309	NH	school	3301950	57	Bow	330195000480	20680	Bow Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	522	522
349513	NH	school	3304680	343	Mascoma Valley Regional	330468000273	21315	Canaan Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	200	200
349768	NH	school	3301470	17	Amherst	330147000006	21750	Clark-Wilkins School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	644	644
350006	NH	school	3302550	117	Croydon	330255000081	21960	Croydon Village School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	27	27
350482	NH	school	3304680	343	Mascoma Valley Regional	330468000274	21325	Enfield Village School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	185	185
350737	NH	school	3302480	112	Contoocook Valley	330248000069	22245	Francestown Elementary School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	47	47
350856	NH	school	3302640	141	Dover	330264000090	20430	Garrison School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	375	375
350907	NH	school	3303180	191	Gilford	330318000133	21245	Gilford Elementary School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	304	304
351026	NH	school	3307170	575	Windham	330717000461	21130	Golden Brook Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	1011	1011
351094	NH	school	3304590	335	Manchester	330459000246	21530	Gossler Park School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	332	332
351213	NH	school	3302480	112	Contoocook Valley	330248000070	22250	Greenfield Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	86	86
351247	NH	school	3304350	315	Litchfield	330435000228	21095	Griffin Memorial School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	414	414
351349	NH	school	3303480	223	Hampstead	330348000153	22755	Hampstead Central School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	443	443
351417	NH	school	3302480	112	Contoocook Valley	330248000071	22260	Hancock Elementary School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	49	49
351451	NH	school	3304230	295	Lebanon	330423000217	21335	Hanover Street School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	310	310
351604	NH	school	3304670	342	Mascenic Regional	330467000697	90393	Highbridge Hill Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	351	351
351910	NH	school	3302640	141	Dover	330264000091	20445	Horne Street School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	395	395
352148	NH	school	3304740	351	Merrimack	330474000276	21020	James Mastricola Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	401	401
353185	NH	school	3303240	199	Goffstown	330324000139	20690	Maple Avenue School	Public School	Regular School	No	Elementary	01	04	2021	pk_12_total	487	487
353355	NH	school	3305520	423	Oyster River Coop	330552000352	22805	Mast Way School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	326	326
353457	NH	school	3301740	41	Bedford	330174000018	20990	Memorial School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	394	394
353746	NH	school	3305520	423	Oyster River Coop	330552000520	26660	Moharimet School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	288	288
353865	NH	school	3304960	369	Moultonborough	330496000147	22115	Moultonborough Central School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	176	176
353950	NH	school	3304230	295	Lebanon	330423000220	21355	Mt. Lebanon School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	208	208
354001	NH	school	3305940	461	Rochester	330594000522	22660	Nancy Loud School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	92	92
354409	NH	school	3302990	174	Fall Mountain Regional	330299000118	23005	North Walpole School	Public School	Regular School	No	Elementary	02	04	2021	pk_12_total	83	83
354443	NH	school	3304590	335	Manchester	330459000505	26435	Northwest Elementary School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	495	495
354647	NH	school	3304590	335	Manchester	330459000254	21540	Parker-Varney School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	369	369
354766	NH	school	3305580	427	Pembroke	330558000361	22615	Pembroke Hill School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	317	317
354817	NH	school	3301740	41	Bedford	330174000019	21000	Peter Woodbury School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	478	478
354834	NH	school	3302480	112	Contoocook Valley	330248000072	22310	Peterborough Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	246	246
354851	NH	school	3302480	112	Contoocook Valley	330248000074	22225	Pierce Elementary School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	66	66
355225	NH	school	3304740	351	Merrimack	330474000279	21015	Reeds Ferry School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	407	407
355276	NH	school	3301740	41	Bedford	330174000580	27680	Riddle Brook School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	512	512
355446	NH	school	3306030	471	Rye	330603000398	22475	Rye Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	208	208
355633	NH	school	3302990	174	Fall Mountain Regional	330299000119	22995	Sarah Porter School	Public School	Regular School	No	Elementary	01	04	2021	pk_12_total	16	16
355650	NH	school	3305940	461	Rochester	330594000393	22720	School Street School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	80	80
355667	NH	school	3306150	485	Seabrook	330615000410	20810	Seabrook Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	350	350
356194	NH	school	3302480	112	Contoocook Valley	330248000075	22330	Temple Elementary School	Public School	Regular School	No	Elementary	KG	04	2021	pk_12_total	46	46
356279	NH	school	3304740	351	Merrimack	330474000280	21035	Thorntons Ferry School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	506	506
357010	NH	school	3302640	141	Dover	330264000094	20460	Woodman Park School	Public School	Regular School	No	Elementary	PK	04	2021	pk_12_total	446	446
348663	NH	school	3302460	111	Concord	330246000054	20240	Abbot-Downing School	Public School	Regular School	No	Elementary	KG	05	2021	pk_12_total	325	325
348731	NH	school	3303510	225	Hampton	330351000470	20795	Adeline C. Marston School	Public School	Regular School	No	Elementary	03	05	2021	pk_12_total	284	284
348833	NH	school	3304980	371	Nashua	330498000310	21940	Amherst Street School	Public School	Regular School	No	Elementary	KG	05	2021	pk_12_total	266	266
348918	NH	school	3306720	534	Timberlane Regional	330672000434	22740	Atkinson Academy	Public School	Regular School	No	Elementary	PK	05	2021	pk_12_total	336	336
348952	NH	school	3304590	335	Manchester	330459000240	21545	Bakersville School	Public School	Regular School	No	Elementary	PK	05	2021	pk_12_total	402	402
349054	NH	school	3302460	111	Concord	330246000496	26490	Beaver Meadow School	Public School	Regular School	No	Elementary	PK	05	2021	pk_12_total	328	328
349088	NH	school	3304590	335	Manchester	330459000241	21600	Beech Street School	Public School	Regular School	No	Elementary	KG	05	2021	pk_12_total	499	499
349156	NH	school	3301860	51	Berlin	330186000163	27035	Berlin Elementary School	Public School	Regular School	No	Elementary	PK	05	2021	pk_12_total	485	485
349207	NH	school	3303600	233	Hanover	330360000155	20830	Bernice A. Ray School	Public School	Regular School	No	Elementary	KG	05	2021	pk_12_total	451	451
349241	NH	school	3304980	371	Nashua	330498000312	21865	Bicentennial Elementary School	Public School	Regular School	No	Elementary	PK	05	2021	pk_12_total	458	458
349258	NH	school	3304980	371	Nashua	330498000313	21895	Birch Hill Elementary School	Public School	Regular School	No	Elementary	PK	05	2021	pk_12_total	333	333
349275	NH	school	3302340	101	Claremont	330234000038	20145	Bluff School	Public School	Regular School	No	Elementary	KG	05	2021	pk_12_total	143	143
349292	NH	school	3304760	352	Merrimack Valley	330476000281	22155	Boscawen Elementary School	Public School	Regular School	No	Elementary	PK	05	2021	pk_12_total	219	219
349377	NH	school	3305220	388	Newfound Area	330522000590	27685	Bridgewater-Hebron Village School	Public School	Regular School	No	Elementary	PK	05	2021	pk_12_total	136	136
349394	NH	school	3305220	388	Newfound Area	330522000332	20090	Bristol Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	pk_12_total	199	199
349411	NH	school	3304980	371	Nashua	330498000314	21925	Broad Street Elementary School	Public School	Regular School	No	Elementary	PK	05	2021	pk_12_total	284	284
349428	NH	school	3302460	111	Concord	330246000053	20260	Broken Ground School	Public School	Regular School	No	Elementary	03	05	2021	pk_12_total	314	314
349530	NH	school	3306180	486	Shaker Regional	330618000412	22165	Canterbury Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	pk_12_total	105	105
349581	NH	school	3306930	555	Weare	330693000025	26810	Center Woods School	Public School	Regular School	No	Elementary	PK	05	2021	pk_12_total	544	544
349598	NH	school	3305940	461	Rochester	330594000388	22695	Chamberlain Street School	Public School	Regular School	No	Elementary	KG	05	2021	pk_12_total	333	333
349632	NH	school	3302990	174	Fall Mountain Regional	330299000115	22985	Charlestown Primary School	Public School	Regular School	No	Elementary	PK	05	2021	pk_12_total	218	218
349649	NH	school	3304980	371	Nashua	330498000315	21930	Charlotte Ave Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	pk_12_total	373	373
349717	NH	school	3302460	111	Concord	330246000060	20305	Christa McAuliffe School	Public School	Regular School	No	Elementary	KG	05	2021	pk_12_total	346	346
350057	NH	school	3305220	388	Newfound Area	330522000334	20095	Danbury Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	pk_12_total	57	57
350091	NH	school	3306720	534	Timberlane Regional	330672000435	22745	Danville Elementary School	Public School	Regular School	No	Elementary	PK	05	2021	pk_12_total	250	250
350159	NH	school	3302610	131	Derry Cooperative	330261000083	20380	Derry Village School	Public School	Regular School	No	Elementary	KG	05	2021	pk_12_total	389	389
350176	NH	school	3302340	101	Claremont	330234000488	20165	Disnard Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	pk_12_total	240	240
350261	NH	school	3306060	473	Salem	330606000401	22895	Dr. L. F. Soule School	Public School	Regular School	No	Elementary	KG	05	2021	pk_12_total	249	249
350278	NH	school	3304980	371	Nashua	330498000486	21835	Dr. Norman W. Crisp School	Public School	Regular School	No	Elementary	KG	05	2021	pk_12_total	379	379