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 order by ccd_charter_school 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	white	black	hispanic	native_american_alaskan_native	asian	native_hawaiian_pacific_islander	multiracial	male	female	total	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	male_int	female_int	total_int
709485	CO	school		180	ADAMS-ARAPAHOE 28J		1	FACILITIES WITH DISTRICT RUN EDUCATION						2017	grade_11	1	0	1	0	0	0	0	1	1	2	1	0	1	0	0	0	0	1	1	2
715516	CO	school		1420	JEFFERSON COUNTY R-1		0	Not a school						2017	grade_11	1	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0	1	1
716934	CO	school		1520	DURANGO 9-R		0	Not a school						2017	grade_11	1	0	0	1	0	0	0	1	1	2	1	0	0	1	0	0	0	1	1	2
717067	CO	school		1550	POUDRE R-1		0	Not a school						2017	grade_11	2	0	0	0	0	0	0	1	1	2	2	0	0	0	0	0	0	1	1	2
720095	CO	school		3100	WINDSOR RE-4		0	Not a school						2017	grade_11	1	0	0	0	0	0	0	1	0	1	1	0	0	0	0	0	0	1	0	1
721017	CO	school		9999	COLORADO DETENTION CENTER TOTAL		No school	COLORADO DETENTION CENTER TOTAL						2017	grade_11	18	8	22	0	1	0	3	36	16	52	18	8	22	0	1	0	3	36	16	52
835490	CO	school		10	MAPLETON 1		187	MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS						2016	grade_11	19	2	65	0	0	0	2	57	31	88	19	2	65	0	0	0	2	57	31	88
835497	CO	school		10	MAPLETON 1		212	MAPLETON EARLY COLLEGE HIGH SCHOOL						2016	grade_11	19	1	42	0	0	0	1	31	32	63	19	1	42	0	0	0	1	31	32	63
835503	CO	school		10	MAPLETON 1		263	GLOBAL LEADERSHIP ACADEMY						2016	grade_11	3	0	38	1	0	0	1	29	14	43	3	0	38	1	0	0	1	29	14	43
835517	CO	school		10	MAPLETON 1		309	ACADEMY HIGH SCHOOL						2016	grade_11	6	2	76	0	3	1	2	49	41	90	6	2	76	0	3	1	2	49	41	90
835545	CO	school		10	MAPLETON 1		503	YORK INTERNATIONAL						2016	grade_11	7	1	39	0	1	0	1	24	25	49	7	1	39	0	1	0	1	24	25	49
835654	CO	school		20	ADAMS 12 FIVE STAR SCHOOLS		210	VANTAGE POINT						2016	grade_11	51	2	54	1	3	0	2	58	55	113	51	2	54	1	3	0	2	58	55	113
836014	CO	school		30	ADAMS COUNTY 14		22	LESTER R ARNOLD HIGH SCHOOL						2016	grade_11	8	2	40	1	0	0	0	24	27	51	8	2	40	1	0	0	0	24	27	51
836019	CO	school		30	ADAMS COUNTY 14		24	ADAMS CITY HIGH SCHOOL						2016	grade_11	57	10	315	1	0	0	5	201	187	388	57	10	315	1	0	0	5	201	187	388
836277	CO	school		50	BENNETT 29J		775	BENNETT HIGH SCHOOL						2016	grade_11	69	1	11	0	1	0	1	51	32	83	69	1	11	0	1	0	1	51	32	83
836435	CO	school		100	ALAMOSA RE-11J		118	ALAMOSA HIGH SCHOOL						2016	grade_11	36	3	64	2	3	0	1	47	62	109	36	3	64	2	3	0	1	47	62	109
836440	CO	school		100	ALAMOSA RE-11J		368	ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE						2016	grade_11	1	0	3	0	0	0	0	1	3	4	1	0	3	0	0	0	0	1	3	4
836463	CO	school		120	ENGLEWOOD 1		206	COLORADO'S FINEST HIGH SCHOOL OF CHOICE						2016	grade_11	38	2	42	1	1	0	0	47	37	84	38	2	42	1	1	0	0	47	37	84
836965	CO	school		140	LITTLETON 6		298	ARAPAHOE HIGH SCHOOL						2016	grade_11	462	7	69	3	17	1	17	295	281	576	462	7	69	3	17	1	17	295	281	576
837162	CO	school		180	ADAMS-ARAPAHOE 28J		219	APS ONLINE SCHOOL						2016	grade_11	5	6	20	0	1	0	2	17	17	34	5	6	20	0	1	0	2	17	17	34
837821	CO	school		470	ST VRAIN VALLEY RE 1J		120	APEX HOME SCHOOL ENRICHMENT PROGRAM						2016	grade_11	27	0	2	0	0	0	1	15	15	30	27	0	2	0	0	0	1	15	15	30
838190	CO	school		480	BOULDER VALLEY RE 2		125	ARAPAHOE RIDGE HIGH SCHOOL						2016	grade_11	18	1	21	0	0	0	1	18	23	41	18	1	21	0	0	0	1	18	23	41
838239	CO	school		480	BOULDER VALLEY RE 2		924	BOULDER HIGH SCHOOL						2016	grade_11	332	6	94	0	14	1	19	238	228	466	332	6	94	0	14	1	19	238	228	466
838244	CO	school		480	BOULDER VALLEY RE 2		930	BOULDER UNIVERSAL						2016	grade_11	12	0	3	0	0	0	1	5	11	16	12	0	3	0	0	0	1	5	11	16
838254	CO	school		480	BOULDER VALLEY RE 2		934	BOULDER PREP CHARTER HIGH SCHOOL						2016	grade_11	30	1	9	0	0	0	4	20	24	44	30	1	9	0	0	0	4	20	24	44
838772	CO	school		580	SOUTH CONEJOS RE-10		252	ANTONITO HIGH SCHOOL						2016	grade_11	0	0	9	0	0	0	0	5	4	9	0	0	9	0	0	0	0	5	4	9
838952	CO	school		880	DENVER COUNTY 1		10	ABRAHAM LINCOLN HIGH SCHOOL						2016	grade_11	9	6	289	2	8	0	1	161	154	315	9	6	289	2	8	0	1	161	154	315
838957	CO	school		880	DENVER COUNTY 1		40	RIDGE VIEW ACADEMY CHARTER SCHOOL						2016	grade_11	6	11	10	0	0	0	0	27	0	27	6	11	10	0	0	0	0	27	0	27
838962	CO	school		880	DENVER COUNTY 1		67	ACADEMY OF URBAN LEARNING						2016	grade_11	1	2	33	1	0	0	1	22	16	38	1	2	33	1	0	0	1	22	16	38
840349	CO	school		900	DOUGLAS COUNTY RE 1		201	DANIEL C OAKES HIGH SCHOOL--CASTLE ROCK						2016	grade_11	29	0	5	0	0	0	2	16	20	36	29	0	5	0	0	0	2	16	20	36
841050	CO	school		910	EAGLE COUNTY RE 50		205	RED CANYON HIGH SCHOOL						2016	grade_11	16	0	29	0	0	0	0	31	14	45	16	0	29	0	0	0	0	31	14	45
841064	CO	school		910	EAGLE COUNTY RE 50		604	BATTLE MOUNTAIN HIGH SCHOOL						2016	grade_11	82	0	116	0	3	0	4	104	101	205	82	0	116	0	3	0	4	104	101	205
841279	CO	school		980	HARRISON 2		469	ATLAS PREPARATORY SCHOOL						2016	grade_11	11	15	49	1	1	0	3	50	30	80	11	15	49	1	1	0	3	50	30	80
841540	CO	school		1000	FOUNTAIN 8		203	WELTE EDUCATION CENTER						2016	grade_11	14	2	12	0	0	0	7	22	13	35	14	2	12	0	0	0	7	22	13	35
841617	CO	school		1010	COLORADO SPRINGS 11		269	ACHIEVE ONLINE						2016	grade_11	26	1	19	1	0	0	3	26	24	50	26	1	19	1	0	0	3	26	24	50
841644	CO	school		1010	COLORADO SPRINGS 11		871	THE BIJOU SCHOOL						2016	grade_11	27	1	5	1	0	1	7	25	17	42	27	1	5	1	0	1	7	25	17	42
842108	CO	school		1040	ACADEMY 20		76	AIR ACADEMY HIGH SCHOOL						2016	grade_11	266	12	46	1	10	2	18	182	173	355	266	12	46	1	10	2	18	182	173	355
842113	CO	school		1040	ACADEMY 20		110	ACADEMY ONLINE						2016	grade_11	9	0	3	0	0	0	0	6	6	12	9	0	3	0	0	0	0	6	6	12
842118	CO	school		1040	ACADEMY 20		209	ASPEN VALLEY CAMPUS						2016	grade_11	22	0	5	0	0	0	0	13	14	27	22	0	5	0	0	0	0	13	14	27
842670	CO	school		1140	CANON CITY RE-1		419	CANON ONLINE ACADEMY						2016	grade_11	18	0	2	0	0	0	0	10	10	20	18	0	2	0	0	0	0	10	10	20
842798	CO	school		1180	ROARING FORK RE-1		570	BASALT HIGH SCHOOL						2016	grade_11	26	0	60	0	1	0	1	58	30	88	26	0	60	0	1	0	1	58	30	88
842853	CO	school		1195	GARFIELD RE-2		65	COAL RIDGE HIGH SCHOOL						2016	grade_11	69	0	46	0	0	0	0	65	50	115	69	0	46	0	0	0	0	65	50	115
843121	CO	school		1420	JEFFERSON COUNTY R-1		0	Not a school						2016	grade_11	1	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0	1	1
843135	CO	school		1420	JEFFERSON COUNTY R-1		33	MC LAIN HIGH SCHOOL						2016	grade_11	78	0	31	5	0	0	4	59	59	118	78	0	31	5	0	0	4	59	59	118
843142	CO	school		1420	JEFFERSON COUNTY R-1		108	ALAMEDA INTERNATIONAL JUNIOR/SENIOR HIGH SCHOOL						2016	grade_11	31	2	149	1	12	0	5	99	101	200	31	2	149	1	12	0	5	99	101	200
843167	CO	school		1420	JEFFERSON COUNTY R-1		370	ARVADA HIGH SCHOOL						2016	grade_11	92	3	125	0	6	0	6	131	101	232	92	3	125	0	6	0	6	131	101	232
843172	CO	school		1420	JEFFERSON COUNTY R-1		378	ARVADA WEST HIGH SCHOOL						2016	grade_11	324	4	65	6	8	0	11	228	190	418	324	4	65	6	8	0	11	228	190	418
843196	CO	school		1420	JEFFERSON COUNTY R-1		664	BEAR CREEK HIGH SCHOOL						2016	grade_11	226	4	124	3	32	2	13	214	190	404	226	4	124	3	32	2	13	214	190	404
843244	CO	school		1420	JEFFERSON COUNTY R-1		965	BRADY EXPLORATION SCHOOL						2016	grade_11	21	2	33	2	0	0	0	34	24	58	21	2	33	2	0	0	0	34	24	58
844481	CO	school		1490	BETHUNE R-5		842	BETHUNE PUBLIC SCHOOLS						2016	grade_11	8	0	2	0	1	0	1	5	7	12	8	0	2	0	1	0	1	5	7	12
844529	CO	school		1520	DURANGO 9-R		0	Not a school						2016	grade_11	2	0	2	0	0	0	0	3	1	4	2	0	2	0	0	0	0	3	1	4
844629	CO	school		1530	BAYFIELD 10 JT-R		640	BAYFIELD HIGH SCHOOL						2016	grade_11	73	0	13	1	0	0	2	47	42	89	73	0	13	1	0	0	2	47	42	89
844650	CO	school		1550	POUDRE R-1		0	Not a school						2016	grade_11	2	0	4	0	0	0	0	4	2	6	2	0	4	0	0	0	0	4	2	6
844656	CO	school		1550	POUDRE R-1		146	RIDGEVIEW CLASSICAL CHARTER SCHOOLS						2016	grade_11	37	0	4	0	3	0	3	20	27	47	37	0	4	0	3	0	3	20	27	47
845074	CO	school		1560	THOMPSON R2-J		812	BERTHOUD HIGH SCHOOL						2016	grade_11	143	2	15	1	5	1	0	81	86	167	143	2	15	1	5	1	0	81	86	167
845386	CO	school		1620	AGUILAR REORGANIZED 6		66	AGUILAR JUNIOR-SENIOR HIGH SCHOOL						2016	grade_11	1	0	5	0	0	0	0	3	3	6	1	0	5	0	0	0	0	3	3	6
845394	CO	school		1750	BRANSON REORGANIZED 82		948	BRANSON SCHOOL ONLINE						2016	grade_11	28	3	8	0	0	0	0	13	26	39	28	3	8	0	0	0	0	13	26	39
845408	CO	school		1750	BRANSON REORGANIZED 82		978	BRANSON SCHOOL						2016	grade_11	2	0	2	0	0	0	0	2	2	4	2	0	2	0	0	0	0	2	2	4
845481	CO	school		1828	VALLEY RE-1		0	Not a school						2016	grade_11	1	0	0	0	0	0	0	1	0	1	1	0	0	0	0	0	0	1	0	1
846554	CO	school		2640	ASPEN 1		432	ASPEN HIGH SCHOOL						2016	grade_11	105	0	21	0	5	0	1	67	65	132	105	0	21	0	5	0	1	67	65	132
847254	CO	school		2810	CENTER 26 JT		51	THE ACADEMIC RECOVERY CENTER OF SAN LUIS VALLEY						2016	grade_11	0	0	2	0	0	0	0	1	1	2	0	0	2	0	0	0	0	1	1	2
847490	CO	school		3030	AKRON R-1		90	AKRON HIGH SCHOOL						2016	grade_11	26	0	6	0	0	0	2	20	14	34	26	0	6	0	0	0	2	20	14	34
847504	CO	school		3040	ARICKAREE R-2		308	ARICKAREE UNDIVIDED HIGH SCHOOL						2016	grade_11	8	0	1	0	0	0	0	6	3	9	8	0	1	0	0	0	0	6	3	9
848190	CO	school		8001	CHARTER SCHOOL INSTITUTE		15	ACADEMY OF CHARTER SCHOOLS						2016	grade_11	73	1	39	2	13	0	6	71	63	134	73	1	39	2	13	0	6	71	63	134
848214	CO	school		8001	CHARTER SCHOOL INSTITUTE		75	ANIMAS HIGH SCHOOL						2016	grade_11	65	1	3	1	0	0	0	46	24	70	65	1	3	1	0	0	0	46	24	70
848553	CO	school		9999	COLORADO DETENTION CENTER TOTAL		No school	COLORADO DETENTION CENTER TOTAL						2016	grade_11	15	11	34	0	1	0	1	46	16	62	15	11	34	0	1	0	1	46	16	62
1134846	CO	school		180	ADAMS-ARAPAHOE 28J		1	FACILITIES WITH DISTRICT RUN EDUCATION						2015	grade_11	2.0	0.0	2.0	0.0	0.0	0.0	0.0	2.0	2.0	4.0	2	0	2	0	0	0	0	2	2	4
1142232	CO	school		1550	POUDRE R-1		0	Not a school						2015	grade_11	1.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	1.0	1	0	0	0	0	0	0	1	0	1
1146090	CO	school		9999	COLORADO DETENTION CENTER TOTAL		No school	COLORADO DETENTION CENTER TOTAL						2015	grade_11	19.0	3.0	12.0	0.0	0.0	0.0	3.0	29.0	8.0	37.0	19	3	12	0	0	0	3	29	8	37
1739969	CO	school		180	Adams-Arapahoe 28J		1	Facilities with District Run Education						2021	grade_11	0	1	0	0	0	0	0	0	1	1	0	1	0	0	0	0	0	0	1	1
1746112	CO	school		1420	Jefferson County R-1		0	Not a school						2021	grade_11	0	0	1	0	0	0	0	0	1	1	0	0	1	0	0	0	0	0	1	1
1747581	CO	school		1550	Poudre R-1		0	Not a school						2021	grade_11	1	0	0	0	0	0	0	1	0	1	1	0	0	0	0	0	0	1	0	1
1749499	CO	school		2690	Pueblo City 60		0	Not a school						2021	grade_11	0	0	1	0	0	0	0	0	1	1	0	0	1	0	0	0	0	0	1	1
1751540	CO	school		9999	COLORADO DETENTION CENTER TOTAL		No school	COLORADO DETENTION CENTER TOTAL						2021	grade_11	13	2	15	0	2	0	1	28	5	33	13	2	15	0	2	0	1	28	5	33
1799458	CO	school		20	Adams 12 Five Star Schools		0	Not a school						2020	grade_11	5	0	5	1	0	0	0	4	7	11	5	0	5	1	0	0	0	4	7	11
1801016	CO	school		180	Adams-Arapahoe 28J		1	Facilities with District Run Education						2020	grade_11	0	0	0	0	0	0	1	1	0	1	0	0	0	0	0	0	1	1	0	1
1806749	CO	school		1140	Canon City RE-1		0	Not a school						2020	grade_11	0	0	1	0	0	0	0	0	1	1	0	0	1	0	0	0	0	0	1	1
1808696	CO	school		1550	Poudre R-1		0	Not a school						2020	grade_11	3	0	2	0	0	0	1	5	1	6	3	0	2	0	0	0	1	5	1	6
1812621	CO	school		9999	COLORADO DETENTION CENTER TOTAL		No school	COLORADO DETENTION CENTER TOTAL						2020	grade_11	20	12	35	2	1	0	3	61	12	73	20	12	35	2	1	0	3	61	12	73
1893831	CO	school		20	ADAMS 12 FIVE STAR SCHOOLS		0	Not a school						2018	grade_11	4	0	5	0	2	0	0	2	9	11	4	0	5	0	2	0	0	2	9	11
1895376	CO	school		180	ADAMS-ARAPAHOE 28J		1	FACILITIES WITH DISTRICT RUN EDUCATION						2018	grade_11	1	0	2	0	0	0	0	2	1	3	1	0	2	0	0	0	0	2	1	3
1902871	CO	school		1520	DURANGO 9-R		0	Not a school						2018	grade_11	6	0	2	1	0	0	2	4	7	11	6	0	2	1	0	0	2	4	7	11
1903012	CO	school		1550	POUDRE R-1		0	Not a school						2018	grade_11	2	0	3	0	0	0	0	5	0	5	2	0	3	0	0	0	0	5	0	5
1904617	CO	school		2405	FORT MORGAN RE-3		0	Not a school						2018	grade_11	1	0	1	0	0	0	0	1	1	2	1	0	1	0	0	0	0	1	1	2
1904677	CO	school		2515	WIGGINS RE-50(J)		0	Not a school						2018	grade_11	1	0	0	0	0	0	0	1	0	1	1	0	0	0	0	0	0	1	0	1
1906981	CO	school		9999	COLORADO DETENTION CENTERS		No school	COLORADO DETENTION CENTERS						2018	grade_11	37	3	23	1	0	0	2	53	13	66	37	3	23	1	0	0	2	53	13	66
1931103	CO	school		20	ADAMS 12 FIVE STAR SCHOOLS		0	Not a school						2019	grade_11	7	0	4	0	0	0	1	2	10	12	7	0	4	0	0	0	1	2	10	12
1932683	CO	school		180	ADAMS-ARAPAHOE 28J		1	FACILITIES WITH DISTRICT RUN EDUCATION						2019	grade_11	1	1	0	0	0	0	0	1	1	2	1	1	0	0	0	0	0	1	1	2
1938400	CO	school		1140	CANON CITY RE-1		0	Not a school						2019	grade_11	3	0	0	0	0	0	0	1	2	3	3	0	0	0	0	0	0	1	2	3
1938853	CO	school		1420	JEFFERSON COUNTY R-1		0	Not a school						2019	grade_11	2	0	0	0	0	0	1	3	0	3	2	0	0	0	0	0	1	3	0	3
1940384	CO	school		1550	POUDRE R-1		0	Not a school						2019	grade_11	0	0	2	0	0	0	0	2	0	2	0	0	2	0	0	0	0	2	0	2
1944360	CO	school		9999	COLORADO DETENTION CENTER TOTAL		No school	COLORADO DETENTION CENTER TOTAL						2019	grade_11	27	9	30	0	0	0	3	51	18	69	27	9	30	0	0	0	3	51	18	69
707820	CO	school	805550	10	MAPLETON 1	80555001857	187	MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS	Regular School	No	High	07	12	2017	grade_11	19	7	58	1	0	0	1	32	54	86	19	7	58	1	0	0	1	32	54	86
707827	CO	school	805550	10	MAPLETON 1	80555001858	212	MAPLETON EARLY COLLEGE HIGH SCHOOL	Regular School	No	High	09	12	2017	grade_11	11	2	45	1	0	0	2	32	29	61	11	2	45	1	0	0	2	32	29	61
707832	CO	school	805550	10	MAPLETON 1	80555001860	263	GLOBAL LEADERSHIP ACADEMY	Regular School	No	High	09	12	2017	grade_11	1	1	33	0	1	0	0	19	17	36	1	1	33	0	1	0	0	19	17	36
707837	CO	school	805550	10	MAPLETON 1	80555001872	309	ACADEMY HIGH SCHOOL	Regular School	No	High	09	12	2017	grade_11	22	5	64	2	2	1	3	57	42	99	22	5	64	2	2	1	3	57	42	99
707865	CO	school	805550	10	MAPLETON 1	80555002017	503	YORK INTERNATIONAL	Regular School	No	Other	KG	12	2017	grade_11	4	0	33	0	0	0	1	14	24	38	4	0	33	0	0	0	1	14	24	38
707930	CO	school	805550	10	MAPLETON 1	80555006488	1796	COLORADO CONNECTIONS ACADEMY	Regular School	No	Other	KG	12	2017	grade_11	188	6	50	2	5	3	23	102	175	277	188	6	50	2	5	3	23	102	175	277
707989	CO	school	806900	20	ADAMS 12 FIVE STAR SCHOOLS	80690001172	210	VANTAGE POINT	Alternative School	No	Other	06	12	2017	grade_11	60	2	80	2	0	0	0	74	70	144	60	2	80	2	0	0	0	74	70	144
708126	CO	school	806900	20	ADAMS 12 FIVE STAR SCHOOLS	80690001491	4108	HORIZON HIGH SCHOOL	Regular School	No	High	09	12	2017	grade_11	305	15	118	2	38	0	2	257	223	480	305	15	118	2	38	0	2	257	223	480
708145	CO	school	806900	20	ADAMS 12 FIVE STAR SCHOOLS	80690001784	5043	LEGACY HIGH SCHOOL	Regular School	No	High	09	12	2017	grade_11	373	11	114	2	41	0	17	286	272	558	373	11	114	2	41	0	17	286	272	558