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 "state" = :p0 and "year" = :p1 order by ccd_school_lvl 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
1799306	CO	school		10	Mapleton 1		0	Not a school						2020	grade_12	8	1	8	1	0	0	0	14	4	18	8	1	8	1	0	0	0	14	4	18
1799307	CO	school		10	Mapleton 1		0	Not a school						2020	pk_12_total	8	1	8	1	0	0	0	14	4	18	8	1	8	1	0	0	0	14	4	18
1799457	CO	school		20	Adams 12 Five Star Schools		0	Not a school						2020	grade_10	1	0	0	0	0	0	0	1	0	1	1	0	0	0	0	0	0	1	0	1
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
1799459	CO	school		20	Adams 12 Five Star Schools		0	Not a school						2020	grade_12	27	0	17	0	2	0	1	17	30	47	27	0	17	0	2	0	1	17	30	47
1799460	CO	school		20	Adams 12 Five Star Schools		0	Not a school						2020	pk_12_total	33	0	22	1	2	0	1	22	37	59	33	0	22	1	2	0	1	22	37	59
1800143	CO	school		70	Westminster Public Schools		0	Not a school						2020	grade_12	1	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0	1	1
1800144	CO	school		70	Westminster Public Schools		0	Not a school						2020	pk_12_total	1	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0	1	1
1801015	CO	school		180	Adams-Arapahoe 28J		1	Facilities with District Run Education						2020	grade_10	2	1	0	0	0	0	0	1	2	3	2	1	0	0	0	0	0	1	2	3
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
1801017	CO	school		180	Adams-Arapahoe 28J		1	Facilities with District Run Education						2020	grade_12	0	1	1	0	0	0	0	1	1	2	0	1	1	0	0	0	0	1	1	2
1801018	CO	school		180	Adams-Arapahoe 28J		1	Facilities with District Run Education						2020	grade_2	0	0	2	0	0	0	0	1	1	2	0	0	2	0	0	0	0	1	1	2
1801019	CO	school		180	Adams-Arapahoe 28J		1	Facilities with District Run Education						2020	grade_3	0	0	1	0	1	0	0	1	1	2	0	0	1	0	1	0	0	1	1	2
1801020	CO	school		180	Adams-Arapahoe 28J		1	Facilities with District Run Education						2020	grade_5	1	0	1	0	0	0	1	3	0	3	1	0	1	0	0	0	1	3	0	3
1801021	CO	school		180	Adams-Arapahoe 28J		1	Facilities with District Run Education						2020	grade_6	0	0	2	0	0	0	0	2	0	2	0	0	2	0	0	0	0	2	0	2
1801022	CO	school		180	Adams-Arapahoe 28J		1	Facilities with District Run Education						2020	grade_7	0	0	2	0	1	0	0	2	1	3	0	0	2	0	1	0	0	2	1	3
1801023	CO	school		180	Adams-Arapahoe 28J		1	Facilities with District Run Education						2020	grade_8	1	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0	1	1
1801024	CO	school		180	Adams-Arapahoe 28J		1	Facilities with District Run Education						2020	pk_12_total	4	2	9	0	2	0	2	12	7	19	4	2	9	0	2	0	2	12	7	19
1805583	CO	school		1010	Colorado Springs 11		0	Not a school						2020	grade_12	9	0	3	0	0	0	2	6	8	14	9	0	3	0	0	0	2	6	8	14
1805584	CO	school		1010	Colorado Springs 11		0	Not a school						2020	pk_12_total	9	0	3	0	0	0	2	6	8	14	9	0	3	0	0	0	2	6	8	14
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
1806750	CO	school		1140	Canon City RE-1		0	Not a school						2020	grade_12	9	0	4	0	0	0	1	2	12	14	9	0	4	0	0	0	1	2	12	14
1806751	CO	school		1140	Canon City RE-1		0	Not a school						2020	pk_12_total	9	0	5	0	0	0	1	2	13	15	9	0	5	0	0	0	1	2	13	15
1807198	CO	school		1420	Jefferson County R-1		0	Not a school						2020	grade_12	9	0	4	2	0	0	1	11	5	16	9	0	4	2	0	0	1	11	5	16
1807199	CO	school		1420	Jefferson County R-1		0	Not a school						2020	pk_12_total	9	0	4	2	0	0	1	11	5	16	9	0	4	2	0	0	1	11	5	16
1808555	CO	school		1520	Durango 9-R		0	Not a school						2020	grade_12	2	0	0	0	0	0	0	1	1	2	2	0	0	0	0	0	0	1	1	2
1808556	CO	school		1520	Durango 9-R		0	Not a school						2020	pk_12_total	2	0	0	0	0	0	0	1	1	2	2	0	0	0	0	0	0	1	1	2
1808695	CO	school		1550	Poudre R-1		0	Not a school						2020	grade_10	4	0	1	1	0	0	1	7	0	7	4	0	1	1	0	0	1	7	0	7
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
1808697	CO	school		1550	Poudre R-1		0	Not a school						2020	grade_12	4	0	3	0	0	0	1	6	2	8	4	0	3	0	0	0	1	6	2	8
1808698	CO	school		1550	Poudre R-1		0	Not a school						2020	grade_7	2	0	1	0	0	0	0	2	1	3	2	0	1	0	0	0	0	2	1	3
1808699	CO	school		1550	Poudre R-1		0	Not a school						2020	grade_8	0	0	0	0	0	0	1	0	1	1	0	0	0	0	0	0	1	0	1	1
1808700	CO	school		1550	Poudre R-1		0	Not a school						2020	grade_9	2	0	0	0	0	0	0	1	1	2	2	0	0	0	0	0	0	1	1	2
1808701	CO	school		1550	Poudre R-1		0	Not a school						2020	pk_12_total	15	0	7	1	0	0	4	21	6	27	15	0	7	1	0	0	4	21	6	27
1809632	CO	school		2000	Mesa County Valley 51		355	The Learning Tree						2020	pk_12_total	12	0	6	0	0	0	1	9	10	19	12	0	6	0	0	0	1	9	10	19
1809633	CO	school		2000	Mesa County Valley 51		355	The Learning Tree						2020	pre_kindergarten	12	0	6	0	0	0	1	9	10	19	12	0	6	0	0	0	1	9	10	19
1809634	CO	school		2000	Mesa County Valley 51		356	Razz Ma Tazz						2020	pk_12_total	19	0	7	0	0	0	1	13	14	27	19	0	7	0	0	0	1	13	14	27
1809635	CO	school		2000	Mesa County Valley 51		356	Razz Ma Tazz						2020	pre_kindergarten	19	0	7	0	0	0	1	13	14	27	19	0	7	0	0	0	1	13	14	27
1809636	CO	school		2000	Mesa County Valley 51		357	Crossroads Academy Preschool						2020	pk_12_total	4	0	2	0	0	0	0	4	2	6	4	0	2	0	0	0	0	4	2	6
1809637	CO	school		2000	Mesa County Valley 51		357	Crossroads Academy Preschool						2020	pre_kindergarten	4	0	2	0	0	0	0	4	2	6	4	0	2	0	0	0	0	4	2	6
1810631	CO	school		2690	Pueblo City 60		0	Not a school						2020	grade_10	0	0	1	0	0	0	0	0	1	1	0	0	1	0	0	0	0	0	1	1
1810632	CO	school		2690	Pueblo City 60		0	Not a school						2020	grade_12	14	3	22	1	0	0	0	18	22	40	14	3	22	1	0	0	0	18	22	40
1810633	CO	school		2690	Pueblo City 60		0	Not a school						2020	pk_12_total	14	3	23	1	0	0	0	18	23	41	14	3	23	1	0	0	0	18	23	41
1812620	CO	school		9999	COLORADO DETENTION CENTER TOTAL		No school	COLORADO DETENTION CENTER TOTAL						2020	grade_10	11	9	25	1	3	0	1	43	7	50	11	9	25	1	3	0	1	43	7	50
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
1812622	CO	school		9999	COLORADO DETENTION CENTER TOTAL		No school	COLORADO DETENTION CENTER TOTAL						2020	grade_12	29	10	33	0	2	0	2	61	15	76	29	10	33	0	2	0	2	61	15	76
1812623	CO	school		9999	COLORADO DETENTION CENTER TOTAL		No school	COLORADO DETENTION CENTER TOTAL						2020	grade_7	1	1	2	0	0	0	0	4	0	4	1	1	2	0	0	0	0	4	0	4
1812624	CO	school		9999	COLORADO DETENTION CENTER TOTAL		No school	COLORADO DETENTION CENTER TOTAL						2020	grade_8	3	1	7	0	0	0	0	9	2	11	3	1	7	0	0	0	0	9	2	11
1812625	CO	school		9999	COLORADO DETENTION CENTER TOTAL		No school	COLORADO DETENTION CENTER TOTAL						2020	grade_9	15	6	17	0	2	0	7	41	6	47	15	6	17	0	2	0	7	41	6	47
1812626	CO	school		9999	COLORADO DETENTION CENTER TOTAL		No school	COLORADO DETENTION CENTER TOTAL						2020	pk_12_total	79	39	119	3	8	0	13	219	42	261	79	39	119	3	8	0	13	219	42	261
1799330	CO	school	805550	10	Mapleton 1	80555002021	501	Monterey Community School	Regular School	No	Elementary	KG	08	2020	grade_1	6	0	28	0	0	0	1	17	18	35	6	0	28	0	0	0	1	17	18	35
1799331	CO	school	805550	10	Mapleton 1	80555002021	501	Monterey Community School	Regular School	No	Elementary	KG	08	2020	grade_2	8	0	25	0	0	0	0	16	17	33	8	0	25	0	0	0	0	16	17	33
1799332	CO	school	805550	10	Mapleton 1	80555002021	501	Monterey Community School	Regular School	No	Elementary	KG	08	2020	grade_3	5	1	33	0	3	0	0	17	25	42	5	1	33	0	3	0	0	17	25	42
1799333	CO	school	805550	10	Mapleton 1	80555002021	501	Monterey Community School	Regular School	No	Elementary	KG	08	2020	grade_4	2	0	33	0	2	0	0	13	24	37	2	0	33	0	2	0	0	13	24	37
1799334	CO	school	805550	10	Mapleton 1	80555002021	501	Monterey Community School	Regular School	No	Elementary	KG	08	2020	grade_5	3	1	42	0	1	0	0	24	23	47	3	1	42	0	1	0	0	24	23	47
1799335	CO	school	805550	10	Mapleton 1	80555002021	501	Monterey Community School	Regular School	No	Elementary	KG	08	2020	grade_6	6	0	52	0	1	0	1	20	40	60	6	0	52	0	1	0	1	20	40	60
1799336	CO	school	805550	10	Mapleton 1	80555002021	501	Monterey Community School	Regular School	No	Elementary	KG	08	2020	grade_7	4	0	35	0	1	0	1	22	19	41	4	0	35	0	1	0	1	22	19	41
1799337	CO	school	805550	10	Mapleton 1	80555002021	501	Monterey Community School	Regular School	No	Elementary	KG	08	2020	grade_8	3	0	49	0	2	0	0	24	30	54	3	0	49	0	2	0	0	24	30	54
1799338	CO	school	805550	10	Mapleton 1	80555002021	501	Monterey Community School	Regular School	No	Elementary	KG	08	2020	kindergarten_full_day	4	0	20	0	0	0	0	10	14	24	4	0	20	0	0	0	0	10	14	24
1799339	CO	school	805550	10	Mapleton 1	80555002021	501	Monterey Community School	Regular School	No	Elementary	KG	08	2020	pk_12_total	41	2	317	0	10	0	3	163	210	373	41	2	317	0	10	0	3	163	210	373
1799340	CO	school	805550	10	Mapleton 1	80555002031	502	Meadow Community School	Regular School	No	Elementary	PK	08	2020	grade_1	10	0	37	0	4	0	1	29	23	52	10	0	37	0	4	0	1	29	23	52
1799341	CO	school	805550	10	Mapleton 1	80555002031	502	Meadow Community School	Regular School	No	Elementary	PK	08	2020	grade_2	7	2	30	0	0	0	2	28	13	41	7	2	30	0	0	0	2	28	13	41
1799342	CO	school	805550	10	Mapleton 1	80555002031	502	Meadow Community School	Regular School	No	Elementary	PK	08	2020	grade_3	7	1	36	0	2	0	0	22	24	46	7	1	36	0	2	0	0	22	24	46
1799343	CO	school	805550	10	Mapleton 1	80555002031	502	Meadow Community School	Regular School	No	Elementary	PK	08	2020	grade_4	4	0	37	0	0	0	3	18	26	44	4	0	37	0	0	0	3	18	26	44
1799344	CO	school	805550	10	Mapleton 1	80555002031	502	Meadow Community School	Regular School	No	Elementary	PK	08	2020	grade_5	6	1	35	0	1	0	0	20	23	43	6	1	35	0	1	0	0	20	23	43
1799345	CO	school	805550	10	Mapleton 1	80555002031	502	Meadow Community School	Regular School	No	Elementary	PK	08	2020	grade_6	7	2	46	0	3	0	2	24	36	60	7	2	46	0	3	0	2	24	36	60
1799346	CO	school	805550	10	Mapleton 1	80555002031	502	Meadow Community School	Regular School	No	Elementary	PK	08	2020	grade_7	9	0	46	0	2	0	0	36	21	57	9	0	46	0	2	0	0	36	21	57
1799347	CO	school	805550	10	Mapleton 1	80555002031	502	Meadow Community School	Regular School	No	Elementary	PK	08	2020	grade_8	6	1	41	0	0	0	0	27	21	48	6	1	41	0	0	0	0	27	21	48
1799348	CO	school	805550	10	Mapleton 1	80555002031	502	Meadow Community School	Regular School	No	Elementary	PK	08	2020	kindergarten_full_day	12	2	35	1	1	0	1	29	23	52	12	2	35	1	1	0	1	29	23	52
1799349	CO	school	805550	10	Mapleton 1	80555002031	502	Meadow Community School	Regular School	No	Elementary	PK	08	2020	pk_12_total	76	9	390	1	17	0	10	260	243	503	76	9	390	1	17	0	10	260	243	503
1799350	CO	school	805550	10	Mapleton 1	80555002031	502	Meadow Community School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten	8	0	47	0	4	0	1	27	33	60	8	0	47	0	4	0	1	27	33	60
1799365	CO	school	805550	10	Mapleton 1	80555001997	504	Welby Community School	Regular School	No	Elementary	PK	06	2020	grade_1	5	1	37	0	2	0	1	22	24	46	5	1	37	0	2	0	1	22	24	46
1799366	CO	school	805550	10	Mapleton 1	80555001997	504	Welby Community School	Regular School	No	Elementary	PK	06	2020	grade_2	9	0	29	1	1	0	0	18	22	40	9	0	29	1	1	0	0	18	22	40
1799367	CO	school	805550	10	Mapleton 1	80555001997	504	Welby Community School	Regular School	No	Elementary	PK	06	2020	grade_3	11	0	27	0	1	0	0	20	19	39	11	0	27	0	1	0	0	20	19	39
1799368	CO	school	805550	10	Mapleton 1	80555001997	504	Welby Community School	Regular School	No	Elementary	PK	06	2020	grade_4	7	0	29	0	0	0	0	17	19	36	7	0	29	0	0	0	0	17	19	36
1799369	CO	school	805550	10	Mapleton 1	80555001997	504	Welby Community School	Regular School	No	Elementary	PK	06	2020	grade_5	1	0	24	0	1	0	1	11	16	27	1	0	24	0	1	0	1	11	16	27
1799370	CO	school	805550	10	Mapleton 1	80555001997	504	Welby Community School	Regular School	No	Elementary	PK	06	2020	grade_6	4	0	22	1	1	0	0	11	17	28	4	0	22	1	1	0	0	11	17	28
1799371	CO	school	805550	10	Mapleton 1	80555001997	504	Welby Community School	Regular School	No	Elementary	PK	06	2020	kindergarten_full_day	14	0	43	0	1	0	1	27	32	59	14	0	43	0	1	0	1	27	32	59
1799372	CO	school	805550	10	Mapleton 1	80555001997	504	Welby Community School	Regular School	No	Elementary	PK	06	2020	pk_12_total	67	3	303	3	8	0	3	172	215	387	67	3	303	3	8	0	3	172	215	387
1799373	CO	school	805550	10	Mapleton 1	80555001997	504	Welby Community School	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	16	2	92	1	1	0	0	46	66	112	16	2	92	1	1	0	0	46	66	112
1799374	CO	school	805550	10	Mapleton 1	80555002004	505	Achieve Academy	Regular School	No	Elementary	PK	08	2020	grade_1	3	0	25	0	2	0	1	13	18	31	3	0	25	0	2	0	1	13	18	31
1799375	CO	school	805550	10	Mapleton 1	80555002004	505	Achieve Academy	Regular School	No	Elementary	PK	08	2020	grade_2	5	1	40	0	0	0	0	19	27	46	5	1	40	0	0	0	0	19	27	46
1799376	CO	school	805550	10	Mapleton 1	80555002004	505	Achieve Academy	Regular School	No	Elementary	PK	08	2020	grade_3	8	0	36	0	2	0	0	21	25	46	8	0	36	0	2	0	0	21	25	46
1799377	CO	school	805550	10	Mapleton 1	80555002004	505	Achieve Academy	Regular School	No	Elementary	PK	08	2020	grade_4	3	0	44	0	2	0	1	24	26	50	3	0	44	0	2	0	1	24	26	50
1799378	CO	school	805550	10	Mapleton 1	80555002004	505	Achieve Academy	Regular School	No	Elementary	PK	08	2020	grade_5	9	0	38	1	1	0	2	26	25	51	9	0	38	1	1	0	2	26	25	51
1799379	CO	school	805550	10	Mapleton 1	80555002004	505	Achieve Academy	Regular School	No	Elementary	PK	08	2020	grade_6	1	2	47	0	2	0	3	26	29	55	1	2	47	0	2	0	3	26	29	55
1799380	CO	school	805550	10	Mapleton 1	80555002004	505	Achieve Academy	Regular School	No	Elementary	PK	08	2020	grade_7	5	0	51	1	1	0	3	31	30	61	5	0	51	1	1	0	3	31	30	61
1799381	CO	school	805550	10	Mapleton 1	80555002004	505	Achieve Academy	Regular School	No	Elementary	PK	08	2020	grade_8	4	4	44	0	2	0	1	24	31	55	4	4	44	0	2	0	1	24	31	55
1799382	CO	school	805550	10	Mapleton 1	80555002004	505	Achieve Academy	Regular School	No	Elementary	PK	08	2020	kindergarten_full_day	6	1	30	0	0	0	0	21	16	37	6	1	30	0	0	0	0	21	16	37
1799383	CO	school	805550	10	Mapleton 1	80555002004	505	Achieve Academy	Regular School	No	Elementary	PK	08	2020	pk_12_total	58	10	428	2	14	0	14	257	269	526	58	10	428	2	14	0	14	257	269	526
1799384	CO	school	805550	10	Mapleton 1	80555002004	505	Achieve Academy	Regular School	No	Elementary	PK	08	2020	pre_kindergarten	14	2	73	0	2	0	3	52	42	94	14	2	73	0	2	0	3	52	42	94
1799385	CO	school	805550	10	Mapleton 1	80555002007	506	Explore Elementary	Regular School	No	Elementary	PK	06	2020	grade_1	16	0	27	0	0	0	1	27	17	44	16	0	27	0	0	0	1	27	17	44
1799386	CO	school	805550	10	Mapleton 1	80555002007	506	Explore Elementary	Regular School	No	Elementary	PK	06	2020	grade_2	12	1	35	0	0	1	4	31	22	53	12	1	35	0	0	1	4	31	22	53
1799387	CO	school	805550	10	Mapleton 1	80555002007	506	Explore Elementary	Regular School	No	Elementary	PK	06	2020	grade_3	16	1	26	1	1	0	3	24	24	48	16	1	26	1	1	0	3	24	24	48
1799388	CO	school	805550	10	Mapleton 1	80555002007	506	Explore Elementary	Regular School	No	Elementary	PK	06	2020	grade_4	19	0	28	0	0	0	2	28	21	49	19	0	28	0	0	0	2	28	21	49
1799389	CO	school	805550	10	Mapleton 1	80555002007	506	Explore Elementary	Regular School	No	Elementary	PK	06	2020	grade_5	11	2	38	0	0	1	0	26	26	52	11	2	38	0	0	1	0	26	26	52
1799390	CO	school	805550	10	Mapleton 1	80555002007	506	Explore Elementary	Regular School	No	Elementary	PK	06	2020	grade_6	16	1	39	2	1	1	0	28	32	60	16	1	39	2	1	1	0	28	32	60
1799391	CO	school	805550	10	Mapleton 1	80555002007	506	Explore Elementary	Regular School	No	Elementary	PK	06	2020	kindergarten_full_day	17	0	36	0	1	0	1	29	26	55	17	0	36	0	1	0	1	29	26	55
1799392	CO	school	805550	10	Mapleton 1	80555002007	506	Explore Elementary	Regular School	No	Elementary	PK	06	2020	pk_12_total	116	6	280	3	4	3	13	230	195	425	116	6	280	3	4	3	13	230	195	425
1799393	CO	school	805550	10	Mapleton 1	80555002007	506	Explore Elementary	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	9	1	51	0	1	0	2	37	27	64	9	1	51	0	1	0	2	37	27	64
1799394	CO	school	805550	10	Mapleton 1	80555001932	507	Adventure Elementary	Regular School	No	Elementary	PK	06	2020	grade_1	9	0	40	0	1	0	0	32	18	50	9	0	40	0	1	0	0	32	18	50