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
260766	NH	school	3304410	319	Londonderry	330441000594	27905	Moose Hill School		Regular School	No	Elementary	PK	KG	2020	pre_kindergarten	124.0	124
260610	NH	school	3302610	131	Derry Cooperative	330261000716	29156	Derry Early Education Program		Regular School	No	Elementary	PK	KG	2020	pre_kindergarten	120.0	120
260733	NH	school	3304050	279	Keene	330405000723	29180	Jonathan Daniels School		Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	114.0	114
260840	NH	school	3304980	371	Nashua	330498000314	21925	Broad Street Elementary School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	106.0	106
260780	NH	school	3304590	335	Manchester	330459000252	21590	Jewett School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	104.0	104
260710	NH	school	3303930	267	Hudson	330393000180	21045	Dr. H. O. Smith Elementary School		Regular School	No	Elementary	PK	01	2020	pre_kindergarten	103.0	103
260788	NH	school	3304590	335	Manchester	330459000254	21540	Parker-Varney School		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	94.0	94
260792	NH	school	3304590	335	Manchester	330459000262	21515	Weston Elementary School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	90.0	90
353833	NH	school	3304410	319	Londonderry	330441000594	27905	Moose Hill School	Public School	Regular School	No	Elementary	PK	KG	2021	pre_kindergarten	89	89
260929	NH	school	3306060	473	Salem	330606000740	29225	Salem Preschool		Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	87.0	87
260661	NH	school	3303240	199	Goffstown	330324000620	28525	Glen Lake School		Regular School	No	Elementary	PK	KG	2020	pre_kindergarten	84.0	84
260852	NH	school	3304980	371	Nashua	330498000324	21845	New Searles School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	80.0	80
260963	NH	school	3306720	534	Timberlane Regional	330672000438	22775	Sandown Central School		Regular School	No	Elementary	PK	KG	2020	pre_kindergarten	80.0	80
355499	NH	school	3306060	473	Salem	330606000740	29225	Salem Preschool	Public School	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	80	80
350144	NH	school	3302610	131	Derry Cooperative	330261000716	29156	Derry Early Education Program	Public School	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	74	74
260771	NH	school	3304590	335	Manchester	330459000240	21545	Bakersville School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	72.0	72
260912	NH	school	3305940	461	Rochester	330594000392	22650	East Rochester School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	69.0	69
260884	NH	school	3305550	425	Pelham	330555000600	27970	Pelham Elementary School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	66.0	66
260984	NH	school	3307170	575	Windham	330717000461	21130	Golden Brook Elementary School		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	65.0	65
260578	NH	school	3302340	101	Claremont	330234000724	29184	Claremont Preschool Center		Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	64.0	64
355584	NH	school	3306720	534	Timberlane Regional	330672000438	22775	Sandown Central School	Public School	Regular School	No	Elementary	PK	KG	2021	pre_kindergarten	64	64
348954	NH	school	3304590	335	Manchester	330459000240	21545	Bakersville School	Public School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	63	63
352269	NH	school	3304050	279	Keene	330405000723	29180	Jonathan Daniels School	Public School	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	63	63
260819	NH	school	3304830	357	Milford	330483000507	26580	Jacques Memorial Elementary School		Regular School	No	Elementary	PK	01	2020	pre_kindergarten	61.0	61
260557	NH	school	3301740	41	Bedford	330174000018	20990	Memorial School		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	59.0	59
260622	NH	school	3302640	141	Dover	330264000094	20460	Woodman Park School		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	58.0	58
260808	NH	school	3304740	351	Merrimack	330474000280	21035	Thorntons Ferry School		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	58.0	58
260803	NH	school	3304740	351	Merrimack	330474000276	21020	James Mastricola Elementary School		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	56.0	56
349413	NH	school	3304980	371	Nashua	330498000314	21925	Broad Street Elementary School	Public School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	56	56
354496	NH	school	3303930	267	Hudson	330393000513	26765	Nottingham West Elementary School	Public School	Regular School	No	Elementary	02	05	2021	pre_kindergarten	56	56
260585	NH	school	3302460	111	Concord	330246000496	26490	Beaver Meadow School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	55.0	55
352150	NH	school	3304740	351	Merrimack	330474000276	21020	James Mastricola Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	pre_kindergarten	53	53
352201	NH	school	3304590	335	Manchester	330459000252	21590	Jewett School	Public School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	53	53
349753	NH	school	3302340	101	Claremont	330234000724	29184	Claremont Preschool Center	Public School	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	51	51
260543	NH	school	3301440	15	Alton	330144000003	22480	Alton Central School (Elem)		Regular School	No	Elementary	PK	08	2020	pre_kindergarten	50.0	50
260589	NH	school	3302460	111	Concord	330246000056	20250	Mill Brook School		Regular School	No	Elementary	PK	02	2020	pre_kindergarten	50.0	50
350994	NH	school	3303240	199	Goffstown	330324000620	28525	Glen Lake School	Public School	Regular School	No	Elementary	PK	KG	2021	pre_kindergarten	49	49
356689	NH	school	3304590	335	Manchester	330459000262	21515	Weston Elementary School	Public School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	48	48
260908	NH	school	3305880	453	Raymond	330588000384	21385	Lamprey River Elementary School		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	47.0	47
260830	NH	school	3304890	363	Monadnock Regional	330489000302	21695	Mt. Caesar Elementary School		Regular School	No	Elementary	PK	02	2020	pre_kindergarten	46.0	46
260838	NH	school	3304980	371	Nashua	330498000312	21865	Bicentennial Elementary School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	46.0	46
260851	NH	school	3304980	371	Nashua	330498000714	29152	Nashua Title I Preschool		Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	46.0	46
353935	NH	school	3304890	363	Monadnock Regional	330489000302	21695	Mt. Caesar Elementary School	Public School	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	46	46
354156	NH	school	3304980	371	Nashua	330498000324	21845	New Searles School	Public School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	46	46
354649	NH	school	3304590	335	Manchester	330459000254	21540	Parker-Varney School	Public School	Regular School	No	Elementary	PK	04	2021	pre_kindergarten	46	46
260635	NH	school	3302970	173	Exeter	330297000109	20575	Main Street School		Regular School	No	Elementary	PK	02	2020	pre_kindergarten	44.0	44
260743	NH	school	3304140	285	Laconia	330414000213	21285	Woodland Heights Elementary School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	44.0	44
350382	NH	school	3305940	461	Rochester	330594000392	22650	East Rochester School	Public School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	44	44
351028	NH	school	3307170	575	Windham	330717000461	21130	Golden Brook Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	pre_kindergarten	44	44
353459	NH	school	3301740	41	Bedford	330174000018	20990	Memorial School	Public School	Regular School	No	Elementary	PK	04	2021	pre_kindergarten	44	44
348784	NH	school	3301440	15	Alton	330144000003	22480	Alton Central School (Elem)	Public School	Regular School	No	Elementary	PK	08	2021	pre_kindergarten	43	43
260867	NH	school	3305280	399	Newmarket	330528000340	21300	Newmarket Elementary School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	42.0	42
350331	NH	school	3301650	33	Barrington	330165000700	29010	Early Childhood Learning Center	Public School	Regular School	No	Elementary	PK	KG	2021	pre_kindergarten	42	42
260552	NH	school	3301650	33	Barrington	330165000700	29010	Early Childhood Learning Center		Regular School	No	Elementary	PK	KG	2020	pre_kindergarten	41.0	41
260758	NH	school	3304350	315	Litchfield	330435000228	21095	Griffin Memorial School		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	41.0	41
260798	NH	school	3304680	343	Mascoma Valley Regional	330468000273	21315	Canaan Elementary School		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	41.0	41
354700	NH	school	3305550	425	Pelham	330555000600	27970	Pelham Elementary School	Public School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	41	41
260609	NH	school	3302580	127	Deerfield	330258000082	22595	Deerfield Community School		Regular School	No	Elementary	PK	08	2020	pre_kindergarten	40.0	40
260627	NH	school	3302880	165	Epping	330288000102	26510	Epping Elementary School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	40.0	40
260749	NH	school	3304230	295	Lebanon	330423000220	21355	Mt. Lebanon School		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	40.0	40
356995	NH	school	3304140	285	Laconia	330414000213	21285	Woodland Heights Elementary School	Public School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	40	40
260545	NH	school	3301470	17	Amherst	330147000006	21750	Clark-Wilkins School		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	39.0	39
260678	NH	school	3303480	223	Hampstead	330348000153	22755	Hampstead Central School		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	39.0	39
260691	NH	school	3303750	251	Hillsboro-Deering Cooperative	330375000165	20955	Hillsboro-Deering Elementary School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	39.0	39
260937	NH	school	3306150	485	Seabrook	330615000410	20810	Seabrook Elementary School		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	39.0	39
357012	NH	school	3302640	141	Dover	330264000094	20460	Woodman Park School	Public School	Regular School	No	Elementary	PK	04	2021	pre_kindergarten	39	39
355210	NH	school		453	Raymond			Raymond School District Preschool Program							2021	pre_kindergarten	38	38
260720	NH	school	3304030	274	Jaffrey-Rindge Cooperative	330403000189	22275	Jaffrey Grade School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	37.0	37
260835	NH	school	3304960	369	Moultonborough	330496000147	22115	Moultonborough Central School		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	37.0	37
260591	NH	school	3302480	112	Contoocook Valley	330248000065	22215	Antrim Elementary School		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	36.0	36
260807	NH	school	3304740	351	Merrimack	330474000279	21015	Reeds Ferry School		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	36.0	36
353646	NH	school		357	Milford			Milford Early Education Experiences							2021	pre_kindergarten	36	36
260724	NH	school	3304040	276	Kearsarge Regional	330404000687	26565	James House Preschool		Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	35.0	35
260854	NH	school	3304980	371	Nashua	330498000682	28610	Purple Panthers Preschool		Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	35.0	35
260972	NH	school	3306930	555	Weare	330693000025	26810	Center Woods School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	35.0	35
351351	NH	school	3303480	223	Hampstead	330348000153	22755	Hampstead Central School	Public School	Regular School	No	Elementary	PK	04	2021	pre_kindergarten	35	35
353034	NH	school	3302970	173	Exeter	330297000109	20575	Main Street School	Public School	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	35	35
260682	NH	school	3303510	225	Hampton	330351000469	20770	Hampton Centre School		Regular School	No	Elementary	PK	02	2020	pre_kindergarten	34.0	34
260687	NH	school	3303660	238	Haverhill Cooperative	330366000159	20905	Woodsville Elementary School		Regular School	No	Elementary	PK	03	2020	pre_kindergarten	34.0	34
260705	NH	school	3303900	263	Hopkinton	330390000176	20975	Harold Martin School		Regular School	No	Elementary	PK	03	2020	pre_kindergarten	34.0	34
260883	NH	school	3305520	423	Oyster River Coop	330552000735	29210	Oyster River Preschool Education Program		Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	34.0	34
260939	NH	school	3306180	486	Shaker Regional	330618000490	22135	Belmont Elementary School		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	34.0	34
354054	NH	school	3304980	371	Nashua	330498000714	29152	Nashua Title I Preschool	Public School	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	34	34
260943	NH	school	3306240	491	Somersworth	330624000732	29202	Idlehurst Elementary School		Regular School	No	Elementary	PK	02	2020	pre_kindergarten	33.0	33
260674	NH	school	3303330	208	Governor Wentworth Regional	330333000149	22405	Ossipee Central School		Regular School	No	Elementary	PK	06	2020	pre_kindergarten	32.0	32
356281	NH	school	3304740	351	Merrimack	330474000280	21035	Thorntons Ferry School	Public School	Regular School	No	Elementary	PK	04	2021	pre_kindergarten	32	32
260639	NH	school	3302990	174	Fall Mountain Regional	330299000115	22985	Charlestown Primary School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	31.0	31
354241	NH	school	3305280	399	Newmarket	330528000340	21300	Newmarket Elementary School	Public School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	31	31
260898	NH	school	3305790	447	Plymouth	330579000370	22355	Plymouth Elementary School		Regular School	No	Elementary	PK	08	2020	pre_kindergarten	30.0	30
349056	NH	school	3302460	111	Concord	330246000496	26490	Beaver Meadow School	Public School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	30	30
351470	NH	school	3303900	263	Hopkinton	330390000176	20975	Harold Martin School	Public School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten	30	30
260722	NH	school	3304030	274	Jaffrey-Rindge Cooperative	330403000191	22320	Rindge Memorial School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	29.0	29
260991	NH	school	3307300	582	Winnisquam Regional	330730000467	22945	Union Sanborn School		Regular School	No	Elementary	PK	02	2020	pre_kindergarten	29.0	29
353867	NH	school	3304960	369	Moultonborough	330496000147	22115	Moultonborough Central School	Public School	Regular School	No	Elementary	PK	04	2021	pre_kindergarten	29	29
260647	NH	school	3302990	174	Fall Mountain Regional	330299000121	23010	Walpole Primary School		Regular School	No	Elementary	PK	01	2020	pre_kindergarten	28.0	28
260694	NH	school	3303780	255	Hinsdale	330378000167	21680	Hinsdale Elementary School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	28.0	28
260739	NH	school	3304140	285	Laconia	330414000209	21290	Elm Street School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	28.0	28
260978	NH	school	3307050	568	White Mountains Regional	330705000004	26930	Whitefield Elementary School		Regular School	No	Elementary	PK	08	2020	pre_kindergarten	28.0	28
355669	NH	school	3306150	485	Seabrook	330615000410	20810	Seabrook Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	pre_kindergarten	28	28
260703	NH	school	3303870	261	Hooksett	330387000173	20550	Fred C. Underhill School		Regular School	No	Elementary	PK	02	2020	pre_kindergarten	27.0	27
260848	NH	school	3304980	371	Nashua	330498000322	21885	Mt. Pleasant School		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	27.0	27