Alabama's Maintenance of Equity Data Submission

Summary

Alabama's Maintenance of Equity data submission, a workbook whose overview sheet lists the items supplied: lists of the State's high-need and highest-poverty LEAs with the NCES LEA ID, statewide and per-LEA per-pupil amounts of State funds in FY21 and FY22, and a list of the high-poverty schools for which it must maintain equity in FY 2022. Table 1 lists high-need LEAs from high-need percentage to lowest, beginning with Lanett City, i3 Academy and Talladega City. For the Alabama State Department of Education, the FY 2021 sheet shows per pupil funding of 5499.55 on an ADM of 717962.4, and the FY 2022 sheet shows per-pupil State funding of 5568.68 on enrollment of 717988. Further sheets give FY 2021 figures for each high-need LEA and a log of data requests.

Summary drafted by a model from the document's text below and checked by script against that text before publication. It is a navigation aid, not a reading of what the document proves. Where AI is used

Full text

Text extracted from the spreadsheet file: one line per row, cells separated by tabs, each sheet headed by its name. Numbers appear as stored, without the workbook’s formatting.

Sheet: Overview of Submission
Alabama's Maintenance of Equity Data Submission
1. A list of the State's high-need LEAs including NCES LEA/district ID	Item 1
2. The statewide per-pupil amount of State funds provided to all LEAs in the state in FY21	Item 2
3. The statewide per-pupil amount of State funds provided to all LEAs in the state in FY22	Item 3
4. The per pupil-amount of State funds provided to each high-need LEA in the state in FY 2021	Item 4
5. The per pupil-amount of State funds provided to each high-need LEA in the state in FY 2022	Item 5
6. A list of the state's highest-poverty LEAs including NCES LEA/ district ID	Item 6
7. The per-pupil amount of State funding provided for each highest-poverty LEA in FY 2019	Item 7
8. The per-pupil amount of State funding provided for each highest-poverty LEA in FY 2022	Item 8
9. A list of the high-poverty schools in each LEA in the State (including the NCES school ID) for which it must maintain equity in FY 2022.	Item 9

Sheet: Item 1--High-Need
	Table 1. SEA Data
High-Need LEAs
NCES Number	LEAs (from high-need percentage to lowest)*
0101980	Lanett City
0100204	i3 Academy
0103150	Talladega City
0100510	Butler County
0103510	Wilcox County
0102250	Marengo County
0100201	Legacy Prep
0102970	Selma City
0100840	Colbert County
0102730	Pickens County
0102160	Lowndes County
0102350	Midfield City
0101230	Dothan City
0101620	Gadsden City
0103180	Talladega County
0101440	Fairfield City
0100203	LEAD Academy
0102670	Perry County
0101710	Hale County
0102820	Randolph County
0100090	Anniston City
0102910	Russellville City
0101080	Daleville City
0102700	Phenix City
0101110	Dallas County
0102580	Opelika City
0103090	Sumter County
0100300	Barbour County
0102640	Ozark City
0100480	Bullock County
0103300	Thomasville City
0100660	Chilton County
0100180	Attalla City
0100012	Boaz City
0101680	Greene County
0100330	Bessemer City
0103330	Troy City
0102130	Linden City
0100750	Clay County
0101660	Geneva County
0101920	Jefferson County
0100030	Alexander City
0103210	Tallapoosa County
0100390	Birmingham City
0100188	Chickasaw City
0102760	Piedmont City
0101560	Fort Payne City
0100630	Cherokee County
0101470	Fayette County
0102190	Macon County
0100540	Calhoun County
0100360	Bibb County
0100006	Marshall County
0103450	Walker County
0101950	Lamar County
0101260	Elba City
0100930	Covington County
0103480	Washington County
0101720	Haleyville City
0101050	Dale County
0101020	Cullman County
0100197	Acceleration Day and Evening Academy
0102610	Opp City
0100690	Choctaw County
0101140	DeKalb County
0100810	Coffee County
0101170	Decatur City
0101200	Demopolis City
0100780	Cleburne County
0102400	Monroe County
0101590	Franklin County
0100060	Andalusia City
0102430	Montgomery County
0103120	Sylacauga City
0100420	Blount County
0103240	Tallassee City
0102635	Oxford City
0103420	Tuscumbia City
0102310	Marion County
0103580	Winston County
0102790	Pike County
0103390	Tuscaloosa County
0100199	University Charter School
0102880	Russell County
0102070	Lee County
0102480	Morgan County
0101770	Houston County
0103240	Tallassee City
0103000	Sheffield City
0102370	Mobile County
	* Small Area Income and Poverty Estimates (SAIPE) was available and sed for District of Columbia Public Schools (DCPS) but not charter school LEAs which represent a significant portion of students in DC. Therefore, OSSE used the same methodology to determine percentage share of poverty represented by each LEA used to determine Title I-A eligibility and allocations

Sheet: 3. Data Requests
	Data Needed	Who Has	Available (Y/N)	Delivered (Y/N)	Deliverable Aligned with		Calculations to Show	Methodology
	Enrollment by LEA (FY21 & FY22)	Bonnie & Ryan	Y		1. A list of the State's high-need LEAs including NCES LEA/district ID		Overall State Per-pupil funding in FY21	total state local funding/ total enrollment
	SAIPE Poverty Percentage by LEA				1. A list of the State's high-need LEAs including NCES LEA/district ID		Overall State Per-pupil funding in FY22	total state local funding/ total enrollment
	Total number of LEAs in FY21				2. The statewide per-pupil amount of State funds provided to all LEAs in the state in FY21		Reduction of Per-Pupil funding in FY22/FY21	overall state per-pupil funding in FY21 - overall state per-pupil funding in FY22
	Total number of LEAs in FY22				3. The statewide per-pupil amount of State funds provided to all LEAs in the state in FY22		LEA per-pupil funding	LEA enrollment/ LEA projected funding for x year
	Total of State funds in FY21	Ryan	Y	2021-07-09	2. The statewide per-pupil amount of State funds provided to all LEAs in the state in FY21
	Total of State funding FY22	Ryan	Y	2021-07-09	3. The statewide per-pupil amount of State funds provided to all LEAs in the state in FY22
	Total of State funding FY19	Ryan	Y	2021-07-09	7. The per-pupil amount of State funding provided for each highest-poverty LEA in FY 2019
	LEAs with more than 1000	Bonnie	Y	2021-07-01	9. A list of the high-poverty schools in each LEA in the State (including the NCES school ID) for which it must maintain equity in FY 2022.
	LEAs with only 1 school	Bonnie	Y	2021-07-01	9. A list of the high-poverty schools in each LEA in the State (including the NCES school ID) for which it must maintain equity in FY 2022.
	Schools that have all gradespans in one school	Bonnie	Y	2021-07-01	9. A list of the high-poverty schools in each LEA in the State (including the NCES school ID) for which it must maintain equity in FY 2022.

Sheet: Item 2--PPA FY21
	FY 2021 Foundation Allocation	FY 2021 ADM	FY 2021 Per Pupil Funding
Alabama State Department of Education	3948472587	717962.4	5499.55

Sheet: Item 3--PPA FY22
	FY 2021 Foundation Allocation	FY 2021 ADM	FY 2021 Per Pupil Funding	FY 2022 State Funding	FY 2022 Enrollment	FY 2022 Per-Pupil State Funding
Alabama State Department of Education	3948472587	717962.4	5499.55	3998246561	717988	5568.68
				Note: All FY22 data is based on projections
clb	system	NCESID	ADM - FY 2021	Foundation Allocation - FY 2021	Per Pupil	ADM - FY 2022	Foundation Allocation - FY 2022	Per Pupil
1	Autauga County	100240	8773.5	48287155	5504	8827.05	48380445	5481
2	Baldwin County	100270	29554.95	144906987	4903	30752.7	143707668	4673
3	Barbour County	100300	646.7	2990560	4624	694.15	3148181	4535
4	Bibb County	100360	3052.15	19371462	6347	2938.05	19028125	6476
5	Blount County	100420	7612.05	44501693	5846	7435.35	46104088	6201
6	Bullock County	100480	1386.5	8358327	6028	1382.5	8552322	6186
7	Butler County	100510	2825.3	15824613	5601	2762.35	16333086	5913
8	Calhoun County	100540	7817.05	47869517	6124	7743.95	46950255	6063
9	Chambers County	100600	3259.7	18213201	5587	3160.6	17905134	5665
10	Cherokee County	100630	3686.15	21398029	5805	3733.75	21770064	5831
11	Chilton County	100660	7396.95	42280015	5716	7348.05	42414794	5772
12	Choctaw County	100690	1070.75	5197308	4854	1012.9	4797483	4736
13	Clarke County	100720	2230.8	12648077	5670	2160.25	12591443	5829
14	Clay County	100750	1794.95	11049112	6156	1791.65	10887222	6077
15	Cleburne County	100780	2436.1	15171092	6228	2378.45	15557774	6541
16	Coffee County	100810	2569.95	14301358	5565	2656.95	14818444	5577
17	Colbert County	100840	2498.65	13027470	5214	2472.8	12870021	5205
18	Conecuh County	100870	1579.85	10874621	6883	1372.6	10914693	7952
19	Coosa County	100900	780.25	3862209	4950	770.9	3490914	4528
20	Covington County	100930	2755.1	16313072	5921	2791.1	16030086	5743
21	Crenshaw County	100960	2140.15	12271200	5734	2150.35	12506595	5816
22	Cullman County	101020	9185.05	53858883	5864	9337.55	56013578	5999
23	Dale County	101050	3381.4	20284382	5999	3143.3	20742021	6599
24	Dallas County	101110	2738.3	17498036	6390	2507.45	16438096	6556
25	DeKalb County	101140	8332.75	51464102	6176	8307.05	50838253	6120
26	Elmore County	101290	11495.6	61453074	5346	11336.65	62566694	5519
27	Escambia County	101350	4074.35	22246006	5460	4029.45	22737268	5643
28	Etowah County	101380	8269.55	49850028	6028	8277.3	50518377	6103
29	Fayette County	101470	2126	12654895	5952	2087.95	12711931	6088
30	Franklin County	101590	3490.65	21554420	6175	3465.6	21604943	6234
31	Geneva County	101660	2538.85	15723305	6193	2615.25	15811378	6046
32	Greene County	101680	913.05	5006997	5484	889.25	5070540	5702
33	Hale County	101710	2270.95	13669194	6019	2202.2	13840220	6285
34	Henry County	101740	2399.95	14232613	5930	2386.45	14434642	6049
35	Houston County	101770	6177.6	33410070	5408	6394.85	33779840	5282
36	Jackson County	101830	4971.1	28374604	5708	4876.3	28412760	5827
37	Jefferson County	101920	34576.1	193459257	5595	34875	190658014	5467
38	Lamar County	101950	2190.55	13160486	6008	2112.35	13397922	6343
39	Lauderdale County	102010	7678.15	43959686	5725	7715.9	44638818	5785
40	Lawrence County	102040	4599.7	26815098	5830	4572.8	28133829	6152
41	Lee County	102070	9065.7	50723328	5595	8940.65	51299615	5738
42	Limestone County	102100	12638.25	63916459	5057	14580.7	74735958	5126
43	Lowndes County	102160	1306.05	7625627	5839	1154.9	7774928	6732
44	Macon County	102190	1897.15	11519743	6072	1783.7	12225268	6854
45	Madison County	102220	18753.7	105780375	5641	19108.26	107543979	5628
46	Marengo County	102250	912.15	5135982	5631	910.35	5051127	5549
47	Marion County	102310	3190.85	18585384	5825	3252.6	19091579	5870
48	Marshall County	100006	5528.45	32356456	5853	5570.25	32718895	5874
49	Mobile County	102370	51299.75	273470885	5331	49923.3	271075447	5430
50	Monroe County	102400	3056.6	17585517	5753	3036.25	17024992	5607
51	Montgomery County	102430	27503.9	147258770	5354	26381.55	151431750	5740
52	Morgan County	102480	7271.7	38822076	5339	7256.5	39338372	5421
53	Perry County	102670	1123.15	6455816	5748	1030.65	6600603	6404
54	Pickens County	102730	2311.45	14345659	6206	2279.65	13985000	6135
55	Pike County	102790	2102.3	12345885	5873	2062.4	12438155	6031
56	Randolph County	102820	1987	11668672	5873	1954.35	11344346	5805
57	Russell County	102880	3396.95	18768350	5525	3550	18939223	5335
58	Saint Clair County	103062	9151.9	52636129	5751	9349.6	53608288	5734
59	Shelby County	103030	20438.55	111255519	5443	20839.5	110558846	5305
60	Sumter County	103090	1138.25	6372522	5599	1035.9	6527235	6301
61	Talladega County	103180	6827.3	37108153	5435	6749.15	35575127	5271
62	Tallapoosa County	103210	2684.55	12798311	4767	2703.05	12516078	4630
63	Tuscaloosa County	103390	18165.45	100212503	5517	18273.8	98551595	5393
64	Walker County	103450	6938.7	40211377	5795	6753.35	40231268	5957
65	Washington County	103480	2520.75	12946856	5136	2466.1	13642468	5532
66	Wilcox County	103510	1324.1	7795244	5887	1211.75	7385171	6095
67	Winston County	103580	2186.95	12819596	5862	2200.75	13136865	5969
101	Albertville City	100005	5722.85	32123354	5613	5774.15	33314692	5770
102	Alexander City	100030	2853.45	15921063	5580	2826.55	15614790	5524
103	Alabaster City	100190	6076.5	34303316	5645	6210.65	34347674	5530
104	Andalusia City	100060	1724.2	9813128	5691	1759.05	9916550	5637
105	Anniston City	100090	1738.75	8726387	5019	1750.55	9881688	5645
106	Arab City	100100	2509.7	15181987	6049	2510.1	15164795	6042
107	Athens City	100120	4533.25	25844311	5701	4619.65	26573043	5752
109	Attalla City	100180	1440.35	9011232	6256	1449.3	9036457	6235
110	Auburn City	100210	8953.55	44421650	4961	9245.3	45512228	4923
113	Bessemer City	100330	3229.1	18483155	5724	3290.75	17113648	5201
114	Birmingham City	100390	20818.75	110772236	5321	20001.66	105302023	5265
115	Boaz City	100012	2337.45	13842471	5922	2332.95	14270001	6117
116	Brewton City	100450	1145.4	6800326	5937	1159.8	7012966	6047
121	Chickasaw City	100188	2691.3	7479273	2779	2491.35	15818104	6349
125	Cullman City	100990	3163.4	16302784	5154	3170.25	16864220	5320
126	Daleville City	101080	1084.85	6150070	5669	1127.3	6545338	5806
127	Decatur City	101170	8520.35	46048271	5405	8289.98	46899335	5657
128	Demopolis City	101200	2052.95	12546738	6112	2019.9	12425159	6151
130	Dothan City	101230	8049.6	43562792	5412	7798.9	41597399	5334
131	Elba City	101260	612.3	3728277	6089	602.4	3878267	6438
132	Enterprise City	101320	6531.35	38000866	5818	6397.7	37969715	5935
133	Eufaula City	101410	6375.65	31325122	4913	6372.55	36425145	5716
137	Fairfield City	101440	1534.15	9784294	6378	1511.3	9186923	6079
141	Florence City	101530	4476.75	24302245	5429	4529.5	24723734	5458
143	Fort Payne City	101560	3353.5	18224242	5434	3347.25	19776344	5908
144	Gadsden City	101620	4824.95	28270859	5859	4684.95	27960759	5968
146	Geneva City	101640	1231.9	7714999	6263	1197.5	7812711	6524
152	Gulf Shores City	100202	2156.3	6639694	3079	2254.35	5951138	2640
154	Guntersville City	101690	1767.8	9961801	5635	1800.79	9840380	5464
155	Haleyville City	101720	1573.9	9463688	6013	1572.9	9609492	6109
156	Hartselle City	101730	3412.2	20474243	6000	3444.75	21183073	6149
157	Homewood City	101760	4177.15	19526132	4675	4204.7	19981039	4752
158	Hoover City	100007	13430.35	66955694	4985	13299.25	65008983	4888
159	Huntsville City	101800	22869.25	115310106	5042	23013.15	113986590	4953
162	Jacksonville City	101860	1620.95	9163671	5653	1641.15	9674201	5895
163	Jasper City	101890	2557.6	14784959	5781	2519.05	14311317	5681
165	Lanett City	101980	943.15	5580250	5917	925.15	5866087	6341
167	Leeds City	100011	1951.65	10936328	5604	2022.45	11400310	5637
168	Linden City	102130	478.4	3140419	6564	423.75	3312362	7817
169	Madison City	100008	11512.95	61693198	5359	11888.05	63744839	5362
171	Midfield City	102350	1013.4	6109338	6029	995.1	6315048	6346
175	Mountain Brook City	102490	4375.6	20897759	4776	4300.05	21823114	5075
176	Muscle Shoals City	102520	2771.5	16197677	5844	2789.4	16448066	5897
177	Pelham City	100194	3401.55	16562114	4869	3440.5	17184017	4995
178	Oneonta City	102550	1429.15	8663571	6062	1414.65	8674517	6132
179	Opelika City	102580	4688.3	23757924	5067	4867.3	24549408	5044
180	Opp City	102610	1227.95	7612844	6200	1208	7752174	6417
181	Oxford City	102635	4050.1	21961713	5423	4004.7	22296631	5568
182	Ozark City	102640	1947	11803754	6063	2025.3	11606699	5731
183	Pell City	102650	3942.55	23294278	5908	3989.05	22993306	5764
184	Phenix City	102700	7073.6	42486633	6006	7005.6	42819512	6112
185	Piedmont City	102760	1096.4	6577761	5999	1067.45	7144969	6693
186	Pike Road City	100195	2407.15	11627294	4830	2592.05	13404636	5171
187	Saraland City	100185	3117.55	17870299	5732	3195.4	17981180	5627
188	Roanoke City	102850	1394.5	8432448	6047	1366.9	8637177	6319
189	Russellville City	102910	2442.05	14956940	6125	2442.9	15062339	6166
190	Scottsboro City	102940	2388.3	13734370	5751	2414.65	13928390	5768
191	Selma City	102970	2674.2	16409141	6136	2295.9	16169356	7043
192	Sheffield City	103000	979.1	5688829	5810	968.8	5744020	5929
193	Sylacauga City	103120	2011	11265028	5602	2010.25	11601797	5771
194	Talladega City	103150	1803.55	11137943	6176	1699.05	11044885	6501
195	Tallassee City	103240	1614.45	9584462	5937	1539.05	9978672	6484
196	Satsuma City	100189	1481.35	9136148	6167	1482.65	8829147	5955
197	Tarrant City	103270	1183.6	7454015	6298	1257.45	7185658	5714
198	Thomasville City	103300	1064.4	6608456	6209	1038.2	6708634	6462
199	Troy City	103330	1645.6	9247811	5620	1638.1	8860803	5409
200	Tuscaloosa City	103360	10275.6	50334040	4898	10199.7	51395362	5039
201	Tuscumbia City	103420	1429.75	8725792	6103	1400.75	8993773	6421
202	Vestavia Hills City	103430	7027.65	36967013	5260	7026.05	37853794	5388
204	Winfield City	103540	1242	7560583	6087	1203.95	8010940	6654
205	Trussville City	100013	4802.05	25433735	5296	4873.75	25992095	5333
800	Accel Academy	100197	328.55	2028574	6174	446.3	3173766	7111
801	University Charter School	100199	478	2658594	5562	530.65	3597148	6779
802	Lead Academy	100203	453.15	2207578	4872	545.8	3231379	5920
803	Legacy Prep	100201	252.7	981497	3884	350.55	2008308	5729
805	I3 Academy	100204	412.3	2896167	7024	514.4	3313118	6441
807	LIFE Academy	100207			#DIV/0!	208.15	2008644	9650
808	Breakthrough Charter School	100208			#DIV/0!	126.94	1891915	14904
810	Magic City Acceptance Academy	100211			#DIV/0!	203.7	1758506	8633

Sheet: Item 4--FY21PPA High-Need LEA
PPA High-Need LEAs FY 2021
NCES Number	LEAs	FY 2021	FY 2021 Foundation Allocation	PPE
0100300	Barbour County	646.7	2990560	4624.33895160043
0100360	Bibb County	3052.15	19371462	6346.82502498239
0100420	Blount County	7612.05	44501693	5846.21659080011
0100480	Bullock County	1386.5	8358327	6028.36422646953
0100510	Butler County	2825.3	15824613	5601.03811984568
0100540	Calhoun County	7817.05	47869517	6123.73171464939
0100630	Cherokee County	3686.15	21398029	5804.9805352468
0100660	Chilton County	7396.95	42280015	5715.87140645807
0100690	Choctaw County	1070.75	5197308	4853.89493345786
0100750	Clay County	1794.95	11049112	6155.66561742667
0100780	Cleburne County	2436.1	15171092	6227.6146299413
0100810	Coffee County	2569.95	14301358	5564.8390046499
0100840	Colbert County	2498.65	13027470	5213.80345386509
0100930	Covington County	2755.1	16313072	5921.04533410766
0101020	Cullman County	9185.05	53858883	5863.75501494276
0101050	Dale County	3381.4	20284382	5998.81173478441
0101110	Dallas County	2738.3	17498036	6390.10919183435
0101140	DeKalb County	8332.75	51464102	6176.12456871981
0101470	Fayette County	2126	12654895	5952.44355597366
0101590	Franklin County	3490.65	21554420	6174.90152263905
0101660	Geneva County	2538.85	15723305	6193.08151328357
0101680	Greene County	913.05	5006997	5483.81468703795
0101710	Hale County	2270.95	13669194	6019.15233712763
0101770	Houston County	6177.6	33410070	5408.26048951049
0101920	Jefferson County	34576.1	193459257	5595.17287953239
0101950	Lamar County	2190.55	13160486	6007.84551824884
0102070	Lee County	9065.7	50723328	5595.08124027929
0102160	Lowndes County	1306.05	7625627	5838.6945369626
0102190	Macon County	1897.15	11519743	6072.13082782068
0102250	Marengo County	912.15	5135982	5630.63311955271
0102310	Marion County	3190.85	18585384	5824.58717896485
0100006	Marshall County	5528.45	32356456	5852.71748862701
0102370	Mobile County	51299.75	273470885	5330.84245049927
0102400	Monroe County	3056.6	17585517	5753.29352875744
0102430	Montgomery County	27503.9	147258770	5354.10505419231
0102480	Morgan County	7271.7	38822076	5338.78955402451
0102670	Perry County	1123.15	6455816	5747.95530427815
0102730	Pickens County	2311.45	14345659	6206.34623288412
0102790	Pike County	2102.3	12345885	5872.56100461399
0102820	Randolph County	1987	11668672	5872.50729743332
0102880	Russell County	3396.95	18768350	5525.05924432211
0103090	Sumter County	1138.25	6372522	5598.52580716011
0103180	Talladega County	6827.3	37108153	5435.26035182283
0103210	Tallapoosa County	2684.55	12798311	4767.39528040081
0103390	Tuscaloosa County	18165.45	100212503	5516.65403279302
0103450	Walker County	6938.7	40211377	5795.23210399643
0103480	Washington County	2520.75	12946856	5136.11266488148
0103510	Wilcox County	1324.1	7795244	5887.20187297032
0103580	Winston County	2186.95	12819596	5861.86058208921
0100030	Alexander City	2853.45	15921063	5579.58366188298
0100060	Andalusia City	1724.2	9813128	5691.40934926343
0100090	Anniston City	1738.75	8726387	5018.77038102085
0100180	Attalla City	1440.35	9011232	6256.27937654042
0100330	Bessemer City	3229.1	18483155	5723.93391347434
0100390	Birmingham City	20818.75	110772236	5320.79188231762
0100012	Boaz City	2337.45	13842471	5922.03940191234
0100188	Chickasaw City	2691.3	7479273	2779.05584661688
0101080	Daleville City	1084.85	6150070	5669.05102087846
0101170	Decatur City	8520.35	46048271	5404.50462715733
0101200	Demopolis City	2052.95	12546738	6111.56530845856
0101230	Dothan City	8049.6	43562792	5411.79586563307
0101260	Elba City	612.3	3728277	6088.97109260167
0101440	Fairfield City	1534.15	9784294	6377.66450477463
0101560	Fort Payne City	3353.5	18224242	5434.39451319517
0101620	Gadsden City	4824.95	28270859	5859.30610679903
0101720	Haleyville City	1573.9	9463688	6012.89027257132
0101980	Lanett City	943.15	5580250	5916.60923501034
0102130	Linden City	478.4	3140419	6564.42098662207
0102350	Midfield City	1013.4	6109338	6028.55535820012
0102580	Opelika City	4688.3	23757924	5067.49226798626
0102610	Opp City	1227.95	7612844	6199.63679302903
0102635	Oxford City	4050.1	21961713	5422.51129601738
0102640	Ozark City	1947	11803754	6062.53415511043
0102700	Phenix City	7073.6	42486633	6006.36634811129
0102760	Piedmont City	1096.4	6577761	5999.41718350967
0102910	Russellville City	2442.05	14956940	6124.74765053951
0102970	Selma City	2674.2	16409141	6136.0934111136
0103000	Sheffield City	979.1	5688829	5810.26350730262
0103120	Sylacauga City	2011	11265028	5601.70462456489
0103150	Talladega City	1803.55	11137943	6175.56652158243
0103240	Tallassee City	1614.45	9584462	5936.67317042956
0103300	Thomasville City	1064.4	6608456	6208.62081924089
0103330	Troy City	1645.6	9247811	5619.71985901799
0103420	Tuscumbia City	1429.75	8725792	6103.01940898758
0100197	Accel Academy	328.55	2028574	6174.32354283975
0100199	University Charter School	478	2658594	5561.91213389121
0100203	Lead Academy	453.15	2207578	4871.62749641399
0100201	Legacy Prep	252.7	981497	3884.04036406807
0100204	I3 Academy	412.3	2896167	7024.41668687849

Sheet: Item 5--FY22PPA High-Need
PPA High-Need LEAs FY 2022
NCES Number	LEAs	FY 2022	FY 2022 Foundation Allocation	PPE
0100300	Barbour County	694.15	3148181	4535.3036087301
0100360	Bibb County	2938.05	19028125	6476.4469631218
0100420	Blount County	7435.35	46104088	6200.66143490219
0100480	Bullock County	1382.5	8552322	6186.12802893309
0100510	Butler County	2762.35	16333086	5912.75037558601
0100540	Calhoun County	7743.95	46950255	6062.83033852233
0100630	Cherokee County	3733.75	21770064	5830.61640441915
0100660	Chilton County	7348.05	42414794	5772.25168582141
0100690	Choctaw County	1012.9	4797483	4736.38365090335
0100750	Clay County	1791.65	10887222	6076.64555019116
0100780	Cleburne County	2378.45	15557774	6541.13981794866
0100810	Coffee County	2656.95	14818444	5577.23856301398
0100840	Colbert County	2472.8	12870021	5204.63482691685
0100930	Covington County	2791.1	16030086	5743.28615957866
0101020	Cullman County	9337.55	56013578	5998.74463858293
0101050	Dale County	3143.3	20742021	6598.80412305539
0101110	Dallas County	2507.45	16438096	6555.70240682765
0101140	DeKalb County	8307.05	50838253	6119.89250094799
0101470	Fayette County	2087.95	12711931	6088.23535046337
0101590	Franklin County	3465.6	21604943	6234.11328485688
0101660	Geneva County	2615.25	15811378	6045.83806519453
0101680	Greene County	889.25	5070540	5702.04104582513
0101710	Hale County	2202.2	13840220	6284.72436654255
0101770	Houston County	6394.85	33779840	5282.35064153186
0101920	Jefferson County	34875	190658014	5466.89645878136
0101950	Lamar County	2112.35	13397922	6342.66196416314
0102070	Lee County	8940.65	51299615	5737.79479120646
0102160	Lowndes County	1154.9	7774928	6732.12226166768
0102190	Macon County	1783.7	12225268	6853.88125805909
0102250	Marengo County	910.35	5051127	5548.55495139232
0102310	Marion County	3252.6	19091579	5869.63629096723
0100006	Marshall County	5570.25	32718895	5873.86472779498
0102370	Mobile County	49923.3	271075447	5429.83831197056
0102400	Monroe County	3036.25	17024992	5607.24314532729
0102430	Montgomery County	26381.55	151431750	5740.06265742536
0102480	Morgan County	7256.5	39338372	5421.12202852615
0102670	Perry County	1030.65	6600603	6404.31087177994
0102730	Pickens County	2279.65	13985000	6134.71366218498
0102790	Pike County	2062.4	12438155	6030.91301396431
0102820	Randolph County	1954.35	11344346	5804.66446644664
0102880	Russell County	3550	18939223	5334.9923943662
0103090	Sumter County	1035.9	6527235	6301.02809151462
0103180	Talladega County	6749.15	35575127	5271.05294740819
0103210	Tallapoosa County	2703.05	12516078	4630.35385952905
0103390	Tuscaloosa County	18273.8	98551595	5393.05426348105
0103450	Walker County	6753.35	40231268	5957.23130002147
0103480	Washington County	2466.1	13642468	5532.00113539597
0103510	Wilcox County	1211.75	7385171	6094.63255622034
0103580	Winston County	2200.75	13136865	5969.26729524026
0100030	Alexander City	2826.55	15614790	5524.32824467991
0100060	Andalusia City	1759.05	9916550	5637.4463488815
0100090	Anniston City	1750.55	9881688	5644.90474422324
0100180	Attalla City	1449.3	9036457	6235.04933416132
0100330	Bessemer City	3290.75	17113648	5200.53118589987
0100390	Birmingham City	20001.66	105302023	5264.66418287282
0100012	Boaz City	2332.95	14270001	6116.71960393493
0100188	Chickasaw City	2491.35	15818104	6349.20986613683
0101080	Daleville City	1127.3	6545338	5806.20775303823
0101170	Decatur City	8289.98	46899335	5657.35200808687
0101200	Demopolis City	2019.9	12425159	6151.37333531363
0101230	Dothan City	7798.9	41597399	5333.75206759928
0101260	Elba City	602.4	3878267	6438.02622841966
0101440	Fairfield City	1511.3	9186923	6078.82154436578
0101560	Fort Payne City	3347.25	19776344	5908.23631339159
0101620	Gadsden City	4684.95	27960759	5968.20862549227
0101720	Haleyville City	1572.9	9609492	6109.41064276178
0101980	Lanett City	925.15	5866087	6340.6874560882
0102130	Linden City	423.75	3312362	7816.78348082596
0102350	Midfield City	995.1	6315048	6346.14410611999
0102580	Opelika City	4867.3	24549408	5043.74252665749
0102610	Opp City	1208	7752174	6417.36258278146
0102635	Oxford City	4004.7	22296631	5567.61580143332
0102640	Ozark City	2025.3	11606699	5730.85419444033
0102700	Phenix City	7005.6	42819512	6112.18339614023
0102760	Piedmont City	1067.45	7144969	6693.49290364888
0102910	Russellville City	2442.9	15062339	6165.76159482582
0102970	Selma City	2295.9	16169356	7042.70917722897
0103000	Sheffield City	968.8	5744020	5929.00495458299
0103120	Sylacauga City	2010.25	11601797	5771.32048252705
0103150	Talladega City	1699.05	11044885	6500.6238780495
0103240	Tallassee City	1539.05	9978672	6483.65680127351
0103300	Thomasville City	1038.2	6708634	6461.79348873049
0103330	Troy City	1638.1	8860803	5409.19540931567
0103420	Tuscumbia City	1400.75	8993773	6420.68391932893
0100197	Accel Academy	446.3	3173766	7111.28388976025
0100199	University Charter School	530.65	3597148	6778.75812682559
0100203	Lead Academy	545.8	3231379	5920.44521802858
0100201	Legacy Prep	350.55	2008308	5729.02011125374
0100204	I3 Academy	514.4	3313118	6440.74261275272

Sheet: Item 6--Highest-Poverty LEAs
Highest-Poverty LEAs
NCES Number	LEAs (from high-need percentage to lowest)*
0101980	Lanett City
0100204	i3 Academy
0103150	Talladega City
0100510	Butler County
0103510	Wilcox County
0102250	Marengo County
0100201	Legacy Prep
0102970	Selma City
0100840	Colbert County
0102730	Pickens County
0102160	Lowndes County
0102350	Midfield City
0101230	Dothan City
0101620	Gadsden City
0103180	Talladega County
0101440	Fairfield City
0100203	LEAD Academy
0102670	Perry County
0101710	Hale County
0102820	Randolph County
0100090	Anniston City
0102910	Russellville City
0101080	Daleville City
0102700	Phenix City
0101110	Dallas County
0102580	Opelika City
0103090	Sumter County
0100300	Barbour County
0102640	Ozark City
0100480	Bullock County
0103300	Thomasville City
0100660	Chilton County
0100180	Attalla City
0100012	Boaz City
0101680	Greene County
0100330	Bessemer City
0103330	Troy City
0102130	Linden City
0100750	Clay County
0101660	Geneva County
0101920	Jefferson County
0100030	Alexander City
0103210	Tallapoosa County
0100390	Birmingham City

Sheet: Item 7--FY19PPA Highest-Poverty
PPA Highest-Poverty LEAs FY 2019
clb	system	NCESID	ADM  - FY 2019	Foundation Allocation - FY 2019	Per Pupil
003	Barbour County	0100300	722.4	3751675	5193.34856035437
006	Bullock County	0100480	1397.9	8128924	5815.09693111095
007	Butler County	0100510	2850.9	15360467	5387.93609035743
011	Chilton County	0100660	7585.45	36649167	4831.50861188196
014	Clay County	0100750	1841.3	10644400	5780.91565741596
017	Colbert County	0100840	2523.6	12708306	5035.78459343795
024	Dallas County	0101110	3042.2	17833399	5862.0074288344
031	Geneva County	0101660	2640.7	14907841	5645.41257999773
032	Greene County	0101680	1015.8	5312669	5230.0344556015
033	Hale County	0101710	2398.85	13942820	5812.29339058299
037	Jefferson County	0101920	35823.05	184615032	5153.52634686326
043	Lowndes County	0102160	1391.85	8565250	6153.8599705428
046	Marengo County	0102250	958.2	5150272	5374.94468795658
053	Perry County	0102670	1257.3	7048242	5605.85540443808
054	Pickens County	0102730	2465.35	14271304	5788.75372665139
056	Randolph County	0102820	2088	10896324	5218.54597701149
060	Sumter County	0103090	1307.3	8136352	6223.78337030521
061	Talladega County	0103180	7227.65	36774256	5087.99623667444
062	Tallapoosa County	0103210	2783.7	12798409	4597.62510327981
066	Wilcox County	0103510	1489.35	8326249	5590.52539698526
102	Alexander City	0100030	2975.65	15380836	5168.89956816158
105	Anniston City	0100090	1910.2	9106521	4767.31284682232
109	Attalla City	0100180	1553.95	9145365	5885.23762025805
113	Bessemer City	0100330	3572.15	18067847	5057.97544895931
114	Birmingham City	0100390	22511.3	113383055	5036.71733751494
115	Boaz City	0100012	2338.75	13073928	5590.13490112239
126	Daleville City	0101080	1050.35	5103864	4859.2031227686
130	Dothan City	0101230	9011.4	45663225	5067.27312071376
137	Fairfield City	0101440	1617.55	9731992	6016.50149918086
144	Gadsden City	0101620	5103.4	26629993	5218.08852921582
165	Lanett City	0101980	895.45	5058645	5649.27689988274
168	Linden City	0102130	460	2965135	6445.94565217391
171	Midfield City	0102350	1014.8	5970651	5883.57410327158
179	Opelika City	0102580	4637	23160087	4994.62734526634
182	Ozark City	0102640	2061.35	11228720	5447.26514177602
184	Phenix City	0102700	6961.5	38649213	5551.85132514544
189	Russellville City	0102910	2405.2	13683036	5688.93896557459
191	Selma City	0102970	2907.15	17615960	6059.52909206611
194	Talladega City	0103150	1975.05	11282432	5712.47917774234
198	Thomasville City	0103300	1116.55	6320520	5660.75858671802
199	Troy City	0103330	1819.95	9629100	5290.85963900107
802	Lead Academy	0100203			#DIV/0!
803	Legacy Prep	0100201			#DIV/0!
805	I3 Academy	0100204			#DIV/0!

Sheet: Item 8--FY22PPA Highest Poverty
PPA Highest-Poverty LEAs FY 2022
clb	system	NCESID	ADM - FY 2022	Foundation Allocation - FY 2022	Per Pupil
003	Barbour County	0100300	694.15	3148181	4535.3036087301
006	Bullock County	0100480	1382.5	8552322	6186.12802893309
007	Butler County	0100510	2762.35	16333086	5912.75037558601
011	Chilton County	0100660	7348.05	42414794	5772.25168582141
014	Clay County	0100750	1791.65	10887222	6076.64555019116
017	Colbert County	0100840	2472.8	12870021	5204.63482691685
024	Dallas County	0101110	2507.45	16438096	6555.70240682765
031	Geneva County	0101660	2615.25	15811378	6045.83806519453
032	Greene County	0101680	889.25	5070540	5702.04104582513
033	Hale County	0101710	2202.2	13840220	6284.72436654255
037	Jefferson County	0101920	34875	190658014	5466.89645878136
043	Lowndes County	0102160	1154.9	7774928	6732.12226166768
046	Marengo County	0102250	910.35	5051127	5548.55495139232
053	Perry County	0102670	1030.65	6600603	6404.31087177994
054	Pickens County	0102730	2279.65	13985000	6134.71366218498
056	Randolph County	0102820	1954.35	11344346	5804.66446644664
060	Sumter County	0103090	1035.9	6527235	6301.02809151462
061	Talladega County	0103180	6749.15	35575127	5271.05294740819
062	Tallapoosa County	0103210	2703.05	12516078	4630.35385952905
066	Wilcox County	0103510	1211.75	7385171	6094.63255622034
102	Alexander City	0100030	2826.55	15614790	5524.32824467991
105	Anniston City	0100090	1750.55	9881688	5644.90474422324
109	Attalla City	0100180	1449.3	9036457	6235.04933416132
113	Bessemer City	0100330	3290.75	17113648	5200.53118589987
114	Birmingham City	0100390	20001.66	105302023	5264.66418287282
115	Boaz City	0100012	2332.95	14270001	6116.71960393493
126	Daleville City	0101080	1127.3	6545338	5806.20775303823
130	Dothan City	0101230	7798.9	41597399	5333.75206759928
137	Fairfield City	0101440	1511.3	9186923	6078.82154436578
144	Gadsden City	0101620	4684.95	27960759	5968.20862549227
165	Lanett City	0101980	925.15	5866087	6340.6874560882
168	Linden City	0102130	423.75	3312362	7816.78348082596
171	Midfield City	0102350	995.1	6315048	6346.14410611999
179	Opelika City	0102580	4867.3	24549408	5043.74252665749
182	Ozark City	0102640	2025.3	11606699	5730.85419444033
184	Phenix City	0102700	7005.6	42819512	6112.18339614023
189	Russellville City	0102910	2442.9	15062339	6165.76159482582
191	Selma City	0102970	2295.9	16169356	7042.70917722897
194	Talladega City	0103150	1699.05	11044885	6500.6238780495
198	Thomasville City	0103300	1038.2	6708634	6461.79348873049
199	Troy City	0103330	1638.1	8860803	5409.19540931567
802	Lead Academy	0100203	545.8	3231379	5920.44521802858
803	Legacy Prep	0100201	350.55	2008308	5729.02011125374
805	I3 Academy	0100204	514.4	3313118	6440.74261275272

Sheet: Item 9
Highest-Poverty LEAs
NCES Number	LEAs (from high-need percentage to lowest)*
0101980	Lanett City
0100204	i3 Academy
0103150	Talladega City
0100510	Butler County
0103510	Wilcox County
0102250	Marengo County
0100201	Legacy Prep
0102970	Selma City
0100840	Colbert County
0102730	Pickens County
0102160	Lowndes County
0102350	Midfield City
0101230	Dothan City
0101620	Gadsden City
0103180	Talladega County
0101440	Fairfield City
0100203	LEAD Academy
0102670	Perry County
0101710	Hale County
0102820	Randolph County
0100090	Anniston City
0102910	Russellville City
0101080	Daleville City
0102700	Phenix City
0101110	Dallas County
0102580	Opelika City
0103090	Sumter County
0100300	Barbour County
0102640	Ozark City
0100480	Bullock County
0103300	Thomasville City
0100660	Chilton County
0100180	Attalla City
0100012	Boaz City
0101680	Greene County
0100330	Bessemer City
0103330	Troy City
0102130	Linden City
0100750	Clay County
0101660	Geneva County
0101920	Jefferson County
0100030	Alexander City
0103210	Tallapoosa County
0100390	Birmingham City

File and source

File

department-of-education-excel-www-ed-gov-b00c5e3816.xlsx

Size

69,417 bytes

SHA-256

af465a8a3ade79d46db4afe729b75fa0b8bb72e3965a4c9a05cdcd69ec9f9574

Our copy

department-of-education-excel-www-ed-gov-b00c5e3816.xlsx

Original

www.ed.gov