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 (hispanic_int > :p3 or (hispanic_int = :p3 and rowid > :p2)) order by hispanic_int, 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	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	total	total_int
265105	NH	school	3302990	174	Fall Mountain Regional	330299000259	27395	Fall Mountain Regional -Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
265106	NH	school	3302990	174	Fall Mountain Regional	330299000117	22980	N. Charlestown Community School	Regular School	No	Elementary	01	05	2020	grade_7	0.0	0
265107	NH	school	3302990	174	Fall Mountain Regional	330299000118	23005	North Walpole School	Regular School	No	Elementary	02	04	2020	grade_7	0.0	0
265108	NH	school	3302990	174	Fall Mountain Regional	330299000119	22995	Sarah Porter School	Regular School	No	Elementary	01	04	2020	grade_7	0.0	0
265109	NH	school	3302990	174	Fall Mountain Regional	330299000120	22970	Vilas Elementary School	Regular School	No	Middle	05	08	2020	grade_7	24.0	24
265110	NH	school	3302990	174	Fall Mountain Regional	330299000122	23015	Walpole Elementary School	Regular School	No	Middle	05	08	2020	grade_7	30.0	30
265111	NH	school	3302990	174	Fall Mountain Regional	330299000121	23010	Walpole Primary School	Regular School	No	Elementary	PK	01	2020	grade_7	0.0	0
265112	NH	school	3303000	175	Farmington	330300000123	22050	Farmington Senior High School	Regular School	No	High	09	12	2020	grade_7	0.0	0
265113	NH	school	3303000	175	Farmington	330300000124	22055	Henry Wilson Memorial School	Regular School	No	Middle	04	08	2020	grade_7	64.0	64
265114	NH	school	3303000	175	Farmington	330300000597	27980	Valley View Community School	Regular School	No	Elementary	PK	03	2020	grade_7	0.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
265116	NH	school	3303090	185	Franklin	330309000511	26755	Franklin Middle School	Regular School	No	Middle	04	08	2020	grade_7	72.0	72
265117	NH	school	3303090	185	Franklin	330309000130	20650	Paul A. Smith School	Regular School	No	Elementary	PK	03	2020	grade_7	0.0	0
265118	NH	school	3303120	187	Freedom	330312000131	20350	Freedom Elementary School	Regular School	No	Elementary	PK	06	2020	grade_7	0.0	0
265119	NH	school	3303150	189	Fremont	330315000132	20525	Ellis School	Regular School	No	Elementary	PK	08	2020	grade_7	41.0	41
265120	NH	school	3303180	191	Gilford	330318000133	21245	Gilford Elementary School	Regular School	No	Elementary	KG	04	2020	grade_7	0.0	0
265121	NH	school	3303180	191	Gilford	330318000135	21240	Gilford High School	Regular School	No	High	09	12	2020	grade_7	0.0	0
265122	NH	school	3303180	191	Gilford	330318000044	26995	Gilford Middle School	Regular School	No	Middle	05	08	2020	grade_7	82.0	82
265123	NH	school	3303210	195	Gilmanton	330321000136	21250	Gilmanton Elementary School	Regular School	No	Elementary	KG	08	2020	grade_7	53.0	53
265124	NH	school	3303240	199	Goffstown	330324000138	20695	Bartlett Elementary School	Regular School	No	Elementary	01	04	2020	grade_7	0.0	0
265125	NH	school	3303240	199	Goffstown	330324000620	28525	Glen Lake School	Regular School	No	Elementary	PK	KG	2020	grade_7	0.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
265127	NH	school	3303240	199	Goffstown	330324000139	20690	Maple Avenue School	Regular School	No	Elementary	01	04	2020	grade_7	0.0	0
265128	NH	school	3303240	199	Goffstown	330324000536	26820	Mountain View Middle School	Regular School	No	Middle	05	08	2020	grade_7	251.0	251
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
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
265131	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500047	27005	Gorham Middle School	Regular School	No	Middle	06	08	2020	grade_7	39.0	39
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
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
265134	NH	school	3303330	208	Governor Wentworth Regional	330333000145	22395	Effingham Elementary School	Regular School	No	Elementary	KG	06	2020	grade_7	0.0	0
265135	NH	school	3303330	208	Governor Wentworth Regional	330333000146	22425	Kingswood Regional High School	Regular School	No	High	09	12	2020	grade_7	0.0	0
265136	NH	school	3303330	208	Governor Wentworth Regional	330333000512	22440	Kingswood Regional Middle School	Regular School	No	Middle	07	08	2020	grade_7	196.0	196
265137	NH	school	3303330	208	Governor Wentworth Regional	330333000148	22400	New Durham Elementary School	Regular School	No	Elementary	PK	06	2020	grade_7	0.0	0
265138	NH	school	3303330	208	Governor Wentworth Regional	330333000149	22405	Ossipee Central School	Regular School	No	Elementary	PK	06	2020	grade_7	0.0	0
265139	NH	school	3303330	208	Governor Wentworth Regional	330333000150	22410	Tuftonboro Central School	Regular School	No	Elementary	KG	06	2020	grade_7	0.0	0
265140	NH	school	3303360	211	Grantham	330336000151	21330	Grantham Village School	Regular School	No	Elementary	PK	06	2020	grade_7	0.0	0
265141	NH	school	3303420	215	Greenland	330342000152	22450	Greenland Central School	Regular School	No	Elementary	KG	08	2020	grade_7	36.0	36
265142	NH	school	3303480	223	Hampstead	330348000153	22755	Hampstead Central School	Regular School	No	Elementary	PK	04	2020	grade_7	0.0	0
265143	NH	school	3303480	223	Hampstead	330348000468	22750	Hampstead Middle School	Regular School	No	Middle	05	08	2020	grade_7	85.0	85
265144	NH	school	3303510	225	Hampton	330351000470	20795	Adeline C. Marston School	Regular School	No	Elementary	03	05	2020	grade_7	0.0	0
265145	NH	school	3303510	225	Hampton	330351000471	20790	Hampton Academy	Regular School	No	Middle	06	08	2020	grade_7	129.0	129
265146	NH	school	3303510	225	Hampton	330351000469	20770	Hampton Centre School	Regular School	No	Elementary	PK	02	2020	grade_7	0.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
265148	NH	school	3303600	233	Hanover	330360000155	20830	Bernice A. Ray School	Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265149	NH	school	3303630	235	Harrisville	330363000156	21155	Wells Memorial School	Regular School	No	Elementary	KG	06	2020	grade_7	0.0	0
265150	NH	school	3303660	238	Haverhill Cooperative	330366000020	26875	Haverhill Cooperative Middle School	Regular School	No	Middle	04	08	2020	grade_7	60.0	60
265151	NH	school	3303660	238	Haverhill Cooperative	330366000159	20905	Woodsville Elementary School	Regular School	No	Elementary	PK	03	2020	grade_7	0.0	0
265152	NH	school	3303660	238	Haverhill Cooperative	330366000160	20910	Woodsville High School	Regular School	No	High	09	12	2020	grade_7	0.0	0
265153	NH	school	3303690	245	Henniker	330369000161	20935	Henniker Community School	Regular School	No	Elementary	PK	08	2020	grade_7	45.0	45
265154	NH	school	3303720	247	Hill	330372000164	20670	Jennie D. Blake School	Regular School	No	Elementary	KG	06	2020	grade_7	0.0	0
265155	NH	school	3303750	251	Hillsboro-Deering Cooperative	330375000165	20955	Hillsboro-Deering Elementary School	Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265156	NH	school	3303750	251	Hillsboro-Deering Cooperative	330375000166	20950	Hillsboro-Deering High School	Regular School	No	High	09	12	2020	grade_7	0.0	0
265157	NH	school	3303750	251	Hillsboro-Deering Cooperative	330375000481	20960	Hillsboro-Deering Middle School	Regular School	No	Middle	06	08	2020	grade_7	89.0	89
265158	NH	school	3303780	255	Hinsdale	330378000167	21680	Hinsdale Elementary School	Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265159	NH	school	3303780	255	Hinsdale	330378000168	21675	Hinsdale High School	Regular School	No	High	09	12	2020	grade_7	0.0	0
265160	NH	school	3303780	255	Hinsdale	330378000048	26985	Hinsdale Middle High School	Regular School	No	Middle	06	08	2020	grade_7	42.0	42
265161	NH	school	3303810	257	Holderness	330381000169	22345	Holderness Central School	Regular School	No	Elementary	KG	08	2020	grade_7	25.0	25
265162	NH	school	3303840	259	Hollis	330384000171	21815	Hollis Primary School	Regular School	No	Elementary	PK	03	2020	grade_7	0.0	0
265163	NH	school	3303840	259	Hollis	330384000566	27530	Hollis Upper Elementary School	Regular School	No	Middle	04	06	2020	grade_7	0.0	0
265164	NH	school	3303850	260	Hollis-Brookline Cooperative	330385000170	21810	Hollis-Brookline High School	Regular School	No	High	09	12	2020	grade_7	0.0	0
265165	NH	school	3303850	260	Hollis-Brookline Cooperative	330385000172	21805	Hollis-Brookline Middle School	Regular School	No	Middle	07	08	2020	grade_7	208.0	208
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
265167	NH	school	3303870	261	Hooksett	330387000173	20550	Fred C. Underhill School	Regular School	No	Elementary	PK	02	2020	grade_7	0.0	0
265168	NH	school	3303870	261	Hooksett	330387000175	20540	Hooksett Memorial School	Regular School	No	Elementary	03	05	2020	grade_7	0.0	0
265169	NH	school	3303900	263	Hopkinton	330390000176	20975	Harold Martin School	Regular School	No	Elementary	PK	03	2020	grade_7	0.0	0
265170	NH	school	3303900	263	Hopkinton	330390000177	20970	Hopkinton High School	Regular School	No	High	09	12	2020	grade_7	0.0	0
265171	NH	school	3303900	263	Hopkinton	330390000052	27000	Hopkinton Middle School	Regular School	No	Middle	07	08	2020	grade_7	75.0	75
265172	NH	school	3303900	263	Hopkinton	330390000178	20965	Maple Street Elementary School	Regular School	No	Middle	04	06	2020	grade_7	0.0	0
265173	NH	school	3303930	267	Hudson	330393000179	21050	Alvirne High School	Regular School	No	High	09	12	2020	grade_7	0.0	0
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
265175	NH	school	3303930	267	Hudson	330393000593	27900	Hills Garrison Elementary School	Regular School	No	Elementary	02	05	2020	grade_7	0.0	0
265176	NH	school	3303930	267	Hudson	330393000181	21060	Hudson Memorial School	Regular School	No	Middle	06	08	2020	grade_7	250.0	250
265177	NH	school	3303930	267	Hudson	330393000513	26765	Nottingham West Elementary School	Regular School	No	Elementary	02	05	2020	grade_7	0.0	0
265178	NH	school	3303960	269	Inter-Lakes Cooperative	330396000734	29200	Inter-Lakes Elementary School	Regular School	No	Elementary	PK	06	2020	grade_7	0.0	0
265179	NH	school	3303960	269	Inter-Lakes Cooperative	330396000185	20035	Inter-Lakes High School	Regular School	No	High	09	13	2020	grade_7	0.0	0
265180	NH	school	3303960	269	Inter-Lakes Cooperative	330396000731	29201	Inter-Lakes Middle School	Regular School	No	Middle	07	08	2020	grade_7	81.0	81
265181	NH	school	3303960	269	Inter-Lakes Cooperative	330396000183	20040	Sandwich Central School	Regular School	No	Elementary	KG	06	2020	grade_7	0.0	0
265182	NH	school	3303990	271	Jackson	330399000187	20355	Jackson Grammar School	Regular School	No	Elementary	KG	06	2020	grade_7	0.0	0
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
265184	NH	school	3304030	274	Jaffrey-Rindge Cooperative	330403000189	22275	Jaffrey Grade School	Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265185	NH	school	3304030	274	Jaffrey-Rindge Cooperative	330403000190	22280	Jaffrey-Rindge Middle School	Regular School	No	Middle	06	08	2020	grade_7	110.0	110
265186	NH	school	3304030	274	Jaffrey-Rindge Cooperative	330403000191	22320	Rindge Memorial School	Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265187	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Regular School	No	High	09	12	2020	grade_7	0.0	0
265188	NH	school	3304040	276	Kearsarge Regional	330404000687	26565	James House Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
265189	NH	school	3304040	276	Kearsarge Regional	330404000195	21980	Kearsarge Reg. Elem. School at New London	Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265190	NH	school	3304040	276	Kearsarge Regional	330404000192	26530	Kearsarge Reg. Elementary School - Bradford	Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265191	NH	school	3304040	276	Kearsarge Regional	330404000193	22015	Kearsarge Regional High School	Regular School	No	High	09	13	2020	grade_7	0.0	0
265192	NH	school	3304040	276	Kearsarge Regional	330404000503	26535	Kearsarge Regional Middle School	Regular School	No	Middle	06	08	2020	grade_7	126.0	126
265193	NH	school	3304040	276	Kearsarge Regional	330404000197	22020	Simonds Elementary School	Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265194	NH	school	3304040	276	Kearsarge Regional	330404000198	22010	Sutton Central Elementary School	Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265195	NH	school	3304050	279	Keene	330405000200	21190	Franklin Elementary School	Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265196	NH	school	3304050	279	Keene	330405000201	21165	Fuller Elementary School	Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265197	NH	school	3304050	279	Keene	330405000723	29180	Jonathan Daniels School	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
265198	NH	school	3304050	279	Keene	330405000202	21195	Keene High School	Regular School	No	High	09	12	2020	grade_7	0.0	0
265199	NH	school	3304050	279	Keene	330405000203	21185	Keene Middle School	Regular School	No	Middle	06	08	2020	grade_7	244.0	244
265200	NH	school	3304050	279	Keene	330405000206	21170	Symonds Elementary School	Regular School	No	Elementary	KG	05	2020	grade_7	0.0	0
265201	NH	school	3304050	279	Keene	330405000207	21200	Wheelock Elementary School	Regular School	No	Elementary	KG	05	2020	grade_7	0.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
265203	NH	school	3304140	285	Laconia	330414000209	21290	Elm Street School	Regular School	No	Elementary	PK	05	2020	grade_7	0.0	0
265204	NH	school	3304140	285	Laconia	330414000210	21255	Laconia High School	Regular School	No	High	09	13	2020	grade_7	0.0	0
265205	NH	school	3304140	285	Laconia	330414000211	21275	Laconia Middle School	Regular School	No	Middle	06	08	2020	grade_7	177.0	177