Public School Characteristics 2022-23

Department of Education

@usgov.ed_gov_public_school_characteristics_2022_23_451db

Table List

1 table(14.24 MB)

Table 1

@usgov.ed_gov_public_school_characteristics_2022_23_451db.table_1

14.24 MB
101390 rows
77 columns

x X	y Y	objectid OBJECTID	ncessch NCESSCH	survyear SURVYEAR	stabr STABR	leaid LEAID	st_leaid ST LEAID	lea_name LEA NAME	sch_name SCH NAME	lstreet1 LSTREET1	lcity LCITY	lstate LSTATE	lzip LZIP	lzip4 LZIP4	phone PHONE	charter_text CHARTER TEXT	virtual VIRTUAL	gslo GSLO	gshi GSHI	school_level SCHOOL LEVEL	status STATUS	school_type_text SCHOOL TYPE TEXT	sy_status_text SY STATUS TEXT	ulocale ULOCALE	nmcnty NMCNTY	totfrl TOTFRL	frelch FRELCH	redlch REDLCH	directcert DIRECTCERT	pk PK	kg KG	g01 G01	g02 G02	g03 G03	g04 G04	g05 G05	g06 G06	g07 G07	g08 G08	g09 G09	g10 G10	g11 G11	g12 G12	totmenrol TOTMENROL	totfenrol TOTFENROL	total TOTAL	member MEMBER	fte FTE	stuteratio STUTERATIO	amalm AMALM	amalf AMALF	am AM	asalm ASALM	asalf ASALF	as AS	blalm BLALM	blalf BLALF	bl BL	hpalf HPALF	hp HP	hialm HIALM	hialf HIALF	hi HI	tralm TRALM	tralf TRALF	tr TR	whalm WHALM	whalf WHALF	wh WH	latcod LATCOD	loncod LONCOD
-86.2062	34.2602000000001	1	10000500870	2022-2023	AL	100005	AL-101	Albertville City	Albertville Middle School	600 E Alabama Ave	Albertville	AL	35950		(256)878-2341	No	Not Virtual	07	08	Middle	1	Regular School	Currently operational	32-Town: Distant	Marshall County	697	654	43	587									440	450					459	431	890	890	45	19.78	4	1	5	4	2	6	15	14	29	1	1	251	251	502	17	15	32	168	147	315	34.2602	-86.2062
-86.204899999	34.2622000000001	2	10000500871	2022-2023	AL	100005	AL-101	Albertville City	Albertville High School	402 E McCord Ave	Albertville	AL	35950	2322	(256)894-5000	No	Not Virtual	09	12	High	1	Regular School	Currently operational	32-Town: Distant	Marshall County	1254	1178	76	1059											493	442	390	387	868	844	1712	1712	85.1999969482422	20.09		2	2	4	5	9	23	34	57			490	468	958	26	19	45	325	316	641	34.2622	-86.2049
-86.2200999999999	34.2733000000001	3	10000500879	2022-2023	AL	100005	AL-101	Albertville City	Albertville Intermediate School	901 W McKinney Ave	Albertville	AL	35950	1300	(256)878-7698	No	Not Virtual	05	06	Middle	1	Regular School	Currently operational	32-Town: Distant	Marshall County	718	665	53	570							412	462							451	423	874	874	43	20.33	1	4	5	4		4	22	28	50			263	241	504	7	6	13	154	144	298	34.2733	-86.2201
-86.221806	34.2527000000001	4	10000500889	2022-2023	AL	100005	AL-101	Albertville City	Albertville Elementary School	145 West End Drive	Albertville	AL	35950		(256)894-4822	No	Not Virtual	03	04	Elementary	1	Regular School	Currently operational	32-Town: Distant	Marshall County	723	680	43	583					430	444									463	411	874	874	43	20.33		4	4	1	3	4	22	16	38			261	236	497	11	16	27	168	136	304	34.2527	-86.221806
-86.1933	34.2898000000001	5	10000501616	2022-2023	AL	100005	AL-101	Albertville City	Albertville Kindergarten and PreK	257 Country Club Rd	Albertville	AL	35951	3927	(256)878-7922	No	Not Virtual	PK	KG	Elementary	1	Regular School	Currently operational	32-Town: Distant	Marshall County	392	367	25	240	133	473													304	302	606	606	26	23.31	1	3	4	2		2	26	23	49			167	152	319	4	4	8	104	120	224	34.2898	-86.1933
-86.2218	34.2533	6	10000502150	2022-2023	AL	100005	AL-101	Albertville City	Albertville Primary School	1100 Horton Rd	Albertville	AL	35950	2532	(256)878-6611	No	Not Virtual	01	02	Elementary	1	Regular School	Currently operational	32-Town: Distant	Marshall County	779	726	53	617			427	517											498	446	944	944	61	15.48	9	1	10	3		3	24	21	45	1	1	290	256	546	9	10	19	163	157	320	34.2533	-86.2218
-86.254153001	34.5337500000001	7	10000600193	2022-2023	AL	100006	AL-048	Marshall County	Kate Duncan Smith DAR Middle	6077 Main St	Grant	AL	35747		(256)728-5950	No	Not Virtual	05	08	Middle	1	Regular School	Currently operational	42-Rural: Distant	Marshall County	151	123	28	194							95	97	86	86					192	172	364	364	22.0300006866455	16.52	1	3	4				2		2			6	8	14	5	9	14	178	152	330	34.53375	-86.254153
-86.142000001	34.3624999990001	8	10000600872	2022-2023	AL	100006	AL-048	Marshall County	Asbury High School	1990 Asbury Rd	Albertville	AL	35951		(256)878-4068	No	Not Virtual	06	12	High	1	Regular School	Currently operational	42-Rural: Distant	Marshall County	555	501	54	491								104	91	108	103	86	87	85	350	314	664	664	34.2700004577637	19.38	1	1	2	1	1	2	8	3	11	2	2	162	156	318	2	3	5	176	148	324	34.3625	-86.142
-86.2703999999999	34.4069000000001	9	10000600876	2022-2023	AL	100006	AL-048	Marshall County	Claysville School	140 Claysville School Rd	Guntersville	AL	35976		(256)582-4444	No	Not Virtual	PK	PK	Prekindergarten	1	Regular School	Currently operational	41-Rural: Fringe	Marshall County	-1	-1	-1	-1																				-1																					34.4069	-86.2704
-86.3212589999999	34.1762340000001	10	10000600877	2022-2023	AL	100006	AL-048	Marshall County	Douglas Elementary School	Highway 75	Douglas	AL	35964		(256)593-4420	No	Not Virtual	03	05	Elementary	1	Regular School	Currently operational	42-Rural: Distant	Marshall County	245	223	22	316					141	158	162								222	239	461	461	25	18.44	3	3	6				4	5	9	1	1	92	102	194	2	3	5	121	125	246	34.176234	-86.321259


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "ncessch" BIGINT,
  "survyear" VARCHAR,
  "stabr" VARCHAR,
  "leaid" BIGINT,
  "st_leaid" VARCHAR,
  "lea_name" VARCHAR,
  "sch_name" VARCHAR,
  "lstreet1" VARCHAR,
  "lstreet2" VARCHAR,
  "lcity" VARCHAR,
  "lstate" VARCHAR,
  "lzip" BIGINT,
  "lzip4" VARCHAR,
  "phone" VARCHAR,
  "charter_text" VARCHAR,
  "virtual" VARCHAR,
  "gslo" VARCHAR,
  "gshi" VARCHAR,
  "school_level" VARCHAR,
  "status" BIGINT,
  "school_type_text" VARCHAR,
  "sy_status_text" VARCHAR,
  "ulocale" VARCHAR,
  "nmcnty" VARCHAR,
  "totfrl" BIGINT,
  "frelch" BIGINT,
  "redlch" BIGINT,
  "directcert" BIGINT,
  "pk" DOUBLE,
  "kg" DOUBLE,
  "g01" DOUBLE,
  "g02" DOUBLE,
  "g03" DOUBLE,
  "g04" DOUBLE,
  "g05" DOUBLE,
  "g06" DOUBLE,
  "g07" DOUBLE,
  "g08" DOUBLE,
  "g09" DOUBLE,
  "g10" DOUBLE,
  "g11" DOUBLE,
  "g12" DOUBLE,
  "g13" DOUBLE,
  "ug" DOUBLE,
  "ae" DOUBLE,
  "totmenrol" DOUBLE,
  "totfenrol" DOUBLE,
  "total" DOUBLE,
  "member" DOUBLE,
  "fte" DOUBLE,
  "stuteratio" DOUBLE,
  "amalm" DOUBLE,
  "amalf" DOUBLE,
  "am" DOUBLE,
  "asalm" DOUBLE,
  "asalf" DOUBLE,
  "as" DOUBLE,
  "blalm" DOUBLE,
  "blalf" DOUBLE,
  "bl" DOUBLE,
  "hpalm" DOUBLE,
  "hpalf" DOUBLE,
  "hp" DOUBLE,
  "hialm" DOUBLE,
  "hialf" DOUBLE,
  "hi" DOUBLE,
  "tralm" DOUBLE,
  "tralf" DOUBLE,
  "tr" DOUBLE,
  "whalm" DOUBLE,
  "whalf" DOUBLE,
  "wh" DOUBLE,
  "latcod" DOUBLE,
  "loncod" DOUBLE
);