schools: enrollments: 496 rows where where grade = "grade_7", state = "NH" and year = 2020 sorted by school

Data source: Big Local News · About: Big Local

496 rows where grade = "grade_7", state = "NH" and year = 2020 sorted by school

Search:

descending

Link	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
265066	265066	NH	school	3302490	113	Conway	330249000043	27010	A. Crosby Kennett Middle School		Regular School	No	Middle	07	08	2020	grade_7	130.0	130
265048	265048	NH	school	3302460	111	Concord	330246000054	20240	Abbot-Downing School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265463	265463	NH	school	3300040	725	Academy for Science and Design Charter School	330004000684	28615	Academy for Science and Design Charter (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	grade_7	0.0	0
265464	265464	NH	school	3300040	725	Academy for Science and Design Charter School	330004000678	28580	Academy for Science and Design Charter (M)	Public Charter Schools	Regular School	Yes	Middle	06	08	2020	grade_7	98.0	98
265100	265100	NH	school	3302990	174	Fall Mountain Regional	330299000112	22960	Acworth Elementary School		Regular School	No	Elementary	01	04	2020	grade_7	0.0	0
265144	265144	NH	school	3303510	225	Hampton	330351000470	20795	Adeline C. Marston School		Regular School	No	Elementary	03	05	2020	grade_7	0.0	0
265005	265005	NH	school	3301380	9	Allenstown	330138000001	22580	Allenstown Elementary School		Regular School	No	Elementary	KG	04	2020	grade_7	0.0	0
265101	265101	NH	school	3302990	174	Fall Mountain Regional	330299000113	22965	Alstead Primary School		Regular School	No	Elementary	PK	04	2020	grade_7	0.0	0
265007	265007	NH	school	3301440	15	Alton	330144000003	22480	Alton Central School (Elem)		Regular School	No	Elementary	PK	08	2020	grade_7	48.0	48
265173	265173	NH	school	3303930	267	Hudson	330393000179	21050	Alvirne High School		Regular School	No	High	09	12	2020	grade_7	0.0	0
265008	265008	NH	school	3301470	17	Amherst	330147000007	21745	Amherst Middle School		Regular School	No	Middle	05	08	2020	grade_7	168.0	168
265301	265301	NH	school	3304980	371	Nashua	330498000310	21940	Amherst Street School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265010	265010	NH	school	3301500	19	Andover	330150000008	22130	Andover Elementary School		Regular School	No	Elementary	KG	08	2020	grade_7	31.0	31
265055	265055	NH	school	3302480	112	Contoocook Valley	330248000065	22215	Antrim Elementary School		Regular School	No	Elementary	PK	04	2020	grade_7	0.0	0
265006	265006	NH	school	3301380	9	Allenstown	330138000002	22575	Armand R. Dupont School		Regular School	No	Middle	05	08	2020	grade_7	47.0	47
265011	265011	NH	school	3301560	23	Ashland	330156000010	20010	Ashland Elementary School		Regular School	No	Elementary	KG	08	2020	grade_7	14.0	14
265424	265424	NH	school	3306720	534	Timberlane Regional	330672000434	22740	Atkinson Academy		Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265012	265012	NH	school	3301590	29	Auburn	330159000011	20530	Auburn Village School		Regular School	No	Elementary	KG	08	2020	grade_7	72.0	72
265235	265235	NH	school	3304590	335	Manchester	330459000240	21545	Bakersville School		Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265013	265013	NH	school	3301620	31	Barnstead	330162000012	22485	Barnstead Elementary School		Regular School	No	Elementary	PK	08	2020	grade_7	37.0	37
265014	265014	NH	school	3301650	33	Barrington	330165000013	22045	Barrington Elementary School		Regular School	No	Elementary	01	04	2020	grade_7	0.0	0
265015	265015	NH	school	3301650	33	Barrington	330165000014	22030	Barrington Middle School		Regular School	No	Middle	05	08	2020	grade_7	93.0	93
265124	265124	NH	school	3303240	199	Goffstown	330324000138	20695	Bartlett Elementary School		Regular School	No	Elementary	01	04	2020	grade_7	0.0	0
265018	265018	NH	school	3301710	39	Bath	330171000016	20860	Bath Village School		Regular School	No	Elementary	KG	06	2020	grade_7	0.0	0
265049	265049	NH	school	3302460	111	Concord	330246000496	26490	Beaver Meadow School		Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265019	265019	NH	school	3301740	41	Bedford	330174000680	28555	Bedford High School		Regular School	No	High	09	12	2020	grade_7	0.0	0
265236	265236	NH	school	3304590	335	Manchester	330459000241	21600	Beech Street School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265403	265403	NH	school	3306180	486	Shaker Regional	330618000490	22135	Belmont Elementary School		Regular School	No	Elementary	PK	04	2020	grade_7	0.0	0
265404	265404	NH	school	3306180	486	Shaker Regional	330618000411	22145	Belmont High School		Regular School	No	High	09	12	2020	grade_7	0.0	0
265405	265405	NH	school	3306180	486	Shaker Regional	330618000413	22150	Belmont Middle School		Regular School	No	Middle	05	08	2020	grade_7	110.0	110
265025	265025	NH	school	3301860	51	Berlin	330186000163	27035	Berlin Elementary School		Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265026	265026	NH	school	3301860	51	Berlin	330186000024	20045	Berlin Middle School		Regular School	No	Middle	06	08	2020	grade_7	76.0	76
265027	265027	NH	school	3301860	51	Berlin	330186000027	20050	Berlin Senior High School		Regular School	No	High	09	12	2020	grade_7	0.0	0
265148	265148	NH	school	3303600	233	Hanover	330360000155	20830	Bernice A. Ray School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265028	265028	NH	school	3301890	53	Bethlehem	330189000028	21400	Bethlehem Elementary School		Regular School	No	Elementary	PK	06	2020	grade_7	0.0	0
265302	265302	NH	school	3304980	371	Nashua	330498000312	21865	Bicentennial Elementary School		Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265303	265303	NH	school	3304980	371	Nashua	330498000313	21895	Birch Hill Elementary School		Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265040	265040	NH	school	3302340	101	Claremont	330234000038	20145	Bluff School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265273	265273	NH	school	3304760	352	Merrimack Valley	330476000281	22155	Boscawen Elementary School		Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265029	265029	NH	school	3301950	57	Bow	330195000480	20680	Bow Elementary School		Regular School	No	Elementary	PK	04	2020	grade_7	0.0	0
265030	265030	NH	school	3301950	57	Bow	330195000563	27375	Bow High School		Regular School	No	High	09	12	2020	grade_7	0.0	0
265031	265031	NH	school	3301950	57	Bow	330195000029	20675	Bow Memorial School		Regular School	No	Middle	05	08	2020	grade_7	143.0	143
265259	265259	NH	school	3304670	342	Mascenic Regional	330467000515	26685	Boynton Middle School		Regular School	No	Middle	05	08	2020	grade_7	84.0	84
265324	265324	NH	school	3305220	388	Newfound Area	330522000590	27685	Bridgewater-Hebron Village School		Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265325	265325	NH	school	3305220	388	Newfound Area	330522000332	20090	Bristol Elementary School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265304	265304	NH	school	3304980	371	Nashua	330498000314	21925	Broad Street Elementary School		Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265050	265050	NH	school	3302460	111	Concord	330246000053	20260	Broken Ground School		Regular School	No	Elementary	03	05	2020	grade_7	0.0	0
265374	265374	NH	school	3305940	461	Rochester	330594000694	22675	Bud Carlson Academy		Regular School	No	High	09	12	2020	grade_7	0.0	0
265470	265470	NH	school	3300041	723	CSI Charter School	330004100677	28575	CSI Charter School	Public Charter Schools	Regular School	Yes	High	11	12	2020	grade_7	0.0	0
265221	265221	NH	school	3304350	315	Litchfield	330435000674	27715	Campbell High School		Regular School	No	High	09	12	2020	grade_7	0.0	0
265035	265035	NH	school	3302100	75	Campton	330210000032	22335	Campton Elementary School		Regular School	No	Elementary	PK	08	2020	grade_7	33.0	33
265262	265262	NH	school	3304680	343	Mascoma Valley Regional	330468000273	21315	Canaan Elementary School		Regular School	No	Elementary	PK	04	2020	grade_7	0.0	0
265406	265406	NH	school	3306180	486	Shaker Regional	330618000412	22165	Canterbury Elementary School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265465	265465	NH	school	3303313	710	Capital City Public Charter School	330331300729	29194	Capital City Public Charter School (E)	Public Charter Schools	Regular School	Yes	Middle	06	08	2020	grade_7	13.0	13
265466	265466	NH	school	3303313	710	Capital City Public Charter School	330331300728	29195	Capital City Public Charter School (H)	Public Charter Schools	Regular School	Yes	Secondary	09	11	2020	grade_7	0.0	0
265033	265033	NH	school	3302070	71	Brookline	330207000670	27765	Captain Samuel Douglass Academy		Regular School	No	Middle	04	06	2020	grade_7	0.0	0
265132	265132	NH	school	3303330	208	Governor Wentworth Regional	330333000144	22430	Carpenter Elementary School		Regular School	No	Elementary	KG	03	2020	grade_7	0.0	0
265436	265436	NH	school	3306930	555	Weare	330693000025	26810	Center Woods School		Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265375	265375	NH	school	3305940	461	Rochester	330594000388	22695	Chamberlain Street School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265102	265102	NH	school	3302990	174	Fall Mountain Regional	330299000114	22975	Charlestown Middle School		Regular School	No	Middle	06	08	2020	grade_7	50.0	50
265103	265103	NH	school	3302990	174	Fall Mountain Regional	330299000115	22985	Charlestown Primary School		Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265305	265305	NH	school	3304980	371	Nashua	330498000315	21930	Charlotte Ave Elementary School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265037	265037	NH	school	3302250	93	Chester	330225000035	20500	Chester Academy		Regular School	No	Elementary	PK	08	2020	grade_7	69.0	69
265038	265038	NH	school	3302280	95	Chesterfield	330228000036	21140	Chesterfield Central School		Regular School	No	Elementary	KG	08	2020	grade_7	34.0	34
265039	265039	NH	school	3302310	99	Chichester	330231000037	22590	Chichester Central School		Regular School	No	Elementary	KG	08	2020	grade_7	27.0	27
265051	265051	NH	school	3302460	111	Concord	330246000060	20305	Christa McAuliffe School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265041	265041	NH	school	3302340	101	Claremont	330234000039	20115	Claremont Middle School		Regular School	No	Middle	06	08	2020	grade_7	149.0	149
265042	265042	NH	school	3302340	101	Claremont	330234000724	29184	Claremont Preschool Center		Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
265009	265009	NH	school	3301470	17	Amherst	330147000006	21750	Clark-Wilkins School		Regular School	No	Elementary	PK	04	2020	grade_7	0.0	0
265467	265467	NH	school	3300036	707	Cocheco Academy for the Arts	330003600614	28455	Cocheco Academy for the Arts	Public Charter Schools	Regular School	Yes	High	09	12	2020	grade_7	0.0	0
265458	265458	NH	school	3307330	998	Coe-Brown Northwood Academy	330733000519	22025	Coe-Brown Northwood Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	12	2020	grade_7	0.0	0
265046	265046	NH	school	3302400	105	Colebrook	330240000050	20195	Colebrook Academy and Elementary School (E)		Regular School	No	Elementary	PK	08	2020	grade_7	21.0	21
265047	265047	NH	school	3302400	105	Colebrook	330240000049	20185	Colebrook Academy and Elementary School (H)		Regular School	No	High	09	12	2020	grade_7	0.0	0
265468	265468	NH	school	3303301	743	Compass Classical Academy Charter School	330330100718	29166	Compass Classical Academy Charter School (E)	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	grade_7	12.0	12
265469	265469	NH	school	3303301	743	Compass Classical Academy Charter School	330330100739	29224	Compass Classical Academy Charter School (H)	Public Charter Schools	Regular School	Yes	Secondary	09	09	2020	grade_7	0.0	0
265183	265183	NH	school	3304030	274	Jaffrey-Rindge Cooperative	330403000188	22265	Conant High School		Regular School	No	High	09	12	2020	grade_7	0.0	0
265052	265052	NH	school	3302460	111	Concord	330246000055	20285	Concord High School		Regular School	No	High	09	13	2020	grade_7	0.0	0
265056	265056	NH	school	3302480	112	Contoocook Valley	330248000067	22290	Conval Regional High School		Regular School	No	High	09	12	2020	grade_7	0.0	0
265067	265067	NH	school	3302490	113	Conway	330249000077	20340	Conway Elementary School		Regular School	No	Elementary	KG	06	2020	grade_7	0.0	0
265096	265096	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	grade_7	387.0	387
265071	265071	NH	school	3302520	115	Cornish	330252000080	20175	Cornish Elementary School		Regular School	No	Elementary	PK	08	2020	grade_7	5.0	5
265133	265133	NH	school	3303330	208	Governor Wentworth Regional	330333000565	27515	Crescent Lake School		Regular School	No	Middle	04	06	2020	grade_7	0.0	0
265072	265072	NH	school	3302550	117	Croydon	330255000081	21960	Croydon Village School		Regular School	No	Elementary	KG	04	2020	grade_7	0.0	0
265289	265289	NH	school	3304890	363	Monadnock Regional	330489000298	21715	Cutler Elementary School		Regular School	No	Elementary	03	06	2020	grade_7	0.0	0
265224	265224	NH	school	3304380	317	Littleton	330438000231	21440	Daisy Bronson Junior High School		Regular School	No	Middle	07	08	2020	grade_7	47.0	47
265326	265326	NH	school	3305220	388	Newfound Area	330522000334	20095	Danbury Elementary School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265397	265397	NH	school	3306080	476	Sanborn Regional	330608000478	20625	Daniel J. Bakie School		Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265425	265425	NH	school	3306720	534	Timberlane Regional	330672000435	22745	Danville Elementary School		Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265166	265166	NH	school	3303870	261	Hooksett	330387000618	28050	David R. Cawley Middle School		Regular School	No	Middle	06	08	2020	grade_7	147.0	147
265073	265073	NH	school	3302580	127	Deerfield	330258000082	22595	Deerfield Community School		Regular School	No	Elementary	PK	08	2020	grade_7	58.0	58
265074	265074	NH	school	3302610	131	Derry Cooperative	330261000716	29156	Derry Early Education Program		Regular School	No	Elementary	PK	KG	2020	grade_7	0.0	0
265075	265075	NH	school	3302610	131	Derry Cooperative	330261000083	20380	Derry Village School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265043	265043	NH	school	3302340	101	Claremont	330234000488	20165	Disnard Elementary School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265082	265082	NH	school	3302640	141	Dover	330264000089	20435	Dover Middle School		Regular School	No	Middle	05	08	2020	grade_7	257.0	257
265083	265083	NH	school	3302640	141	Dover	330264000088	20455	Dover Senior High School		Regular School	No	High	09	12	2020	grade_7	0.0	0
265290	265290	NH	school	3304890	363	Monadnock Regional	330489000299	21665	Dr. George S. Emerson Elementary School		Regular School	No	Elementary	PK	06	2020	grade_7	0.0	0
265174	265174	NH	school	3303930	267	Hudson	330393000180	21045	Dr. H. O. Smith Elementary School		Regular School	No	Elementary	PK	01	2020	grade_7	0.0	0
265389	265389	NH	school	3306060	473	Salem	330606000401	22895	Dr. L. F. Soule School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265306	265306	NH	school	3304980	371	Nashua	330498000486	21835	Dr. Norman W. Crisp School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265057	265057	NH	school	3302480	112	Contoocook Valley	330248000068	22230	Dublin Consolidated School		Regular School	No	Elementary	KG	04	2020	grade_7	0.0	0

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);