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

Data source: Big Local News · About: Big Local

496 rows where grade = "grade_1", 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
262090	262090	NH	school	3302490	113	Conway	330249000043	27010	A. Crosby Kennett Middle School		Regular School	No	Middle	07	08	2020	grade_1	0.0	0
262072	262072	NH	school	3302460	111	Concord	330246000054	20240	Abbot-Downing School		Regular School	No	Elementary	KG	05	2020	grade_1	50.0	50
262487	262487	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_1	0.0	0
262488	262488	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_1	0.0	0
262124	262124	NH	school	3302990	174	Fall Mountain Regional	330299000112	22960	Acworth Elementary School		Regular School	No	Elementary	01	04	2020	grade_1	5.0	5
262168	262168	NH	school	3303510	225	Hampton	330351000470	20795	Adeline C. Marston School		Regular School	No	Elementary	03	05	2020	grade_1	0.0	0
262029	262029	NH	school	3301380	9	Allenstown	330138000001	22580	Allenstown Elementary School		Regular School	No	Elementary	KG	04	2020	grade_1	28.0	28
262125	262125	NH	school	3302990	174	Fall Mountain Regional	330299000113	22965	Alstead Primary School		Regular School	No	Elementary	PK	04	2020	grade_1	13.0	13
262031	262031	NH	school	3301440	15	Alton	330144000003	22480	Alton Central School (Elem)		Regular School	No	Elementary	PK	08	2020	grade_1	38.0	38
262197	262197	NH	school	3303930	267	Hudson	330393000179	21050	Alvirne High School		Regular School	No	High	09	12	2020	grade_1	0.0	0
262032	262032	NH	school	3301470	17	Amherst	330147000007	21745	Amherst Middle School		Regular School	No	Middle	05	08	2020	grade_1	0.0	0
262325	262325	NH	school	3304980	371	Nashua	330498000310	21940	Amherst Street School		Regular School	No	Elementary	KG	05	2020	grade_1	51.0	51
262034	262034	NH	school	3301500	19	Andover	330150000008	22130	Andover Elementary School		Regular School	No	Elementary	KG	08	2020	grade_1	20.0	20
262079	262079	NH	school	3302480	112	Contoocook Valley	330248000065	22215	Antrim Elementary School		Regular School	No	Elementary	PK	04	2020	grade_1	20.0	20
262030	262030	NH	school	3301380	9	Allenstown	330138000002	22575	Armand R. Dupont School		Regular School	No	Middle	05	08	2020	grade_1	0.0	0
262035	262035	NH	school	3301560	23	Ashland	330156000010	20010	Ashland Elementary School		Regular School	No	Elementary	KG	08	2020	grade_1	22.0	22
262448	262448	NH	school	3306720	534	Timberlane Regional	330672000434	22740	Atkinson Academy		Regular School	No	Elementary	PK	05	2020	grade_1	61.0	61
262036	262036	NH	school	3301590	29	Auburn	330159000011	20530	Auburn Village School		Regular School	No	Elementary	KG	08	2020	grade_1	86.0	86
262259	262259	NH	school	3304590	335	Manchester	330459000240	21545	Bakersville School		Regular School	No	Elementary	PK	05	2020	grade_1	53.0	53
262037	262037	NH	school	3301620	31	Barnstead	330162000012	22485	Barnstead Elementary School		Regular School	No	Elementary	PK	08	2020	grade_1	51.0	51
262038	262038	NH	school	3301650	33	Barrington	330165000013	22045	Barrington Elementary School		Regular School	No	Elementary	01	04	2020	grade_1	109.0	109
262039	262039	NH	school	3301650	33	Barrington	330165000014	22030	Barrington Middle School		Regular School	No	Middle	05	08	2020	grade_1	0.0	0
262148	262148	NH	school	3303240	199	Goffstown	330324000138	20695	Bartlett Elementary School		Regular School	No	Elementary	01	04	2020	grade_1	49.0	49
262042	262042	NH	school	3301710	39	Bath	330171000016	20860	Bath Village School		Regular School	No	Elementary	KG	06	2020	grade_1	11.0	11
262073	262073	NH	school	3302460	111	Concord	330246000496	26490	Beaver Meadow School		Regular School	No	Elementary	PK	05	2020	grade_1	45.0	45
262043	262043	NH	school	3301740	41	Bedford	330174000680	28555	Bedford High School		Regular School	No	High	09	12	2020	grade_1	0.0	0
262260	262260	NH	school	3304590	335	Manchester	330459000241	21600	Beech Street School		Regular School	No	Elementary	KG	05	2020	grade_1	88.0	88
262427	262427	NH	school	3306180	486	Shaker Regional	330618000490	22135	Belmont Elementary School		Regular School	No	Elementary	PK	04	2020	grade_1	77.0	77
262428	262428	NH	school	3306180	486	Shaker Regional	330618000411	22145	Belmont High School		Regular School	No	High	09	12	2020	grade_1	0.0	0
262429	262429	NH	school	3306180	486	Shaker Regional	330618000413	22150	Belmont Middle School		Regular School	No	Middle	05	08	2020	grade_1	0.0	0
262049	262049	NH	school	3301860	51	Berlin	330186000163	27035	Berlin Elementary School		Regular School	No	Elementary	PK	05	2020	grade_1	77.0	77
262050	262050	NH	school	3301860	51	Berlin	330186000024	20045	Berlin Middle School		Regular School	No	Middle	06	08	2020	grade_1	0.0	0
262051	262051	NH	school	3301860	51	Berlin	330186000027	20050	Berlin Senior High School		Regular School	No	High	09	12	2020	grade_1	0.0	0
262172	262172	NH	school	3303600	233	Hanover	330360000155	20830	Bernice A. Ray School		Regular School	No	Elementary	KG	05	2020	grade_1	79.0	79
262052	262052	NH	school	3301890	53	Bethlehem	330189000028	21400	Bethlehem Elementary School		Regular School	No	Elementary	PK	06	2020	grade_1	14.0	14
262326	262326	NH	school	3304980	371	Nashua	330498000312	21865	Bicentennial Elementary School		Regular School	No	Elementary	PK	05	2020	grade_1	84.0	84
262327	262327	NH	school	3304980	371	Nashua	330498000313	21895	Birch Hill Elementary School		Regular School	No	Elementary	PK	05	2020	grade_1	69.0	69
262064	262064	NH	school	3302340	101	Claremont	330234000038	20145	Bluff School		Regular School	No	Elementary	KG	05	2020	grade_1	25.0	25
262297	262297	NH	school	3304760	352	Merrimack Valley	330476000281	22155	Boscawen Elementary School		Regular School	No	Elementary	PK	05	2020	grade_1	28.0	28
262053	262053	NH	school	3301950	57	Bow	330195000480	20680	Bow Elementary School		Regular School	No	Elementary	PK	04	2020	grade_1	95.0	95
262054	262054	NH	school	3301950	57	Bow	330195000563	27375	Bow High School		Regular School	No	High	09	12	2020	grade_1	0.0	0
262055	262055	NH	school	3301950	57	Bow	330195000029	20675	Bow Memorial School		Regular School	No	Middle	05	08	2020	grade_1	0.0	0
262283	262283	NH	school	3304670	342	Mascenic Regional	330467000515	26685	Boynton Middle School		Regular School	No	Middle	05	08	2020	grade_1	0.0	0
262348	262348	NH	school	3305220	388	Newfound Area	330522000590	27685	Bridgewater-Hebron Village School		Regular School	No	Elementary	PK	05	2020	grade_1	23.0	23
262349	262349	NH	school	3305220	388	Newfound Area	330522000332	20090	Bristol Elementary School		Regular School	No	Elementary	KG	05	2020	grade_1	31.0	31
262328	262328	NH	school	3304980	371	Nashua	330498000314	21925	Broad Street Elementary School		Regular School	No	Elementary	PK	05	2020	grade_1	42.0	42
262074	262074	NH	school	3302460	111	Concord	330246000053	20260	Broken Ground School		Regular School	No	Elementary	03	05	2020	grade_1	0.0	0
262398	262398	NH	school	3305940	461	Rochester	330594000694	22675	Bud Carlson Academy		Regular School	No	High	09	12	2020	grade_1	0.0	0
262494	262494	NH	school	3300041	723	CSI Charter School	330004100677	28575	CSI Charter School	Public Charter Schools	Regular School	Yes	High	11	12	2020	grade_1	0.0	0
262245	262245	NH	school	3304350	315	Litchfield	330435000674	27715	Campbell High School		Regular School	No	High	09	12	2020	grade_1	0.0	0
262059	262059	NH	school	3302100	75	Campton	330210000032	22335	Campton Elementary School		Regular School	No	Elementary	PK	08	2020	grade_1	31.0	31
262286	262286	NH	school	3304680	343	Mascoma Valley Regional	330468000273	21315	Canaan Elementary School		Regular School	No	Elementary	PK	04	2020	grade_1	32.0	32
262430	262430	NH	school	3306180	486	Shaker Regional	330618000412	22165	Canterbury Elementary School		Regular School	No	Elementary	KG	05	2020	grade_1	19.0	19
262489	262489	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_1	0.0	0
262490	262490	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_1	0.0	0
262057	262057	NH	school	3302070	71	Brookline	330207000670	27765	Captain Samuel Douglass Academy		Regular School	No	Middle	04	06	2020	grade_1	0.0	0
262156	262156	NH	school	3303330	208	Governor Wentworth Regional	330333000144	22430	Carpenter Elementary School		Regular School	No	Elementary	KG	03	2020	grade_1	70.0	70
262460	262460	NH	school	3306930	555	Weare	330693000025	26810	Center Woods School		Regular School	No	Elementary	PK	05	2020	grade_1	99.0	99
262399	262399	NH	school	3305940	461	Rochester	330594000388	22695	Chamberlain Street School		Regular School	No	Elementary	KG	05	2020	grade_1	66.0	66
262126	262126	NH	school	3302990	174	Fall Mountain Regional	330299000114	22975	Charlestown Middle School		Regular School	No	Middle	06	08	2020	grade_1	0.0	0
262127	262127	NH	school	3302990	174	Fall Mountain Regional	330299000115	22985	Charlestown Primary School		Regular School	No	Elementary	PK	05	2020	grade_1	33.0	33
262329	262329	NH	school	3304980	371	Nashua	330498000315	21930	Charlotte Ave Elementary School		Regular School	No	Elementary	KG	05	2020	grade_1	83.0	83
262061	262061	NH	school	3302250	93	Chester	330225000035	20500	Chester Academy		Regular School	No	Elementary	PK	08	2020	grade_1	50.0	50
262062	262062	NH	school	3302280	95	Chesterfield	330228000036	21140	Chesterfield Central School		Regular School	No	Elementary	KG	08	2020	grade_1	22.0	22
262063	262063	NH	school	3302310	99	Chichester	330231000037	22590	Chichester Central School		Regular School	No	Elementary	KG	08	2020	grade_1	29.0	29
262075	262075	NH	school	3302460	111	Concord	330246000060	20305	Christa McAuliffe School		Regular School	No	Elementary	KG	05	2020	grade_1	69.0	69
262065	262065	NH	school	3302340	101	Claremont	330234000039	20115	Claremont Middle School		Regular School	No	Middle	06	08	2020	grade_1	0.0	0
262066	262066	NH	school	3302340	101	Claremont	330234000724	29184	Claremont Preschool Center		Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
262033	262033	NH	school	3301470	17	Amherst	330147000006	21750	Clark-Wilkins School		Regular School	No	Elementary	PK	04	2020	grade_1	142.0	142
262491	262491	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_1	0.0	0
262482	262482	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_1	0.0	0
262070	262070	NH	school	3302400	105	Colebrook	330240000050	20195	Colebrook Academy and Elementary School (E)		Regular School	No	Elementary	PK	08	2020	grade_1	29.0	29
262071	262071	NH	school	3302400	105	Colebrook	330240000049	20185	Colebrook Academy and Elementary School (H)		Regular School	No	High	09	12	2020	grade_1	0.0	0
262492	262492	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_1	12.0	12
262493	262493	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_1	0.0	0
262207	262207	NH	school	3304030	274	Jaffrey-Rindge Cooperative	330403000188	22265	Conant High School		Regular School	No	High	09	12	2020	grade_1	0.0	0
262076	262076	NH	school	3302460	111	Concord	330246000055	20285	Concord High School		Regular School	No	High	09	13	2020	grade_1	0.0	0
262080	262080	NH	school	3302480	112	Contoocook Valley	330248000067	22290	Conval Regional High School		Regular School	No	High	09	12	2020	grade_1	0.0	0
262091	262091	NH	school	3302490	113	Conway	330249000077	20340	Conway Elementary School		Regular School	No	Elementary	KG	06	2020	grade_1	29.0	29
262120	262120	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	grade_1	0.0	0
262095	262095	NH	school	3302520	115	Cornish	330252000080	20175	Cornish Elementary School		Regular School	No	Elementary	PK	08	2020	grade_1	12.0	12
262157	262157	NH	school	3303330	208	Governor Wentworth Regional	330333000565	27515	Crescent Lake School		Regular School	No	Middle	04	06	2020	grade_1	0.0	0
262096	262096	NH	school	3302550	117	Croydon	330255000081	21960	Croydon Village School		Regular School	No	Elementary	KG	04	2020	grade_1	8.0	8
262313	262313	NH	school	3304890	363	Monadnock Regional	330489000298	21715	Cutler Elementary School		Regular School	No	Elementary	03	06	2020	grade_1	0.0	0
262248	262248	NH	school	3304380	317	Littleton	330438000231	21440	Daisy Bronson Junior High School		Regular School	No	Middle	07	08	2020	grade_1	0.0	0
262350	262350	NH	school	3305220	388	Newfound Area	330522000334	20095	Danbury Elementary School		Regular School	No	Elementary	KG	05	2020	grade_1	13.0	13
262421	262421	NH	school	3306080	476	Sanborn Regional	330608000478	20625	Daniel J. Bakie School		Regular School	No	Elementary	PK	05	2020	grade_1	52.0	52
262449	262449	NH	school	3306720	534	Timberlane Regional	330672000435	22745	Danville Elementary School		Regular School	No	Elementary	PK	05	2020	grade_1	32.0	32
262190	262190	NH	school	3303870	261	Hooksett	330387000618	28050	David R. Cawley Middle School		Regular School	No	Middle	06	08	2020	grade_1	0.0	0
262097	262097	NH	school	3302580	127	Deerfield	330258000082	22595	Deerfield Community School		Regular School	No	Elementary	PK	08	2020	grade_1	62.0	62
262098	262098	NH	school	3302610	131	Derry Cooperative	330261000716	29156	Derry Early Education Program		Regular School	No	Elementary	PK	KG	2020	grade_1	0.0	0
262099	262099	NH	school	3302610	131	Derry Cooperative	330261000083	20380	Derry Village School		Regular School	No	Elementary	KG	05	2020	grade_1	63.0	63
262067	262067	NH	school	3302340	101	Claremont	330234000488	20165	Disnard Elementary School		Regular School	No	Elementary	KG	05	2020	grade_1	52.0	52
262106	262106	NH	school	3302640	141	Dover	330264000089	20435	Dover Middle School		Regular School	No	Middle	05	08	2020	grade_1	0.0	0
262107	262107	NH	school	3302640	141	Dover	330264000088	20455	Dover Senior High School		Regular School	No	High	09	12	2020	grade_1	0.0	0
262314	262314	NH	school	3304890	363	Monadnock Regional	330489000299	21665	Dr. George S. Emerson Elementary School		Regular School	No	Elementary	PK	06	2020	grade_1	27.0	27
262198	262198	NH	school	3303930	267	Hudson	330393000180	21045	Dr. H. O. Smith Elementary School		Regular School	No	Elementary	PK	01	2020	grade_1	192.0	192
262413	262413	NH	school	3306060	473	Salem	330606000401	22895	Dr. L. F. Soule School		Regular School	No	Elementary	KG	05	2020	grade_1	37.0	37
262330	262330	NH	school	3304980	371	Nashua	330498000486	21835	Dr. Norman W. Crisp School		Regular School	No	Elementary	KG	05	2020	grade_1	67.0	67
262081	262081	NH	school	3302480	112	Contoocook Valley	330248000068	22230	Dublin Consolidated School		Regular School	No	Elementary	KG	04	2020	grade_1	12.0	12

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]);