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 district 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	multiracial	male	female	total	white_int	black_int	multiracial_int	male_int	female_int	total_int
2037642	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001372	4820006	ABERDEEN ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	03	2020	kindergarten									100						100
2037643	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001372	4820006	ABERDEEN ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	03	2020	elementary_spec_ed									*
2037644	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001372	4820006	ABERDEEN ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	03	2020	grade_1									*
2037645	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001372	4820006	ABERDEEN ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	03	2020	grade_2									78						78
2037646	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001372	4820006	ABERDEEN ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	03	2020	grade_3									80						80
2037647	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001372	4820006	ABERDEEN ELEMENTARY SCHOOL	Regular School	No	Elementary	KG	03	2020	pk_12_total	*	315			*	*	186.0	147.0	333		315		186	147	333
2037648	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036000009	4820008	ABERDEEN HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9									98						98
2037649	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036000009	4820008	ABERDEEN HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_10									116						116
2037650	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036000009	4820008	ABERDEEN HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_11									*
2037651	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036000009	4820008	ABERDEEN HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12									50						50
2037652	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036000009	4820008	ABERDEEN HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed									*
2037653	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036000009	4820008	ABERDEEN HIGH SCHOOL	Regular School	No	High	09	12	2020	pk_12_total	*	300	*			*	151.0	156.0	307		300		151	156	307
2037654	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001467	4820032	BELLE SHIVERS MIDDLE SCHOOL	Regular School	No	Middle	04	08	2020	elementary_spec_ed									11						11
2037655	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001467	4820032	BELLE SHIVERS MIDDLE SCHOOL	Regular School	No	Middle	04	08	2020	grade_4									79						79
2037656	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001467	4820032	BELLE SHIVERS MIDDLE SCHOOL	Regular School	No	Middle	04	08	2020	grade_5									77						77
2037657	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001467	4820032	BELLE SHIVERS MIDDLE SCHOOL	Regular School	No	Middle	04	08	2020	grade_6									101						101
2037658	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001467	4820032	BELLE SHIVERS MIDDLE SCHOOL	Regular School	No	Middle	04	08	2020	grade_7									106						106
2037659	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001467	4820032	BELLE SHIVERS MIDDLE SCHOOL	Regular School	No	Middle	04	08	2020	grade_8									100						100
2037660	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001467	4820032	BELLE SHIVERS MIDDLE SCHOOL	Regular School	No	Middle	04	08	2020	pk_12_total	14	450			*	*	232.0	242.0	474	14	450		232	242	474
2244131	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001372	4820006	ABERDEEN ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	03	2021	kindergarten									*
2244132	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001372	4820006	ABERDEEN ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	03	2021	elementary_spec_ed									*
2244133	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001372	4820006	ABERDEEN ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	03	2021	grade_1									91						91
2244134	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001372	4820006	ABERDEEN ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	03	2021	grade_2									72						72
2244135	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001372	4820006	ABERDEEN ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	03	2021	grade_3									76						76
2244136	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001372	4820006	ABERDEEN ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	03	2021	pk_12_total	*	291			*	*	169	138	307		291		169	138	307
2244137	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036000009	4820008	ABERDEEN HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_9									100						100
2244138	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036000009	4820008	ABERDEEN HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_10									96						96
2244139	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036000009	4820008	ABERDEEN HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_11									100						100
2244140	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036000009	4820008	ABERDEEN HIGH SCHOOL	Regular School	No	High	09	12	2021	grade_12									*
2244141	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036000009	4820008	ABERDEEN HIGH SCHOOL	Regular School	No	High	09	12	2021	secondary_spec_ed									*
2244142	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036000009	4820008	ABERDEEN HIGH SCHOOL	Regular School	No	High	09	12	2021	pk_12_total	*	331	*		*	*	175	168	343		331		175	168	343
2244143	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001467	4820032	BELLE SHIVERS MIDDLE SCHOOL	Regular School	No	Middle	04	08	2021	elementary_spec_ed									11						11
2244144	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001467	4820032	BELLE SHIVERS MIDDLE SCHOOL	Regular School	No	Middle	04	08	2021	grade_4									79						79
2244145	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001467	4820032	BELLE SHIVERS MIDDLE SCHOOL	Regular School	No	Middle	04	08	2021	grade_5									70						70
2244146	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001467	4820032	BELLE SHIVERS MIDDLE SCHOOL	Regular School	No	Middle	04	08	2021	grade_6									77						77
2244147	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001467	4820032	BELLE SHIVERS MIDDLE SCHOOL	Regular School	No	Middle	04	08	2021	grade_7									95						95
2244148	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001467	4820032	BELLE SHIVERS MIDDLE SCHOOL	Regular School	No	Middle	04	08	2021	grade_8									99						99
2244149	MS	school	2800360	4820	ABERDEEN SCHOOL DIST	280036001467	4820032	BELLE SHIVERS MIDDLE SCHOOL	Regular School	No	Middle	04	08	2021	pk_12_total	*	410			*	12	204	227	431		410	12	204	227	431
2033532	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000017	200002	BIGGERSVILLE ELEMENTARY	Regular School	No	Elementary	PK	06	2020	pre_kindergarten									20						20
2033533	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000017	200002	BIGGERSVILLE ELEMENTARY	Regular School	No	Elementary	PK	06	2020	kindergarten									36						36
2033534	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000017	200002	BIGGERSVILLE ELEMENTARY	Regular School	No	Elementary	PK	06	2020	kindergarten_spec_ed									*
2033535	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000017	200002	BIGGERSVILLE ELEMENTARY	Regular School	No	Elementary	PK	06	2020	elementary_spec_ed									*
2033536	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000017	200002	BIGGERSVILLE ELEMENTARY	Regular School	No	Elementary	PK	06	2020	grade_1									44						44
2033537	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000017	200002	BIGGERSVILLE ELEMENTARY	Regular School	No	Elementary	PK	06	2020	grade_2									32						32
2033538	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000017	200002	BIGGERSVILLE ELEMENTARY	Regular School	No	Elementary	PK	06	2020	grade_3									36						36
2033539	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000017	200002	BIGGERSVILLE ELEMENTARY	Regular School	No	Elementary	PK	06	2020	grade_4									34						34
2033540	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000017	200002	BIGGERSVILLE ELEMENTARY	Regular School	No	Elementary	PK	06	2020	grade_5									42						42
2033541	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000017	200002	BIGGERSVILLE ELEMENTARY	Regular School	No	Elementary	PK	06	2020	grade_6									37						37
2033542	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000017	200002	BIGGERSVILLE ELEMENTARY	Regular School	No	Elementary	PK	06	2020	pk_12_total	217	39			*	*	151.0	133.0	284	217	39		151	133	284
2033543	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001152	200004	BIGGERSVILLE HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_7									36						36
2033544	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001152	200004	BIGGERSVILLE HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_8									29						29
2033545	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001152	200004	BIGGERSVILLE HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_9									41						41
2033546	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001152	200004	BIGGERSVILLE HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_10									27						27
2033547	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001152	200004	BIGGERSVILLE HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_11									33						33
2033548	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001152	200004	BIGGERSVILLE HIGH SCHOOL	Regular School	No	High	07	12	2020	grade_12									*
2033549	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001152	200004	BIGGERSVILLE HIGH SCHOOL	Regular School	No	High	07	12	2020	secondary_spec_ed									*
2033550	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001152	200004	BIGGERSVILLE HIGH SCHOOL	Regular School	No	High	07	12	2020	pk_12_total	144	36	*		*	*	105.0	85.0	190	144	36		105	85	190
2033551	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001150	200006	ALCORN CENTRAL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	pre_kindergarten									60						60
2033552	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001150	200006	ALCORN CENTRAL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	pre_kindergarten_spec_ed									*
2033553	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001150	200006	ALCORN CENTRAL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	kindergarten									89						89
2033554	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001150	200006	ALCORN CENTRAL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	kindergarten_spec_ed									*
2033555	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001150	200006	ALCORN CENTRAL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	elementary_spec_ed									*
2033556	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001150	200006	ALCORN CENTRAL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	grade_1									93						93
2033557	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001150	200006	ALCORN CENTRAL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	grade_2									88						88
2033558	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001150	200006	ALCORN CENTRAL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	grade_3									82						82
2033559	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001150	200006	ALCORN CENTRAL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	grade_4									89						89
2033560	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001150	200006	ALCORN CENTRAL ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	pk_12_total	481	*	*	*	*	16	265.0	247.0	512	481		16	265	247	512
2033561	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000018	200008	ALCORN CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9									105						105
2033562	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000018	200008	ALCORN CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_10									95						95
2033563	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000018	200008	ALCORN CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_11									99						99
2033564	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000018	200008	ALCORN CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12									*
2033565	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000018	200008	ALCORN CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	secondary_spec_ed									*
2033566	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000018	200008	ALCORN CENTRAL HIGH SCHOOL	Regular School	No	High	09	12	2020	pk_12_total	354	*	*	*	*	11	177.0	204.0	381	354		11	177	204	381
2033567	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001188	200010	ALCORN CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	elementary_spec_ed									*
2033568	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001188	200010	ALCORN CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_5									88						88
2033569	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001188	200010	ALCORN CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_6									89						89
2033570	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001188	200010	ALCORN CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_7									106						106
2033571	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001188	200010	ALCORN CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_8									109						109
2033572	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001188	200010	ALCORN CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	secondary_spec_ed									*
2033573	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001188	200010	ALCORN CENTRAL MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	pk_12_total	377	*	*	*		12	226.0	175.0	401	377		12	226	175	401
2033574	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001151	200022	KOSSUTH ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	pre_kindergarten									66						66
2033575	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001151	200022	KOSSUTH ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	pre_kindergarten_spec_ed									*
2033576	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001151	200022	KOSSUTH ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	kindergarten									114						114
2033577	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001151	200022	KOSSUTH ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	kindergarten_spec_ed									*
2033578	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001151	200022	KOSSUTH ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	elementary_spec_ed									16						16
2033579	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001151	200022	KOSSUTH ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	grade_1									104						104
2033580	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001151	200022	KOSSUTH ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	grade_2									72						72
2033581	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001151	200022	KOSSUTH ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	grade_3									106						106
2033582	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001151	200022	KOSSUTH ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	grade_4									97						97
2033583	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001151	200022	KOSSUTH ELEMENTARY SCHOOL	Regular School	No	Elementary	PK	04	2020	pk_12_total	565	*	*			*	296.0	284.0	580	565			296	284	580
2033584	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001566	200023	KOSSUTH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	elementary_spec_ed									*
2033585	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001566	200023	KOSSUTH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_5									97						97
2033586	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001566	200023	KOSSUTH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_6									99						99
2033587	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001566	200023	KOSSUTH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_7									116						116
2033588	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001566	200023	KOSSUTH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	grade_8									122						122
2033589	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001566	200023	KOSSUTH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	secondary_spec_ed									*
2033590	MS	school	2800390	200	ALCORN SCHOOL DIST	280039001566	200023	KOSSUTH MIDDLE SCHOOL	Regular School	No	Middle	05	08	2020	pk_12_total	428	*	*			*	207.0	236.0	443	428			207	236	443
2033591	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000020	200024	KOSSUTH HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_9									101						101
2033592	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000020	200024	KOSSUTH HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_10									*
2033593	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000020	200024	KOSSUTH HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_11									104						104
2033594	MS	school	2800390	200	ALCORN SCHOOL DIST	280039000020	200024	KOSSUTH HIGH SCHOOL	Regular School	No	High	09	12	2020	grade_12									107						107