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 (school_state_id > :p3 or (school_state_id = :p3 and rowid > :p2)) order by school_state_id, rowid 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
265037	NH	school	3302250	93	Chester	330225000035	20500	Chester Academy		Regular School	No	Elementary	PK	08	2020	grade_7	69.0	69
349662	NH	school	3302250	93	Chester	330225000035	20500	Chester Academy	Public School	Regular School	No	Elementary	PK	08	2021	grade_7	48	48
265092	NH	school	3302880	165	Epping	330288000103	20515	Epping High School		Regular School	No	High	09	12	2020	grade_7	0.0	0
350512	NH	school	3302880	165	Epping	330288000103	20515	Epping High School	Public School	Regular School	No	High	09	12	2021	grade_7	0	0
265119	NH	school	3303150	189	Fremont	330315000132	20525	Ellis School		Regular School	No	Elementary	PK	08	2020	grade_7	41.0	41
350427	NH	school	3303150	189	Fremont	330315000132	20525	Ellis School	Public School	Regular School	No	Elementary	PK	08	2021	grade_7	38	38
265012	NH	school	3301590	29	Auburn	330159000011	20530	Auburn Village School		Regular School	No	Elementary	KG	08	2020	grade_7	72.0	72
348931	NH	school	3301590	29	Auburn	330159000011	20530	Auburn Village School	Public School	Regular School	No	Elementary	KG	08	2021	grade_7	60	60
265036	NH	school	3302130	79	Candia	330213000033	20535	Henry W. Moore School		Regular School	No	Elementary	KG	08	2020	grade_7	36.0	36
351532	NH	school	3302130	79	Candia	330213000033	20535	Henry W. Moore School	Public School	Regular School	No	Elementary	KG	08	2021	grade_7	24	24
265168	NH	school	3303870	261	Hooksett	330387000175	20540	Hooksett Memorial School		Regular School	No	Elementary	03	05	2020	grade_7	0.0	0
351855	NH	school	3303870	261	Hooksett	330387000175	20540	Hooksett Memorial School	Public School	Regular School	No	Elementary	03	05	2021	grade_7	0	0
265167	NH	school	3303870	261	Hooksett	330387000173	20550	Fred C. Underhill School		Regular School	No	Elementary	PK	02	2020	grade_7	0.0	0
350801	NH	school	3303870	261	Hooksett	330387000173	20550	Fred C. Underhill School	Public School	Regular School	No	Elementary	PK	02	2021	grade_7	0	0
265032	NH	school	3302010	63	Brentwood	330201000030	20555	Swasey Central School		Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
356156	NH	school	3302010	63	Brentwood	330201000030	20555	Swasey Central School	Public School	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
265090	NH	school	3302790	153	East Kingston	330279000100	20565	East Kingston Elementary School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
350359	NH	school	3302790	153	East Kingston	330279000100	20565	East Kingston Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	grade_7	0	0
265099	NH	school	3302970	173	Exeter	330297000109	20575	Main Street School		Regular School	No	Elementary	PK	02	2020	grade_7	0.0	0
353028	NH	school	3302970	173	Exeter	330297000109	20575	Main Street School	Public School	Regular School	No	Elementary	PK	02	2021	grade_7	0	0
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
349951	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_7	335	335
265098	NH	school	3302970	173	Exeter	330297000108	20595	Lincoln Street Elementary School		Regular School	No	Elementary	03	05	2020	grade_7	0.0	0
352790	NH	school	3302970	173	Exeter	330297000108	20595	Lincoln Street Elementary School	Public School	Regular School	No	Elementary	03	05	2021	grade_7	0	0
265097	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	grade_7	0.0	0
350597	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	grade_7	0	0
265202	NH	school	3304080	281	Kensington	330408000208	20605	Kensington Elementary School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
352433	NH	school	3304080	281	Kensington	330408000208	20605	Kensington Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	grade_7	0	0
265323	NH	school	3305190	387	Newfields	330519000331	20610	Newfields Elementary School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
354167	NH	school	3305190	387	Newfields	330519000331	20610	Newfields Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	grade_7	0	0
265418	NH	school	3306480	511	Stratham	330648000429	20615	Stratham Memorial School		Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
356020	NH	school	3306480	511	Stratham	330648000429	20615	Stratham Memorial School	Public School	Regular School	No	Elementary	PK	05	2021	grade_7	0	0
265399	NH	school	3306080	476	Sanborn Regional	330608000479	20620	Sanborn Regional High School		Regular School	No	High	09	12	2020	grade_7	0.0	0
355527	NH	school	3306080	476	Sanborn Regional	330608000479	20620	Sanborn Regional High School	Public School	Regular School	No	High	09	12	2021	grade_7	0	0
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
350070	NH	school	3306080	476	Sanborn Regional	330608000478	20625	Daniel J. Bakie School	Public School	Regular School	No	Elementary	PK	03	2021	grade_7	0	0
265400	NH	school	3306080	476	Sanborn Regional	330608000476	20630	Sanborn Regional Middle School		Regular School	No	Middle	06	08	2020	grade_7	97.0	97
355544	NH	school	3306080	476	Sanborn Regional	330608000476	20630	Sanborn Regional Middle School	Public School	Regular School	No	Middle	07	08	2021	grade_7	99	99
265398	NH	school	3306080	476	Sanborn Regional	330608000477	20635	Memorial School		Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
353470	NH	school	3306080	476	Sanborn Regional	330608000477	20635	Memorial School	Public School	Regular School	No	Middle	04	06	2021	grade_7	0	0
265117	NH	school	3303090	185	Franklin	330309000130	20650	Paul A. Smith School		Regular School	No	Elementary	PK	03	2020	grade_7	0.0	0
354660	NH	school	3303090	185	Franklin	330309000130	20650	Paul A. Smith School	Public School	Regular School	No	Elementary	PK	03	2021	grade_7	0	0
265115	NH	school	3303090	185	Franklin	330309000128	20660	Franklin High School		Regular School	No	High	09	12	2020	grade_7	0.0	0
350767	NH	school	3303090	185	Franklin	330309000128	20660	Franklin High School	Public School	Regular School	No	High	09	13	2021	grade_7	0	0
265154	NH	school	3303720	247	Hill	330372000164	20670	Jennie D. Blake School		Regular School	No	Elementary	KG	06	2020	grade_7	0.0	0
352178	NH	school	3303720	247	Hill	330372000164	20670	Jennie D. Blake School	Public School	Regular School	No	Elementary	KG	06	2021	grade_7	0	0
265031	NH	school	3301950	57	Bow	330195000029	20675	Bow Memorial School		Regular School	No	Middle	05	08	2020	grade_7	143.0	143
349339	NH	school	3301950	57	Bow	330195000029	20675	Bow Memorial School	Public School	Regular School	No	Middle	05	08	2021	grade_7	153	153
265029	NH	school	3301950	57	Bow	330195000480	20680	Bow Elementary School		Regular School	No	Elementary	PK	04	2020	grade_7	0.0	0
349305	NH	school	3301950	57	Bow	330195000480	20680	Bow Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	grade_7	0	0
265089	NH	school	3302760	149	Dunbarton	330276000098	20685	Dunbarton Elementary School		Regular School	No	Elementary	KG	06	2020	grade_7	0.0	0
350308	NH	school	3302760	149	Dunbarton	330276000098	20685	Dunbarton Elementary School	Public School	Regular School	No	Elementary	KG	06	2021	grade_7	0	0
265127	NH	school	3303240	199	Goffstown	330324000139	20690	Maple Avenue School		Regular School	No	Elementary	01	04	2020	grade_7	0.0	0
353181	NH	school	3303240	199	Goffstown	330324000139	20690	Maple Avenue School	Public School	Regular School	No	Elementary	01	04	2021	grade_7	0	0
265124	NH	school	3303240	199	Goffstown	330324000138	20695	Bartlett Elementary School		Regular School	No	Elementary	01	04	2020	grade_7	0.0	0
349016	NH	school	3303240	199	Goffstown	330324000138	20695	Bartlett Elementary School	Public School	Regular School	No	Elementary	01	04	2021	grade_7	0	0
265126	NH	school	3303240	199	Goffstown	330324000137	20700	Goffstown High School		Regular School	No	High	09	12	2020	grade_7	0.0	0
351005	NH	school	3303240	199	Goffstown	330324000137	20700	Goffstown High School	Public School	Regular School	No	High	09	12	2021	grade_7	0	0
265321	NH	school	3305040	377	New Boston	330504000329	20715	New Boston Central School		Regular School	No	Elementary	PK	06	2020	grade_7	0.0	0
354082	NH	school	3305040	377	New Boston	330504000329	20715	New Boston Central School	Public School	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
265437	NH	school	3306930	555	Weare	330693000023	20720	Weare Middle School		Regular School	No	Middle	06	08	2020	grade_7	98.0	98
356564	NH	school	3306930	555	Weare	330693000023	20720	Weare Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_7	108	108
265095	NH	school	3302940	171	Errol	330294000105	20735	Errol Consolidated Elementary School		Regular School	No	Middle	03	08	2020	grade_7	3.0	3
350580	NH	school	3302940	171	Errol	330294000105	20735	Errol Consolidated Elementary School	Public School	Regular School	No	Elementary	KG	08	2021	grade_7	1	1
265129	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500141	20745	Edward Fenn School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
350393	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500141	20745	Edward Fenn School	Public School	Regular School	No	Elementary	KG	05	2021	grade_7	0	0
265130	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500142	20750	Gorham High School		Regular School	No	High	09	12	2020	grade_7	0.0	0
351056	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500142	20750	Gorham High School	Public School	Regular School	No	High	09	12	2021	grade_7	0	0
265281	NH	school	3304800	355	Milan	330480000289	20760	Milan Village Elementary School		Regular School	No	Elementary	PK	06	2020	grade_7	0.0	0
353606	NH	school	3304800	355	Milan	330480000289	20760	Milan Village Elementary School	Public School	Regular School	No	Elementary	PK	06	2021	grade_7	0	0
265146	NH	school	3303510	225	Hampton	330351000469	20770	Hampton Centre School		Regular School	No	Elementary	PK	02	2020	grade_7	0.0	0
351396	NH	school	3303510	225	Hampton	330351000469	20770	Hampton Centre School	Public School	Regular School	No	Elementary	PK	02	2021	grade_7	0	0
265452	NH	school	3307230	581	Winnacunnet Cooperative	330723000463	20780	Winnacunnet High School		Regular School	No	High	09	13	2020	grade_7	0.0	0
356921	NH	school	3307230	581	Winnacunnet Cooperative	330723000463	20780	Winnacunnet High School	Public School	Regular School	No	High	09	13	2021	grade_7	0	0
265145	NH	school	3303510	225	Hampton	330351000471	20790	Hampton Academy		Regular School	No	Middle	06	08	2020	grade_7	129.0	129
351379	NH	school	3303510	225	Hampton	330351000471	20790	Hampton Academy	Public School	Regular School	No	Middle	06	08	2021	grade_7	112	112
265144	NH	school	3303510	225	Hampton	330351000470	20795	Adeline C. Marston School		Regular School	No	Elementary	03	05	2020	grade_7	0.0	0
348727	NH	school	3303510	225	Hampton	330351000470	20795	Adeline C. Marston School	Public School	Regular School	No	Elementary	03	05	2021	grade_7	0	0
265147	NH	school	3303540	227	Hampton Falls	330354000154	20800	Lincoln Akerman School		Regular School	No	Elementary	KG	08	2020	grade_7	30.0	30
352773	NH	school	3303540	227	Hampton Falls	330354000154	20800	Lincoln Akerman School	Public School	Regular School	No	Elementary	KG	08	2021	grade_7	13	13
265337	NH	school	3305370	405	North Hampton	330537000345	20805	North Hampton School		Regular School	No	Elementary	PK	08	2020	grade_7	44.0	44
354354	NH	school	3305370	405	North Hampton	330537000345	20805	North Hampton School	Public School	Regular School	No	Elementary	PK	08	2021	grade_7	25	25
265401	NH	school	3306150	485	Seabrook	330615000410	20810	Seabrook Elementary School		Regular School	No	Elementary	PK	04	2020	grade_7	0.0	0
355663	NH	school	3306150	485	Seabrook	330615000410	20810	Seabrook Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	grade_7	0	0
265412	NH	school	3306270	495	South Hampton	330627000422	20815	South Hampton Barnard School		Regular School	No	Elementary	KG	08	2020	grade_7	8.0	8
355799	NH	school	3306270	495	South Hampton	330627000422	20815	South Hampton Barnard School	Public School	Regular School	No	Elementary	KG	08	2021	grade_7	6	6
265088	NH	school	3302670	142	Dresden	330267000096	20820	Hanover High School		Regular School	No	High	09	12	2020	grade_7	0.0	0
351430	NH	school	3302670	142	Dresden	330267000096	20820	Hanover High School	Public School	Regular School	No	High	09	12	2021	grade_7	0	0
265087	NH	school	3302670	142	Dresden	330267000095	20825	Frances C. Richmond School		Regular School	No	Middle	06	08	2020	grade_7	143.0	143
350716	NH	school	3302670	142	Dresden	330267000095	20825	Frances C. Richmond School	Public School	Regular School	No	Middle	06	08	2021	grade_7	131	131
265148	NH	school	3303600	233	Hanover	330360000155	20830	Bernice A. Ray School		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
349203	NH	school	3303600	233	Hanover	330360000155	20830	Bernice A. Ray School	Public School	Regular School	No	Elementary	KG	05	2021	grade_7	0	0
265233	NH	school	3304500	327	Lyme	330450000236	20835	Lyme Elementary School		Regular School	No	Elementary	KG	08	2020	grade_7	27.0	27
352960	NH	school	3304500	327	Lyme	330450000236	20835	Lyme Elementary School	Public School	Regular School	No	Elementary	KG	08	2021	grade_7	21	21
265018	NH	school	3301710	39	Bath	330171000016	20860	Bath Village School		Regular School	No	Elementary	KG	06	2020	grade_7	0.0	0
349033	NH	school	3301710	39	Bath	330171000016	20860	Bath Village School	Public School	Regular School	No	Elementary	KG	06	2021	grade_7	0	0
265215	NH	school	3304260	305	Lincoln-Woodstock Cooperative	330426000493	20880	Lin-Wood Public School (Elem)		Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
352722	NH	school	3304260	305	Lincoln-Woodstock Cooperative	330426000493	20880	Lin-Wood Public School (Elem)	Public School	Regular School	No	Elementary	KG	05	2021	grade_7	0	0
265296	NH	school	3304920	365	Monroe	330492000307	20885	Monroe Consolidated School		Regular School	No	Elementary	PK	08	2020	grade_7	8.0	8
353793	NH	school	3304920	365	Monroe	330492000307	20885	Monroe Consolidated School	Public School	Regular School	No	Elementary	PK	08	2021	grade_7	6	6
265355	NH	school	3305670	435	Piermont	330567000362	20895	Piermont Village School		Regular School	No	Elementary	PK	08	2020	grade_7	9.0	9