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 and (district > :p3 or (district = :p3 and rowid > :p2)) order by district, 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	white	black	hispanic	native_american	asian	pacific_islander	multiracial	ell	free_and_reduced	disability	total	white_int	hispanic_int	asian_int	multiracial_int	free_and_reduced_int	disability_int	total_int
3131000	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	grade_1											0							0
3131006	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2020	grade_1											6							6
3144810	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	grade_2											0							0
3144816	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2020	grade_2											6							6
3158620	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	grade_3											0							0
3158626	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2020	grade_3											9							9
3172430	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	grade_4											0							0
3172436	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2020	grade_4											11							11
3186240	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	grade_5											0							0
3186246	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2020	grade_5											8							8
3200050	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	grade_6											0							0
3200056	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2020	grade_6											16							16
3213860	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	grade_7											11							11
3213866	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2020	grade_7											0							0
3227670	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	grade_8											15							15
3227676	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2020	grade_8											0							0
3241480	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	grade_9											17							17
3241486	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2020	grade_9											0							0
3255290	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	grade_10											8							8
3255296	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2020	grade_10											0							0
3269100	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	grade_11											10							10
3269106	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2020	grade_11											0							0
3282910	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	grade_12											18							18
3282916	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2020	grade_12											0							0
3296720	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	k_12_total	73	*	*	*	*	*	6	*	18	15	79	73			6	18	15	79
3296726	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2020	k_12_total	69	*	*	*	*	*	*	*	28	14	70	69				28	14	70
3310530	MO	school	2905790	1092	ADAIR CO. R-II	290579000125	1050	ADAIR CO. HIGH	Regular School	No	High	07	12	2020	pk_12_total											79							79
3310536	MO	school	2905790	1092	ADAIR CO. R-II	290579000124	4020	ADAIR CO. ELEM.	Regular School	No	Elementary	KG	06	2020	pk_12_total											70							70
3103751	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2020	pre_kindergarten											0							0
3103757	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten											29							29
3117561	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2020	kindergarten											0							0
3117567	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2020	kindergarten											56							56
3131371	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2020	grade_1											0							0
3131377	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2020	grade_1											38							38
3145181	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2020	grade_2											0							0
3145187	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2020	grade_2											47							47
3158991	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2020	grade_3											0							0
3158997	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2020	grade_3											52							52
3172801	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2020	grade_4											0							0
3172807	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2020	grade_4											50							50
3186611	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2020	grade_5											0							0
3186617	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2020	grade_5											60							60
3200421	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2020	grade_6											57							57
3200427	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2020	grade_6											0							0
3214231	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2020	grade_7											53							53
3214237	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2020	grade_7											0							0
3228041	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2020	grade_8											56							56
3228047	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2020	grade_8											0							0
3241851	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2020	grade_9											58							58
3241857	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2020	grade_9											0							0
3255661	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2020	grade_10											53							53
3255667	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2020	grade_10											0							0
3269471	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2020	grade_11											55							55
3269477	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2020	grade_11											0							0
3283281	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2020	grade_12											55							55
3283287	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2020	grade_12											0							0
3297091	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2020	k_12_total	369	*	8	*	5	*	*	*	103	23	387	369	8	5		103	23	387
3297097	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2020	k_12_total	296	*	6	*	*	*	*	*	105	41	303	296	6			105	41	303
3310901	MO	school	2902850	7123	ADRIAN R-III	290285000002	1050	ADRIAN SR. HIGH	Regular School	No	High	06	12	2020	pk_12_total											387							387
3310907	MO	school	2902850	7123	ADRIAN R-III	290285000001	4020	ADRIAN ELEM.	Regular School	No	Elementary	PK	05	2020	pk_12_total											332							332
3115224	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2020	pre_kindergarten											0							0
3115230	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	KG	06	2020	pre_kindergarten											0							0
3115232	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten											26							26
3129034	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2020	kindergarten											0							0
3129040	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	KG	06	2020	kindergarten											42							42
3129042	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten											0							0
3142844	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2020	grade_1											0							0
3142850	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	KG	06	2020	grade_1											40							40
3142852	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	grade_1											0							0
3156654	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2020	grade_2											0							0
3156660	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	KG	06	2020	grade_2											43							43
3156662	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	grade_2											0							0
3170464	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2020	grade_3											0							0
3170470	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	KG	06	2020	grade_3											29							29
3170472	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	grade_3											0							0
3184274	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2020	grade_4											0							0
3184280	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	KG	06	2020	grade_4											25							25
3184282	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	grade_4											0							0
3198084	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2020	grade_5											0							0
3198090	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	KG	06	2020	grade_5											31							31
3198092	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	grade_5											0							0
3211894	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2020	grade_6											0							0
3211900	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	KG	06	2020	grade_6											34							34
3211902	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	grade_6											0							0
3225704	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2020	grade_7											33							33
3225710	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	KG	06	2020	grade_7											0							0
3225712	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	grade_7											0							0
3239514	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2020	grade_8											37							37
3239520	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	KG	06	2020	grade_8											0							0
3239522	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	grade_8											0							0
3253324	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2020	grade_9											36							36
3253330	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	KG	06	2020	grade_9											0							0
3253332	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	grade_9											0							0
3267134	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2020	grade_10											26							26
3267140	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	KG	06	2020	grade_10											0							0
3267142	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	grade_10											0							0
3280944	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2020	grade_11											30							30
3280950	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	KG	06	2020	grade_11											0							0
3280952	MO	school	2902880	103129	ADVANCE R-IV	290288003340	7500	ADVANCE PRESCHOOL	Regular School	No	Prekindergarten	PK	PK	2020	grade_11											0							0
3294754	MO	school	2902880	103129	ADVANCE R-IV	290288000004	1050	ADVANCE HIGH	Regular School	No	High	07	12	2020	grade_12											36							36
3294760	MO	school	2902880	103129	ADVANCE R-IV	290288000003	4020	ADVANCE ELEM.	Regular School	No	Elementary	KG	06	2020	grade_12											0							0