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 order by native_hawaiian_pacific_islander limit 101

Query parameters

This data as json, CSV

rowid	state	admin_level	district_state_id	district	school_state_id	school	year	grade	white	black	hispanic	native_american_alaskan_native	asian	multiracial	male	female	total	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	multiracial_int	male_int	female_int	total_int
835487	CO	school	10	MAPLETON 1	0	Not a school	2016	grade_12	0	0	7	0	0	0	2	5	7	0	0	7	0	0	0	2	5	7
835488	CO	school	10	MAPLETON 1	0	Not a school	2016	pk_12_total	0	0	7	0	0	0	2	5	7	0	0	7	0	0	0	2	5	7
835489	CO	school	10	MAPLETON 1	187	MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS	2016	grade_10	31	7	82	1	0	1	51	71	122	31	7	82	1	0	1	51	71	122
835490	CO	school	10	MAPLETON 1	187	MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS	2016	grade_11	19	2	65	0	0	2	57	31	88	19	2	65	0	0	2	57	31	88
835491	CO	school	10	MAPLETON 1	187	MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS	2016	grade_12	17	1	43	2	0	0	32	31	63	17	1	43	2	0	0	32	31	63
835492	CO	school	10	MAPLETON 1	187	MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS	2016	grade_7	32	2	85	1	2	3	50	75	125	32	2	85	1	2	3	50	75	125
835493	CO	school	10	MAPLETON 1	187	MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS	2016	grade_8	32	2	88	0	1	2	64	61	125	32	2	88	0	1	2	64	61	125
835496	CO	school	10	MAPLETON 1	212	MAPLETON EARLY COLLEGE HIGH SCHOOL	2016	grade_10	15	1	44	0	0	2	37	25	62	15	1	44	0	0	2	37	25	62
835497	CO	school	10	MAPLETON 1	212	MAPLETON EARLY COLLEGE HIGH SCHOOL	2016	grade_11	19	1	42	0	0	1	31	32	63	19	1	42	0	0	1	31	32	63
835498	CO	school	10	MAPLETON 1	212	MAPLETON EARLY COLLEGE HIGH SCHOOL	2016	grade_12	12	2	44	1	2	1	23	39	62	12	2	44	1	2	1	23	39	62
835499	CO	school	10	MAPLETON 1	212	MAPLETON EARLY COLLEGE HIGH SCHOOL	2016	grade_9	16	1	62	1	0	6	43	43	86	16	1	62	1	0	6	43	43	86
835500	CO	school	10	MAPLETON 1	212	MAPLETON EARLY COLLEGE HIGH SCHOOL	2016	pk_12_total	62	5	192	2	2	10	134	139	273	62	5	192	2	2	10	134	139	273
835501	CO	school	10	MAPLETON 1	263	GLOBAL LEADERSHIP ACADEMY	2016	grade_1	2	0	46	1	0	1	27	23	50	2	0	46	1	0	1	27	23	50
835502	CO	school	10	MAPLETON 1	263	GLOBAL LEADERSHIP ACADEMY	2016	grade_10	4	1	47	0	2	0	29	25	54	4	1	47	0	2	0	29	25	54
835503	CO	school	10	MAPLETON 1	263	GLOBAL LEADERSHIP ACADEMY	2016	grade_11	3	0	38	1	0	1	29	14	43	3	0	38	1	0	1	29	14	43
835504	CO	school	10	MAPLETON 1	263	GLOBAL LEADERSHIP ACADEMY	2016	grade_12	4	1	29	0	0	0	18	16	34	4	1	29	0	0	0	18	16	34
835505	CO	school	10	MAPLETON 1	263	GLOBAL LEADERSHIP ACADEMY	2016	grade_2	3	0	44	0	0	0	25	22	47	3	0	44	0	0	0	25	22	47
835506	CO	school	10	MAPLETON 1	263	GLOBAL LEADERSHIP ACADEMY	2016	grade_3	5	1	35	0	2	0	18	25	43	5	1	35	0	2	0	18	25	43
835507	CO	school	10	MAPLETON 1	263	GLOBAL LEADERSHIP ACADEMY	2016	grade_4	1	2	26	0	0	0	16	13	29	1	2	26	0	0	0	16	13	29
835508	CO	school	10	MAPLETON 1	263	GLOBAL LEADERSHIP ACADEMY	2016	grade_5	1	1	28	0	0	0	15	15	30	1	1	28	0	0	0	15	15	30
835509	CO	school	10	MAPLETON 1	263	GLOBAL LEADERSHIP ACADEMY	2016	grade_6	4	0	26	0	0	0	17	13	30	4	0	26	0	0	0	17	13	30
835510	CO	school	10	MAPLETON 1	263	GLOBAL LEADERSHIP ACADEMY	2016	grade_7	7	1	46	0	0	0	30	24	54	7	1	46	0	0	0	30	24	54
835511	CO	school	10	MAPLETON 1	263	GLOBAL LEADERSHIP ACADEMY	2016	grade_8	3	0	55	0	1	0	26	33	59	3	0	55	0	1	0	26	33	59
835512	CO	school	10	MAPLETON 1	263	GLOBAL LEADERSHIP ACADEMY	2016	grade_9	10	1	69	0	0	0	48	32	80	10	1	69	0	0	0	48	32	80
835513	CO	school	10	MAPLETON 1	263	GLOBAL LEADERSHIP ACADEMY	2016	kindergarten_full_day	4	0	30	0	0	0	17	17	34	4	0	30	0	0	0	17	17	34
835514	CO	school	10	MAPLETON 1	263	GLOBAL LEADERSHIP ACADEMY	2016	pk_12_total	59	8	569	3	5	2	341	305	646	59	8	569	3	5	2	341	305	646
835515	CO	school	10	MAPLETON 1	263	GLOBAL LEADERSHIP ACADEMY	2016	pre_kindergarten	8	0	50	1	0	0	26	33	59	8	0	50	1	0	0	26	33	59
835518	CO	school	10	MAPLETON 1	309	ACADEMY HIGH SCHOOL	2016	grade_12	12	0	66	0	0	1	38	41	79	12	0	66	0	0	1	38	41	79
835519	CO	school	10	MAPLETON 1	309	ACADEMY HIGH SCHOOL	2016	grade_9	14	1	100	3	1	2	73	48	121	14	1	100	3	1	2	73	48	121
835521	CO	school	10	MAPLETON 1	501	MONTEREY COMMUNITY SCHOOL	2016	grade_1	5	0	47	0	0	0	30	22	52	5	0	47	0	0	0	30	22	52
835522	CO	school	10	MAPLETON 1	501	MONTEREY COMMUNITY SCHOOL	2016	grade_2	2	0	42	0	1	1	21	25	46	2	0	42	0	1	1	21	25	46
835523	CO	school	10	MAPLETON 1	501	MONTEREY COMMUNITY SCHOOL	2016	grade_3	5	1	33	0	0	1	17	23	40	5	1	33	0	0	1	17	23	40
835524	CO	school	10	MAPLETON 1	501	MONTEREY COMMUNITY SCHOOL	2016	grade_4	4	1	44	0	1	0	25	25	50	4	1	44	0	1	0	25	25	50
835525	CO	school	10	MAPLETON 1	501	MONTEREY COMMUNITY SCHOOL	2016	grade_5	4	0	38	0	1	0	25	18	43	4	0	38	0	1	0	25	18	43
835526	CO	school	10	MAPLETON 1	501	MONTEREY COMMUNITY SCHOOL	2016	grade_6	9	0	42	0	0	2	27	26	53	9	0	42	0	0	2	27	26	53
835527	CO	school	10	MAPLETON 1	501	MONTEREY COMMUNITY SCHOOL	2016	grade_7	6	1	44	0	0	1	24	28	52	6	1	44	0	0	1	24	28	52
835528	CO	school	10	MAPLETON 1	501	MONTEREY COMMUNITY SCHOOL	2016	grade_8	11	2	36	1	0	0	31	19	50	11	2	36	1	0	0	31	19	50
835529	CO	school	10	MAPLETON 1	501	MONTEREY COMMUNITY SCHOOL	2016	kindergarten_full_day	4	0	37	0	1	0	18	24	42	4	0	37	0	1	0	18	24	42
835530	CO	school	10	MAPLETON 1	501	MONTEREY COMMUNITY SCHOOL	2016	pk_12_total	61	6	408	1	6	6	250	238	488	61	6	408	1	6	6	250	238	488
835531	CO	school	10	MAPLETON 1	501	MONTEREY COMMUNITY SCHOOL	2016	pre_kindergarten	11	1	45	0	2	1	32	28	60	11	1	45	0	2	1	32	28	60
835532	CO	school	10	MAPLETON 1	502	MEADOW COMMUNITY SCHOOL	2016	grade_1	13	1	32	0	1	1	23	25	48	13	1	32	0	1	1	23	25	48
835533	CO	school	10	MAPLETON 1	502	MEADOW COMMUNITY SCHOOL	2016	grade_2	11	2	41	0	3	2	26	33	59	11	2	41	0	3	2	26	33	59
835534	CO	school	10	MAPLETON 1	502	MEADOW COMMUNITY SCHOOL	2016	grade_3	11	0	37	0	1	1	31	19	50	11	0	37	0	1	1	31	19	50
835535	CO	school	10	MAPLETON 1	502	MEADOW COMMUNITY SCHOOL	2016	grade_4	8	2	32	1	2	0	27	18	45	8	2	32	1	2	0	27	18	45
835536	CO	school	10	MAPLETON 1	502	MEADOW COMMUNITY SCHOOL	2016	grade_5	12	1	33	0	0	2	19	29	48	12	1	33	0	0	2	19	29	48
835537	CO	school	10	MAPLETON 1	502	MEADOW COMMUNITY SCHOOL	2016	grade_6	7	0	33	2	2	0	16	28	44	7	0	33	2	2	0	16	28	44
835538	CO	school	10	MAPLETON 1	502	MEADOW COMMUNITY SCHOOL	2016	grade_7	9	2	40	2	0	0	23	30	53	9	2	40	2	0	0	23	30	53
835539	CO	school	10	MAPLETON 1	502	MEADOW COMMUNITY SCHOOL	2016	grade_8	10	2	36	0	1	0	25	24	49	10	2	36	0	1	0	25	24	49
835540	CO	school	10	MAPLETON 1	502	MEADOW COMMUNITY SCHOOL	2016	kindergarten_full_day	13	2	32	0	0	1	28	20	48	13	2	32	0	0	1	28	20	48
835541	CO	school	10	MAPLETON 1	502	MEADOW COMMUNITY SCHOOL	2016	pk_12_total	112	12	358	5	13	8	248	260	508	112	12	358	5	13	8	248	260	508
835542	CO	school	10	MAPLETON 1	502	MEADOW COMMUNITY SCHOOL	2016	pre_kindergarten	18	0	42	0	3	1	30	34	64	18	0	42	0	3	1	30	34	64
835543	CO	school	10	MAPLETON 1	503	YORK INTERNATIONAL	2016	grade_1	9	1	45	0	2	1	28	30	58	9	1	45	0	2	1	28	30	58
835544	CO	school	10	MAPLETON 1	503	YORK INTERNATIONAL	2016	grade_10	12	1	50	0	1	1	26	39	65	12	1	50	0	1	1	26	39	65
835545	CO	school	10	MAPLETON 1	503	YORK INTERNATIONAL	2016	grade_11	7	1	39	0	1	1	24	25	49	7	1	39	0	1	1	24	25	49
835546	CO	school	10	MAPLETON 1	503	YORK INTERNATIONAL	2016	grade_12	12	2	31	0	0	1	20	26	46	12	2	31	0	0	1	20	26	46
835547	CO	school	10	MAPLETON 1	503	YORK INTERNATIONAL	2016	grade_2	6	1	45	1	2	0	30	25	55	6	1	45	1	2	0	30	25	55
835548	CO	school	10	MAPLETON 1	503	YORK INTERNATIONAL	2016	grade_3	6	1	41	0	2	2	28	24	52	6	1	41	0	2	2	28	24	52
835549	CO	school	10	MAPLETON 1	503	YORK INTERNATIONAL	2016	grade_4	11	0	39	0	4	0	31	23	54	11	0	39	0	4	0	31	23	54
835550	CO	school	10	MAPLETON 1	503	YORK INTERNATIONAL	2016	grade_5	7	1	39	1	4	2	27	27	54	7	1	39	1	4	2	27	27	54
835551	CO	school	10	MAPLETON 1	503	YORK INTERNATIONAL	2016	grade_6	14	0	37	0	2	1	23	31	54	14	0	37	0	2	1	23	31	54
835552	CO	school	10	MAPLETON 1	503	YORK INTERNATIONAL	2016	grade_7	7	0	42	0	2	3	29	25	54	7	0	42	0	2	3	29	25	54
835553	CO	school	10	MAPLETON 1	503	YORK INTERNATIONAL	2016	grade_8	7	0	52	0	1	3	30	33	63	7	0	52	0	1	3	30	33	63
835554	CO	school	10	MAPLETON 1	503	YORK INTERNATIONAL	2016	grade_9	11	1	68	0	2	1	46	37	83	11	1	68	0	2	1	46	37	83
835555	CO	school	10	MAPLETON 1	503	YORK INTERNATIONAL	2016	kindergarten_full_day	7	0	37	0	2	1	22	25	47	7	0	37	0	2	1	22	25	47
835556	CO	school	10	MAPLETON 1	503	YORK INTERNATIONAL	2016	pk_12_total	116	9	565	2	25	17	364	370	734	116	9	565	2	25	17	364	370	734
835557	CO	school	10	MAPLETON 1	504	WELBY COMMUNITY SCHOOL	2016	grade_1	3	0	26	0	0	1	17	13	30	3	0	26	0	0	1	17	13	30
835558	CO	school	10	MAPLETON 1	504	WELBY COMMUNITY SCHOOL	2016	grade_2	6	1	28	0	0	0	18	17	35	6	1	28	0	0	0	18	17	35
835559	CO	school	10	MAPLETON 1	504	WELBY COMMUNITY SCHOOL	2016	grade_3	6	1	19	0	0	2	11	17	28	6	1	19	0	0	2	11	17	28
835560	CO	school	10	MAPLETON 1	504	WELBY COMMUNITY SCHOOL	2016	grade_4	4	1	18	0	0	0	11	12	23	4	1	18	0	0	0	11	12	23
835561	CO	school	10	MAPLETON 1	504	WELBY COMMUNITY SCHOOL	2016	grade_5	4	1	18	1	0	0	12	12	24	4	1	18	1	0	0	12	12	24
835562	CO	school	10	MAPLETON 1	504	WELBY COMMUNITY SCHOOL	2016	grade_6	4	1	16	0	0	0	10	11	21	4	1	16	0	0	0	10	11	21
835563	CO	school	10	MAPLETON 1	504	WELBY COMMUNITY SCHOOL	2016	kindergarten_full_day	9	1	28	0	1	0	19	20	39	9	1	28	0	1	0	19	20	39
835566	CO	school	10	MAPLETON 1	505	ACHIEVE ACADEMY	2016	grade_1	9	0	40	0	0	0	28	21	49	9	0	40	0	0	0	28	21	49
835567	CO	school	10	MAPLETON 1	505	ACHIEVE ACADEMY	2016	grade_2	3	0	42	1	1	0	23	24	47	3	0	42	1	1	0	23	24	47
835568	CO	school	10	MAPLETON 1	505	ACHIEVE ACADEMY	2016	grade_3	11	0	38	0	4	2	23	32	55	11	0	38	0	4	2	23	32	55
835569	CO	school	10	MAPLETON 1	505	ACHIEVE ACADEMY	2016	grade_4	10	1	38	0	3	1	28	25	53	10	1	38	0	3	1	28	25	53
835570	CO	school	10	MAPLETON 1	505	ACHIEVE ACADEMY	2016	grade_5	5	0	41	0	4	1	31	20	51	5	0	41	0	4	1	31	20	51
835571	CO	school	10	MAPLETON 1	505	ACHIEVE ACADEMY	2016	grade_6	10	0	37	0	0	1	25	23	48	10	0	37	0	0	1	25	23	48
835572	CO	school	10	MAPLETON 1	505	ACHIEVE ACADEMY	2016	grade_7	8	0	46	0	1	1	28	28	56	8	0	46	0	1	1	28	28	56
835574	CO	school	10	MAPLETON 1	505	ACHIEVE ACADEMY	2016	kindergarten_full_day	4	0	40	0	2	0	23	23	46	4	0	40	0	2	0	23	23	46
835576	CO	school	10	MAPLETON 1	505	ACHIEVE ACADEMY	2016	pre_kindergarten	25	0	34	0	2	1	33	29	62	25	0	34	0	2	1	33	29	62
835579	CO	school	10	MAPLETON 1	506	EXPLORE ELEMENTARY	2016	grade_3	15	1	32	2	0	1	29	22	51	15	1	32	2	0	1	29	22	51
835581	CO	school	10	MAPLETON 1	506	EXPLORE ELEMENTARY	2016	grade_5	16	2	35	1	1	1	28	28	56	16	2	35	1	1	1	28	28	56
835582	CO	school	10	MAPLETON 1	506	EXPLORE ELEMENTARY	2016	grade_6	22	0	33	1	0	0	33	23	56	22	0	33	1	0	0	33	23	56
835583	CO	school	10	MAPLETON 1	506	EXPLORE ELEMENTARY	2016	kindergarten_full_day	19	2	27	1	0	1	30	20	50	19	2	27	1	0	1	30	20	50
835585	CO	school	10	MAPLETON 1	506	EXPLORE ELEMENTARY	2016	pre_kindergarten	11	0	48	0	2	0	38	23	61	11	0	48	0	2	0	38	23	61
835587	CO	school	10	MAPLETON 1	507	ADVENTURE ELEMENTARY	2016	grade_2	4	0	38	0	0	2	21	23	44	4	0	38	0	0	2	21	23	44
835588	CO	school	10	MAPLETON 1	507	ADVENTURE ELEMENTARY	2016	grade_3	9	0	35	1	0	2	20	27	47	9	0	35	1	0	2	20	27	47
835589	CO	school	10	MAPLETON 1	507	ADVENTURE ELEMENTARY	2016	grade_4	3	0	39	0	0	0	21	21	42	3	0	39	0	0	0	21	21	42
835590	CO	school	10	MAPLETON 1	507	ADVENTURE ELEMENTARY	2016	grade_5	3	0	35	1	1	1	25	16	41	3	0	35	1	1	1	25	16	41
835591	CO	school	10	MAPLETON 1	507	ADVENTURE ELEMENTARY	2016	grade_6	6	0	45	0	0	1	24	28	52	6	0	45	0	0	1	24	28	52
835592	CO	school	10	MAPLETON 1	507	ADVENTURE ELEMENTARY	2016	kindergarten_full_day	5	0	39	1	0	2	28	19	47	5	0	39	1	0	2	28	19	47
835594	CO	school	10	MAPLETON 1	507	ADVENTURE ELEMENTARY	2016	pre_kindergarten	12	0	57	0	0	0	34	35	69	12	0	57	0	0	0	34	35	69
835595	CO	school	10	MAPLETON 1	509	CLAYTON PARTNERSHIP SCHOOL	2016	grade_1	9	1	32	0	4	3	29	20	49	9	1	32	0	4	3	29	20	49
835597	CO	school	10	MAPLETON 1	509	CLAYTON PARTNERSHIP SCHOOL	2016	grade_3	10	0	46	0	1	0	28	29	57	10	0	46	0	1	0	28	29	57
835598	CO	school	10	MAPLETON 1	509	CLAYTON PARTNERSHIP SCHOOL	2016	grade_4	8	1	37	0	3	1	22	28	50	8	1	37	0	3	1	22	28	50
835599	CO	school	10	MAPLETON 1	509	CLAYTON PARTNERSHIP SCHOOL	2016	grade_5	10	2	37	0	2	1	27	25	52	10	2	37	0	2	1	27	25	52
835600	CO	school	10	MAPLETON 1	509	CLAYTON PARTNERSHIP SCHOOL	2016	grade_6	14	1	34	0	1	0	25	25	50	14	1	34	0	1	0	25	25	50
835601	CO	school	10	MAPLETON 1	509	CLAYTON PARTNERSHIP SCHOOL	2016	grade_7	12	1	38	0	5	4	32	28	60	12	1	38	0	5	4	32	28	60
835602	CO	school	10	MAPLETON 1	509	CLAYTON PARTNERSHIP SCHOOL	2016	grade_8	8	3	42	1	0	4	26	32	58	8	3	42	1	0	4	26	32	58
835603	CO	school	10	MAPLETON 1	509	CLAYTON PARTNERSHIP SCHOOL	2016	kindergarten_full_day	6	0	30	0	1	1	15	23	38	6	0	30	0	1	1	15	23	38