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 (ccd_school_lvl > :p3 or (ccd_school_lvl = :p3 and rowid > :p2)) order by ccd_school_lvl, 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	black	hispanic	native_american	asian	pacific_islander	multiracial	black_int	hispanic_int	native_american_int	asian_int	pacific_islander_int	multiracial_int
2965116	SD	school	4626970	53001	Gettysburg 53-1	462697000231	2	Gettysburg Elem	Regular School	No	1	KG	06	2015	grade_11	0.0	0.0	0.0			0.0	0	0	0			0
2965164	SD	school	4629340	25003	Grant-Deuel 25-3	462934000235	2	Grant-Deuel Elementary	Regular School	No	1	KG	06	2015	grade_11
2965212	SD	school	4629880	26004	Gregory 26-4	462988000238	2	Gregory Elementary School	Regular School	No	1	KG	06	2015	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
2965260	SD	school	4600045	6006	Groton Area	460004501156	2	Groton Area Elementary School	Regular School	No	1	PK	05	2015	grade_11		0.0	0.0	0.0				0	0	0
2965312	SD	school	4630490	27001	Haakon 27-1	463049000634	6	Deep Creek Rural School	Regular School	No	1	KG	08	2015	grade_11
2965313	SD	school	4630490	27001	Haakon 27-1	463049000647	8	Milesville Elem	Regular School	No	1	KG	08	2015	grade_11
2965314	SD	school	4630490	27001	Haakon 27-1	463049000255	2	Philip Elementary School	Regular School	No	1	KG	06	2015	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
2965388	SD	school	4630800	28003	Hamlin 28-3	463080001111	9	Hamlin Elementary	Regular School	No	1	PK	05	2015	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
2965443	SD	school	4602640	30001	Hanson 30-1	460264000876	6	Hanson Elementary School	Regular School	No	1	PK	05	2015	grade_11		0.0	0.0			0.0		0	0			0
2965446	SD	school	4602640	30001	Hanson 30-1	460264000015	4	Millbrook Colony Elementary	Regular School	No	1	KG	08	2015	grade_11
2965447	SD	school	4602640	30001	Hanson 30-1	460264000875	5	Oaklane Colony	Regular School	No	1	KG	08	2015	grade_11		0.0						0
2965536	SD	school	4609300	31001	Harding County 31-1	460930000087	2	Buffalo Elementary	Regular School	No	1	KG	05	2015	grade_11	0.0		0.0				0		0
2965537	SD	school	4609300	31001	Harding County 31-1	460930000701	8	Camp Crook Elementary	Regular School	No	1	KG	08	2015	grade_11
2965540	SD	school	4609300	31001	Harding County 31-1	460930000667	6	Ludlow Elementary	Regular School	No	1	KG	08	2015	grade_11
2965622	SD	school	4631350	41002	Harrisburg 41-2	463135001335	7	Endeavor Elem	Regular School	No	1	KG	05	2015	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
2965623	SD	school	4631350	41002	Harrisburg 41-2	463135001169	4	Explorer Elementary	Regular School	No	1	PK	05	2015	grade_11	0.0	0.0		0.0		0.0	0	0		0		0
2965624	SD	school	4631350	41002	Harrisburg 41-2	463135001318	6	Freedom Elementary	Regular School	No	1	PK	05	2015	grade_11	0.0	0.0		0.0		0.0	0	0		0		0
2965628	SD	school	4631350	41002	Harrisburg 41-2	463135001288	5	Journey Elementary	Regular School	No	1	PK	05	2015	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
2965629	SD	school	4631350	41002	Harrisburg 41-2	463135000263	2	Liberty Elementary	Regular School	No	1	PK	05	2015	grade_11	0.0	0.0	0.0			0.0	0	0	0			0
2965740	SD	school	4632340	14002	Henry 14-2	463234000275	2	Henry Elementary	Regular School	No	1	PK	05	2015	grade_11			0.0	0.0		0.0			0	0		0
2965788	SD	school	4632430	10001	Herreid 10-1	463243000277	2	Herreid Elem	Regular School	No	1	KG	05	2015	grade_11						0.0						0
2965836	SD	school	4680440	34002	Highmore-Harrold	468044000323	2	Highmore Elementary	Regular School	No	1	PK	06	2015	grade_11	0.0		0.0			0.0	0		0			0
2965884	SD	school	4633360	51002	Hill City 51-2	463336000279	2	Hill City Elementary	Regular School	No	1	PK	05	2015	grade_11	0.0	0.0	0.0			0.0	0	0	0			0
2965936	SD	school	4600046	56006	Hitchcock-Tulare	460004601166	4	Glendale Colony Elem	Regular School	No	1	KG	08	2015	grade_11
2965937	SD	school	4600046	56006	Hitchcock-Tulare	460004601167	5	Hitchcock-Tulare Elementary	Regular School	No	1	KG	06	2015	grade_11			0.0						0
2965940	SD	school	4600046	56006	Hitchcock-Tulare	460004601165	3	Spink Colony Elem	Regular School	No	1	KG	08	2015	grade_11
2966012	SD	school	4634480	23002	Hot Springs 23-2	463448000287	2	Hot Springs Elementary	Regular School	No	1	PK	05	2015	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
2966060	SD	school	4634600	53002	Hoven 53-2	463460000297	2	Hoven Elementary	Regular School	No	1	PK	06	2015	grade_11		0.0	0.0					0	0
2966110	SD	school	4600025	48003	Howard 48-3	460002500304	2	Howard Elem	Regular School	No	1	KG	06	2015	grade_11	0.0	0.0				0.0	0	0				0
2966113	SD	school	4600025	48003	Howard 48-3	460002501161	8	Shannon Colony	Regular School	No	1	KG	08	2015	grade_11
2966176	SD	school	4635480	2002	Huron 02-2	463548000312	13	Huron Colony Elementary	Regular School	No	1	KG	08	2015	grade_11
2966177	SD	school	4635480	2002	Huron 02-2	463548001322	9	Huron Elem	Regular School	No	1	KG	05	2015	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
2966180	SD	school	4635480	2002	Huron 02-2	463548000318	15	Riverside Colony Elementary	Regular School	No	1	KG	08	2015	grade_11
2966258	SD	school	4636060	22006	Ipswich Public 22-6	463606001085	5	Deerfield Colony Elem	Regular School	No	1	PK	08	2015	grade_11
2966259	SD	school	4636060	22006	Ipswich Public 22-6	463606000332	2	Ipswich Elem	Regular School	No	1	PK	05	2015	grade_11	0.0	0.0				0.0	0	0				0
2966262	SD	school	4636060	22006	Ipswich Public 22-6	463606001086	6	Pembrook Colony Elem	Regular School	No	1	PK	08	2015	grade_11
2966263	SD	school	4636060	22006	Ipswich Public 22-6	463606000334	3	Rosette Colony Elem	Regular School	No	1	PK	08	2015	grade_11
2966348	SD	school	4680439	13003	Irene-Wakonda 13-3	468043901255	2	Irene-Wakonda Elementary School	Regular School	No	1	PK	06	2015	grade_11	0.0	0.0	0.0			0.0	0	0	0			0
2966398	SD	school	4636150	2003	Iroquois 02-3	463615001144	4	Iroquois Elementary	Regular School	No	1	PK	05	2015	grade_11	0.0	0.0	0.0				0	0	0
2966460	SD	school	4619580	37003	Jones County 37-3	461958000358	2	Jones County Elem	Regular School	No	1	KG	04	2015	grade_11	0.0	0.0	0.0			0.0	0	0	0			0
2966512	SD	school	4680437	35002	Kadoka Area 35-2	468043701245	9	Interior Elementary	Regular School	No	1	KG	08	2015	grade_11			0.0			0.0			0			0
2966514	SD	school	4680437	35002	Kadoka Area 35-2	468043701249	2	Kadoka Elementary School	Regular School	No	1	PK	08	2015	grade_11			0.0						0
2966515	SD	school	4680437	35002	Kadoka Area 35-2	468043701256	10	Longvalley Elementary	Regular School	No	1	KG	08	2015	grade_11			0.0						0
2966516	SD	school	4680437	35002	Kadoka Area 35-2	468043701257	11	Midland Elementary	Regular School	No	1	KG	08	2015	grade_11
2966592	SD	school	4638220	7002	Kimball 07-2	463822000917	13	Grass Ranch Colony Elem	Regular School	No	1	KG	08	2015	grade_11
2966594	SD	school	4638220	7002	Kimball 07-2	463822000354	2	Kimball Elementary	Regular School	No	1	PK	04	2015	grade_11		0.0	0.0			0.0		0	0			0
2966668	SD	school	4639990	38003	Lake Preston 38-3	463999000367	2	Lake Preston Elementary	Regular School	No	1	PK	06	2015	grade_11		0.0				0.0		0				0
2966718	SD	school	4640860	45005	Langford Area	464086000369	2	Langford Area Elem	Regular School	No	1	PK	05	2015	grade_11		0.0	0.0			0.0		0	0			0
2966721	SD	school	4640860	45005	Langford Area	464086001097	4	Newport Colony Elem	Regular School	No	1	KG	08	2015	grade_11
2966783	SD	school	4641300	40001	Lead-Deadwood 40-1	464130000372	3	Lead-Deadwood Elementary	Regular School	No	1	KG	05	2015	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
2966844	SD	school	4641520	52004	Lemmon 52-4	464152000381	2	Lemmon Elem	Regular School	No	1	KG	06	2015	grade_11		0.0	0.0	0.0		0.0		0	0	0		0
2966894	SD	school	4641550	41004	Lennox 41-4	464155000386	2	Lennox Elementary	Regular School	No	1	KG	05	2015	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
2966897	SD	school	4641550	41004	Lennox 41-4	464155000389	5	Worthing Elem	Regular School	No	1	KG	05	2015	grade_11	0.0	0.0	0.0			0.0	0	0	0			0
2966962	SD	school	4641640	44002	Leola 44-2	464164001069	6	Grassland Colony Elem	Regular School	No	1	KG	08	2015	grade_11
2966963	SD	school	4641640	44002	Leola 44-2	464164000390	2	Leola Elem	Regular School	No	1	KG	06	2015	grade_11	0.0						0
2966966	SD	school	4641640	44002	Leola 44-2	464164000393	5	Long Lake Colony Elem	Regular School	No	1	KG	08	2015	grade_11
2966967	SD	school	4641640	44002	Leola 44-2	464164000394	4	Spring Creek Colony Elementary	Regular School	No	1	KG	08	2015	grade_11
2967054	SD	school	4644770	42001	Lyman 42-1	464477000728	4	Kennebec Elementary	Regular School	No	1	PK	05	2015	grade_11			0.0						0
2967057	SD	school	4644770	42001	Lyman 42-1	464477000397	3	Presho Elementary	Regular School	No	1	PK	05	2015	grade_11		0.0	0.0			0.0		0	0			0
2967116	SD	school	4639600	39002	Madison Central 39-2	463960001189	7	Madison Elementary School	Regular School	No	1	KG	05	2015	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
2967164	SD	school	4645450	60003	Marion 60-3	464545000407	2	Marion Elementary School	Regular School	No	1	PK	05	2015	grade_11		0.0	0.0			0.0		0	0			0
2967214	SD	school	4601026	43007	McCook Central 43-7	460102601281	4	Golden View Colony Elementary	Regular School	No	1	KG	08	2015	grade_11
2967215	SD	school	4601026	43007	McCook Central 43-7	460102600404	2	McCook Central Elementary	Regular School	No	1	PK	04	2015	grade_11	0.0	0.0				0.0	0	0				0
2967276	SD	school	4646260	15001	McIntosh 15-1	464626000410	2	McIntosh Elementary	Regular School	No	1	PK	06	2015	grade_11		0.0	0.0			0.0		0	0			0
2967324	SD	school	4646380	15002	McLaughlin 15-2	464638000415	2	McLaughlin Elementary	Regular School	No	1	PK	05	2015	grade_11		0.0	0.0			0.0		0	0			0
2967386	SD	school	4669930	46001	Meade 46-1	466993001236	17	Atall Elem	Regular School	No	1	KG	08	2015	grade_11
2967387	SD	school	4669930	46001	Meade 46-1	466993000740	13	Elm Springs Elementary	Regular School	No	1	KG	08	2015	grade_11						0.0						0
2967388	SD	school	4669930	46001	Meade 46-1	466993000736	9	Enning/Union Center Elem	Regular School	No	1	KG	08	2015	grade_11						0.0						0
2967389	SD	school	4669930	46001	Meade 46-1	466993000735	8	Hereford Elementary	Regular School	No	1	KG	08	2015	grade_11						0.0						0
2967390	SD	school	4669930	46001	Meade 46-1	466993000741	15	Opal Elementary	Regular School	No	1	KG	08	2015	grade_11		0.0						0
2967391	SD	school	4669930	46001	Meade 46-1	466993000644	5	Piedmont Valley Elementary	Regular School	No	1	KG	06	2015	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
2967393	SD	school	4669930	46001	Meade 46-1	466993000637	3	Sturgis Elementary	Regular School	No	1	PK	05	2015	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
2967395	SD	school	4669930	46001	Meade 46-1	466993000652	4	Whitewood Elementary	Regular School	No	1	KG	06	2015	grade_11		0.0	0.0			0.0		0	0			0
2967536	SD	school	4647100	33002	Menno 33-2	464710000417	3	Jamesville Colony Elementary	Regular School	No	1	PK	08	2015	grade_11
2967537	SD	school	4647100	33002	Menno 33-2	464710000418	4	Maxwell Colony Elementary	Regular School	No	1	PK	08	2015	grade_11
2967538	SD	school	4647100	33002	Menno 33-2	464710000419	2	Menno Elementary	Regular School	No	1	PK	05	2015	grade_11			0.0						0
2967612	SD	school	4600002	25004	Milbank 25-4	460000200423	3	Koch Elementary	Regular School	No	1	KG	05	2015	grade_11	0.0	0.0				0.0	0	0				0
2967662	SD	school	4647942	29004	Miller	464794200429	2	Miller Elementary School	Regular School	No	1	PK	06	2015	grade_11	0.0	0.0	0.0	0.0	0.0		0	0	0	0	0
2967665	SD	school	4647942	29004	Miller	464794200431	11	Millerdale Colony Elem	Regular School	No	1	KG	08	2015	grade_11
2967732	SD	school	4648390	17002	Mitchell 17-2	464839000591	4	Gertie Belle Rogers Elem	Regular School	No	1	KG	05	2015	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
2967733	SD	school	4648390	17002	Mitchell 17-2	464839000520	3	L B Williams Elementary	Regular School	No	1	KG	05	2015	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
2967734	SD	school	4648390	17002	Mitchell 17-2	464839000441	5	Longfellow Elementary	Regular School	No	1	KG	05	2015	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
2967737	SD	school	4648390	17002	Mitchell 17-2	464839000444	10	Rockport Colony Elem	Regular School	No	1	KG	08	2015	grade_11
2967738	SD	school	4648390	17002	Mitchell 17-2	464839000445	11	Rosedale Colony Elem	Regular School	No	1	KG	08	2015	grade_11		0.0						0
2967838	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100486	3	Freeman Davis Elementary	Regular School	No	1	PK	02	2015	grade_11		0.0	0.0	0.0	0.0			0	0	0	0
2967841	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100493	4	Mobridge Upper Elementary	Regular School	No	1	03	05	2015	grade_11		0.0	0.0	0.0		0.0		0	0	0		0
2967902	SD	school	4648780	43002	Montrose 43-2	464878000451	2	Montrose Elementary School	Regular School	No	1	PK	05	2015	grade_11		0.0				0.0		0				0
2967905	SD	school	4648780	43002	Montrose 43-2	464878001095	4	Orland Colony	Regular School	No	1	KG	08	2015	grade_11
2967964	SD	school	4649650	17003	Mount Vernon 17-3	464965000454	2	Mount Vernon Elementary	Regular School	No	1	PK	05	2015	grade_11		0.0	0.0			0.0		0	0			0
2968012	SD	school	4650670	51003	New Underwood 51-3	465067000463	2	New Underwood Elem	Regular School	No	1	KG	06	2015	grade_11		0.0	0.0			0.0		0	0			0
2968060	SD	school	4650850	9002	Newell 09-2	465085000468	2	Newell Elem	Regular School	No	1	PK	05	2015	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
2968108	SD	school	4651750	56007	Northwestern Area 56-7	465175000820	4	Northwestern Elementary	Regular School	No	1	PK	05	2015	grade_11						0.0						0
2968156	SD	school	4652770	23003	Oelrichs 23-3	465277000481	2	Oelrichs Elem	Regular School	No	1	KG	06	2015	grade_11		0.0	0.0			0.0		0	0			0
2968206	SD	school	4601027	39005	Oldham-Ramona 39-5	460102701030	2	Oldham-Ramona Elementary	Regular School	No	1	PK	06	2015	grade_11		0.0				0.0		0				0
2968209	SD	school	4601027	39005	Oldham-Ramona 39-5	460102701112	4	Spring Lake Colony Elementary	Regular School	No	1	KG	08	2015	grade_11
2968268	SD	school	4654270	60004	Parker 60-4	465427000487	2	Parker Elementary School	Regular School	No	1	PK	06	2015	grade_11	0.0	0.0	0.0		0.0	0.0	0	0	0		0	0
2968322	SD	school	4654300	33003	Parkston 33-3	465430000490	8	New Elm Spring Colony Elem	Regular School	No	1	KG	08	2015	grade_11
2968323	SD	school	4654300	33003	Parkston 33-3	465430000489	3	Old Elm Spring Colony Elem	Regular School	No	1	KG	08	2015	grade_11
2968325	SD	school	4654300	33003	Parkston 33-3	465430000491	2	Parkston Elementary	Regular School	No	1	PK	06	2015	grade_11	0.0	0.0	0.0			0.0	0	0	0			0
2968418	SD	school	4655260	32002	Pierre 32-2	465526000494	3	Buchanan Elementary	Regular School	No	1	KG	05	2015	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
2968420	SD	school	4655260	32002	Pierre 32-2	465526000495	6	Jefferson Elementary	Regular School	No	1	KG	05	2015	grade_11	0.0	0.0	0.0			0.0	0	0	0			0