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 school_state_id 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
348896	NH	school	3301560	23	Ashland	330156000010	20010	Ashland Elementary School	Public School	Regular School	No	Elementary	KG	08	2021	grade_6	17	17
352007	NH	school	3303960	269	Inter-Lakes Cooperative	330396000185	20035	Inter-Lakes High School	Public School	Regular School	No	High	09	12	2021	grade_6	0	0
355611	NH	school	3303960	269	Inter-Lakes Cooperative	330396000183	20040	Sandwich Central School	Public School	Regular School	No	Elementary	KG	06	2021	grade_6	3	3
349168	NH	school	3301860	51	Berlin	330186000024	20045	Berlin Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_6	68	68
349185	NH	school	3301860	51	Berlin	330186000027	20050	Berlin Senior High School	Public School	Regular School	No	High	09	12	2021	grade_6	0	0
354200	NH	school	3305220	388	Newfound Area	330522000336	20085	Newfound Regional High School	Public School	Regular School	No	High	09	13	2021	grade_6	0	0
349389	NH	school	3305220	388	Newfound Area	330522000332	20090	Bristol Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
350052	NH	school	3305220	388	Newfound Area	330522000334	20095	Danbury Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
354132	NH	school	3305220	388	Newfound Area	330522000337	20105	New Hampton Community School	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
349729	NH	school	3302340	101	Claremont	330234000039	20115	Claremont Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_6	125	125
355951	NH	school	3302340	101	Claremont	330234000045	20140	Stevens High School	Public School	Regular School	No	High	09	13	2021	grade_6	0	0
349270	NH	school	3302340	101	Claremont	330234000038	20145	Bluff School	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
353163	NH	school	3302340	101	Claremont	330234000040	20160	Maple Avenue School	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
350171	NH	school	3302340	101	Claremont	330234000488	20165	Disnard Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
349967	NH	school	3302520	115	Cornish	330252000080	20175	Cornish Elementary School	Public School	Regular School	No	Elementary	PK	08	2021	grade_6	4	4
356393	NH	school	3306750	539	Unity	330675000441	20180	Unity Elementary School	Public School	Regular School	No	Elementary	PK	08	2021	grade_6	18	18
349831	NH	school	3302400	105	Colebrook	330240000049	20185	Colebrook Academy and Elementary School (H)	Public School	Regular School	No	High	09	12	2021	grade_6	0	0
349814	NH	school	3302400	105	Colebrook	330240000050	20195	Colebrook Academy and Elementary School (E)	Public School	Regular School	No	Elementary	PK	08	2021	grade_6	14	14
354914	NH	school	3305700	437	Pittsburg	330570000363	20205	Pittsburg School (Elem)	Public School	Regular School	No	Elementary	KG	08	2021	grade_6	5	5
348658	NH	school	3302460	111	Concord	330246000054	20240	Abbot-Downing School	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
353690	NH	school	3302460	111	Concord	330246000056	20250	Mill Brook School	Public School	Regular School	No	Elementary	PK	02	2021	grade_6	0	0
349423	NH	school	3302460	111	Concord	330246000053	20260	Broken Ground School	Public School	Regular School	No	Elementary	03	05	2021	grade_6	0	0
355407	NH	school	3302460	111	Concord	330246000063	20270	Rundlett Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_6	278	278
349899	NH	school	3302460	111	Concord	330246000055	20285	Concord High School	Public School	Regular School	No	High	09	13	2021	grade_6	0	0
349712	NH	school	3302460	111	Concord	330246000060	20305	Christa McAuliffe School	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
352279	NH	school	3301680	35	Bartlett	330168000015	20325	Josiah Bartlett Elementary School	Public School	Regular School	No	Elementary	PK	08	2021	grade_6	19	19
354880	NH	school	3302490	113	Conway	330249000079	20330	Pine Tree Elementary School	Public School	Regular School	No	Elementary	KG	06	2021	grade_6	35	35
352228	NH	school	3302490	113	Conway	330249000078	20335	John H. Fuller School	Public School	Regular School	No	Elementary	KG	06	2021	grade_6	32	32
349933	NH	school	3302490	113	Conway	330249000077	20340	Conway Elementary School	Public School	Regular School	No	Elementary	KG	06	2021	grade_6	31	31
352415	NH	school	3302490	113	Conway	330249000076	20345	Kennett High School	Public School	Regular School	No	High	09	12	2021	grade_6	0	0
350817	NH	school	3303120	187	Freedom	330312000131	20350	Freedom Elementary School	Public School	Regular School	No	Elementary	PK	06	2021	grade_6	10	10
352041	NH	school	3303990	271	Jackson	330399000187	20355	Jackson Grammar School	Public School	Regular School	No	Elementary	KG	06	2021	grade_6	8	8
352993	NH	school	3304560	333	Madison	330456000238	20360	Madison Elementary School	Public School	Regular School	No	Elementary	KG	06	2021	grade_6	13	13
352398	NH	school	3306600	525	Tamworth	330660000432	20365	Kenneth A. Brett School	Public School	Regular School	No	Elementary	KG	08	2021	grade_6	19	19
350341	NH	school	3302610	131	Derry Cooperative	330261000497	20370	East Derry Memorial Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
350154	NH	school	3302610	131	Derry Cooperative	330261000083	20380	Derry Village School	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
351259	NH	school	3302610	131	Derry Cooperative	330261000085	20390	Grinnell School	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
354897	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	grade_6	0	0
355849	NH	school	3302610	131	Derry Cooperative	330261000087	20405	South Range Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
350885	NH	school	3302610	131	Derry Cooperative	330261000086	20420	Gilbert H. Hood Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_6	191	191
350851	NH	school	3302640	141	Dover	330264000090	20430	Garrison School	Public School	Regular School	No	Elementary	KG	04	2021	grade_6	0	0
350188	NH	school	3302640	141	Dover	330264000089	20435	Dover Middle School	Public School	Regular School	No	Middle	05	08	2021	grade_6	255	255
351905	NH	school	3302640	141	Dover	330264000091	20445	Horne Street School	Public School	Regular School	No	Elementary	KG	04	2021	grade_6	0	0
350205	NH	school	3302640	141	Dover	330264000088	20455	Dover Senior High School	Public School	Regular School	No	High	09	12	2021	grade_6	0	0
357005	NH	school	3302640	141	Dover	330264000094	20460	Woodman Park School	Public School	Regular School	No	Elementary	PK	04	2021	grade_6	0	0
354370	NH	school	3304410	319	Londonderry	330441000234	20470	North Londonderry Elementary School	Public School	Regular School	No	Elementary	01	05	2021	grade_6	0	0
355815	NH	school	3304410	319	Londonderry	330441000473	20475	South Londonderry Elementary School	Public School	Regular School	No	Elementary	01	05	2021	grade_6	0	0
352908	NH	school	3304410	319	Londonderry	330441000232	20480	Londonderry Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_6	269	269
353367	NH	school	3304410	319	Londonderry	330441000233	20485	Matthew Thornton Elementary School	Public School	Regular School	No	Elementary	01	05	2021	grade_6	0	0
352925	NH	school	3304410	319	Londonderry	330441000484	20490	Londonderry Senior High School	Public School	Regular School	No	High	09	12	2021	grade_6	0	0
349661	NH	school	3302250	93	Chester	330225000035	20500	Chester Academy	Public School	Regular School	No	Elementary	PK	08	2021	grade_6	61	61
350511	NH	school	3302880	165	Epping	330288000103	20515	Epping High School	Public School	Regular School	No	High	09	12	2021	grade_6	0	0
350426	NH	school	3303150	189	Fremont	330315000132	20525	Ellis School	Public School	Regular School	No	Elementary	PK	08	2021	grade_6	43	43
348930	NH	school	3301590	29	Auburn	330159000011	20530	Auburn Village School	Public School	Regular School	No	Elementary	KG	08	2021	grade_6	78	78
351531	NH	school	3302130	79	Candia	330213000033	20535	Henry W. Moore School	Public School	Regular School	No	Elementary	KG	08	2021	grade_6	36	36
351854	NH	school	3303870	261	Hooksett	330387000175	20540	Hooksett Memorial School	Public School	Regular School	No	Elementary	03	05	2021	grade_6	0	0
350800	NH	school	3303870	261	Hooksett	330387000173	20550	Fred C. Underhill School	Public School	Regular School	No	Elementary	PK	02	2021	grade_6	0	0
356155	NH	school	3302010	63	Brentwood	330201000030	20555	Swasey Central School	Public School	Regular School	No	Elementary	PK	05	2021	grade_6	0	0
350358	NH	school	3302790	153	East Kingston	330279000100	20565	East Kingston Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
353027	NH	school	3302970	173	Exeter	330297000109	20575	Main Street School	Public School	Regular School	No	Elementary	PK	02	2021	grade_6	0	0
349950	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_6	338	338
352789	NH	school	3302970	173	Exeter	330297000108	20595	Lincoln Street Elementary School	Public School	Regular School	No	Elementary	03	05	2021	grade_6	0	0
350596	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	grade_6	0	0
352432	NH	school	3304080	281	Kensington	330408000208	20605	Kensington Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
354166	NH	school	3305190	387	Newfields	330519000331	20610	Newfields Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
356019	NH	school	3306480	511	Stratham	330648000429	20615	Stratham Memorial School	Public School	Regular School	No	Elementary	PK	05	2021	grade_6	0	0
355526	NH	school	3306080	476	Sanborn Regional	330608000479	20620	Sanborn Regional High School	Public School	Regular School	No	High	09	12	2021	grade_6	0	0
350069	NH	school	3306080	476	Sanborn Regional	330608000478	20625	Daniel J. Bakie School	Public School	Regular School	No	Elementary	PK	03	2021	grade_6	0	0
355543	NH	school	3306080	476	Sanborn Regional	330608000476	20630	Sanborn Regional Middle School	Public School	Regular School	No	Middle	07	08	2021	grade_6	0	0
353469	NH	school	3306080	476	Sanborn Regional	330608000477	20635	Memorial School	Public School	Regular School	No	Middle	04	06	2021	grade_6	103	103
354659	NH	school	3303090	185	Franklin	330309000130	20650	Paul A. Smith School	Public School	Regular School	No	Elementary	PK	03	2021	grade_6	0	0
350766	NH	school	3303090	185	Franklin	330309000128	20660	Franklin High School	Public School	Regular School	No	High	09	13	2021	grade_6	0	0
352177	NH	school	3303720	247	Hill	330372000164	20670	Jennie D. Blake School	Public School	Regular School	No	Elementary	KG	06	2021	grade_6	7	7
349338	NH	school	3301950	57	Bow	330195000029	20675	Bow Memorial School	Public School	Regular School	No	Middle	05	08	2021	grade_6	119	119
349304	NH	school	3301950	57	Bow	330195000480	20680	Bow Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	grade_6	0	0
350307	NH	school	3302760	149	Dunbarton	330276000098	20685	Dunbarton Elementary School	Public School	Regular School	No	Elementary	KG	06	2021	grade_6	34	34
353180	NH	school	3303240	199	Goffstown	330324000139	20690	Maple Avenue School	Public School	Regular School	No	Elementary	01	04	2021	grade_6	0	0
349015	NH	school	3303240	199	Goffstown	330324000138	20695	Bartlett Elementary School	Public School	Regular School	No	Elementary	01	04	2021	grade_6	0	0
351004	NH	school	3303240	199	Goffstown	330324000137	20700	Goffstown High School	Public School	Regular School	No	High	09	12	2021	grade_6	0	0
354081	NH	school	3305040	377	New Boston	330504000329	20715	New Boston Central School	Public School	Regular School	No	Elementary	PK	06	2021	grade_6	74	74
356563	NH	school	3306930	555	Weare	330693000023	20720	Weare Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_6	117	117
350579	NH	school	3302940	171	Errol	330294000105	20735	Errol Consolidated Elementary School	Public School	Regular School	No	Elementary	KG	08	2021	grade_6	0	0
350392	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500141	20745	Edward Fenn School	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
351055	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500142	20750	Gorham High School	Public School	Regular School	No	High	09	12	2021	grade_6	0	0
353605	NH	school	3304800	355	Milan	330480000289	20760	Milan Village Elementary School	Public School	Regular School	No	Elementary	PK	06	2021	grade_6	12	12
351395	NH	school	3303510	225	Hampton	330351000469	20770	Hampton Centre School	Public School	Regular School	No	Elementary	PK	02	2021	grade_6	0	0
356920	NH	school	3307230	581	Winnacunnet Cooperative	330723000463	20780	Winnacunnet High School	Public School	Regular School	No	High	09	13	2021	grade_6	0	0
351378	NH	school	3303510	225	Hampton	330351000471	20790	Hampton Academy	Public School	Regular School	No	Middle	06	08	2021	grade_6	117	117
348726	NH	school	3303510	225	Hampton	330351000470	20795	Adeline C. Marston School	Public School	Regular School	No	Elementary	03	05	2021	grade_6	0	0
352772	NH	school	3303540	227	Hampton Falls	330354000154	20800	Lincoln Akerman School	Public School	Regular School	No	Elementary	KG	08	2021	grade_6	30	30
354353	NH	school	3305370	405	North Hampton	330537000345	20805	North Hampton School	Public School	Regular School	No	Elementary	PK	08	2021	grade_6	40	40
355662	NH	school	3306150	485	Seabrook	330615000410	20810	Seabrook Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	grade_6	0	0
355798	NH	school	3306270	495	South Hampton	330627000422	20815	South Hampton Barnard School	Public School	Regular School	No	Elementary	KG	08	2021	grade_6	11	11
351429	NH	school	3302670	142	Dresden	330267000096	20820	Hanover High School	Public School	Regular School	No	High	09	12	2021	grade_6	0	0
350715	NH	school	3302670	142	Dresden	330267000095	20825	Frances C. Richmond School	Public School	Regular School	No	Middle	06	08	2021	grade_6	87	87
349202	NH	school	3303600	233	Hanover	330360000155	20830	Bernice A. Ray School	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
352959	NH	school	3304500	327	Lyme	330450000236	20835	Lyme Elementary School	Public School	Regular School	No	Elementary	KG	08	2021	grade_6	22	22
349032	NH	school	3301710	39	Bath	330171000016	20860	Bath Village School	Public School	Regular School	No	Elementary	KG	06	2021	grade_6	11	11
352721	NH	school	3304260	305	Lincoln-Woodstock Cooperative	330426000493	20880	Lin-Wood Public School (Elem)	Public School	Regular School	No	Elementary	KG	05	2021	grade_6	0	0
353792	NH	school	3304920	365	Monroe	330492000307	20885	Monroe Consolidated School	Public School	Regular School	No	Elementary	PK	08	2021	grade_6	5	5
354863	NH	school	3305670	435	Piermont	330567000362	20895	Piermont Village School	Public School	Regular School	No	Elementary	PK	08	2021	grade_6	4	4