PEO Renewal Transparency Index: plan-level data snapshot (Appendix A, D9) Build date: 2026-10-13T04:13:33Z Paper: PEO Renewal Transparency Index, version 0.6, https://benefitra.com/peo-renewal-transparency-index/ (Data availability). Published with the paper. Rows in peo-plan-level.csv (excluding header): 682 ## Data files (sha256sum) 9f6e50f068c4b154adcb3bf36139e068bd3b81edcc8bf4806bdccfdc0825b946 peo-plan-level.csv ## Build commands (python3 -I) scripts/peo_5500_extract.py data/peo_extract_v2 scripts/peo_5500_supplement.py data/peo_extract_v2 452568460 scripts/peo_sch_h_extract.py data/peo_extract_v2 scripts/peo_plan_level_build.py data/peo_extract_v2 four-scratch/efast2-ack-ids.csv peo-csv/peo-plan-level.csv scripts/peo_plan_level_runs.py peo-csv/peo-plan-level.csv --max-year=2024 ## Scripts (sha256sum) 41b4e4b67a0ac5a55248cfecc92ff40870bfd630254316190dde1502c60c8258 scripts/peo_5500_extract.py eb7c097ab975f5a35a486f7ddaf7003579e6114d010ad2874998127217a26044 scripts/peo_5500_supplement.py 1d56221144876febf283f70673fecfeafc0fa9d9b62c253eac5634ad64819580 scripts/peo_sch_h_extract.py 835077e513009a25e98ee89bf7e67c386c518c2571c64751419645c05f16278b scripts/peo_plan_level_build.py 352a0c79a03ee034a900b95430173f4beb00e162e0385e423ea977d34a553203 scripts/peo_plan_level_runs.py ae176f8f0d7046f58311bf2fb0bd50e6d74864897ce30b11c8e9dbcf03aa3546 scripts/efast2_ack_ids.py ## Intermediate extract (sha256sum) d242e3c90ce67addb27141acc60693e558029440fe2497a6dcfe5cf761e9bb90 peo_extract_v2/filing_status.csv 4fd580775ed0588587f2f20c2e8d39c01e3d0e8c079475c3789c12e8b018ddc8 peo_extract_v2/main.csv 91536d653fd4c7565836f5aad8337b72cd9c80d5ad94b499b7c2b1b5842ee736 peo_extract_v2/main_extra.csv 7e578492fecf941120deb9fef9f670ddcaf4db10cbc4ff5f59f4eef04b6143d1 peo_extract_v2/sch_a.csv 003705f3e47cc88bfacb1740247bbdb27b1dd7285957fd7f1f5eb0c139b13bcd peo_extract_v2/sch_a_extra.csv 9150ebcd6a96279f924aa19941d369cfdf4437242879cdb41aebe55d455bb81e peo_extract_v2/sch_h.csv ## Source files: DOL EBSA Form 5500 bulk datasets (https://www.dol.gov/agencies/ebsa/about-ebsa/our-activities/public-disclosure/foia/form-5500-datasets) # sha256 local file source URL 3a52de8802feb31f3068dd60c1525d7b24d433cf6674e9d8f50a1864f93fe4a1 dol5500/F_5500_2009_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2009/Latest/F_5500_2009_Latest.zip b064b2d781702c2a2860d8c16f520f077474e34f110f82c5e6b299df1962ec53 dol5500/F_5500_2010_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2010/Latest/F_5500_2010_Latest.zip e53840bbe363e5edc959f4b0fc8c31274d113d9d7be6ca2986ceb60a7f8d390c dol5500/F_5500_2011_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2011/Latest/F_5500_2011_Latest.zip 12afa89e095e85d3cbf84da5b55647265ac0e4b9245fbda8d6f36f4b4572feff dol5500/F_5500_2012_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2012/Latest/F_5500_2012_Latest.zip 0ab0afb7a7668056d62472e30e55f4aaae30f13fcb7d4c96f83f4a5bd8ce3914 dol5500/F_5500_2013_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2013/Latest/F_5500_2013_Latest.zip f3534c1342d64fce4fe6f3bee4ac82c219b765b58889919ca9cb60ed0f41b02d dol5500/F_5500_2014_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2014/Latest/F_5500_2014_Latest.zip 5da8a06f323216bd9d16439047a88c9c7a81f38a88b83087c2795f15017580ff dol5500/F_5500_2015_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2015/Latest/F_5500_2015_Latest.zip 2f80c5fb2cdd9a660c6578450b0db23d1742895ea5cd72a06dd563342c929cff dol5500/F_5500_2016_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2016/Latest/F_5500_2016_Latest.zip 13b5bfba4c4560f544541f654a4d242c55811abff9da17934faa671703a89609 dol5500/F_5500_2017_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2017/Latest/F_5500_2017_Latest.zip aada05a2672a4b47a07507359bd72fd3862651f1404fe101e7aeaf3e8fdc231d dol5500/F_5500_2018_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2018/Latest/F_5500_2018_Latest.zip 498d5a5f38ad574df18247286bfd25f5114a770fba9aea32907c4f7f5be96970 dol5500/F_5500_2019_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2019/Latest/F_5500_2019_Latest.zip 07a73493427a6d47fdcda8f8285559b38880791ebd701d122700533ff0708d63 dol5500/F_5500_2020_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2020/Latest/F_5500_2020_Latest.zip a7c7e0197e73120f156cf5b2e8007b732a0eb5a65381d80daff080af74b418ef dol5500/F_5500_2021_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2021/Latest/F_5500_2021_Latest.zip 1d4d05c3236af2f6306a0227a43a6795b48273d5c532058da7f52efa192c80b2 dol5500/F_5500_2022_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2022/Latest/F_5500_2022_Latest.zip 303d4c80af9b8727a7ed7e58cd3c4324dbbfa16828807ace9fd71e2138ea3331 dol5500/F_5500_2023_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2023/Latest/F_5500_2023_Latest.zip 8884391d48a9e362fd7d2b91d6e37430bd2e54355c9dbc3479985c9d876872f8 dol5500/F_5500_2024_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2024/Latest/F_5500_2024_Latest.zip 9f6245cdcbb86ae167af4595bb3dba4fbf7845df98f4ccd6748aa98fa2a4e582 dol5500/F_5500_2025_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2025/Latest/F_5500_2025_Latest.zip a8c128e247a1e18b6d4f5e754548abb3d7b4b601ef640b94b4f113901f678aa2 dol5500_sch_a/F_SCH_A_2009_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2009/Latest/F_SCH_A_2009_Latest.zip 14ba1b309378c92a43009dda03e80bc095d4c26086141bfafe228b92dbdb1b50 dol5500_sch_a/F_SCH_A_2010_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2010/Latest/F_SCH_A_2010_Latest.zip 81b27c6181537dd77d990a04e4cc7e48d6e3f3fb46a40841f66c2e3e312cb5df dol5500_sch_a/F_SCH_A_2011_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2011/Latest/F_SCH_A_2011_Latest.zip b823ba212a0356f71ae6793db0bcef012272f72b97cdc8a3959dfe2b0a272b0d dol5500_sch_a/F_SCH_A_2012_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2012/Latest/F_SCH_A_2012_Latest.zip 99d4e9abc39af8930fbc5472c2be7c0b2d27b21da1c06240f27010f1a4b12f2e dol5500_sch_a/F_SCH_A_2013_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2013/Latest/F_SCH_A_2013_Latest.zip adef9cbe40bd2c3f11957a50e12b61606aa77e83c5039894a2128756ab1177ea dol5500_sch_a/F_SCH_A_2014_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2014/Latest/F_SCH_A_2014_Latest.zip 1a2ea991c736637ec7af465e103b0b84641274e9743ac6186f751975ee1a4bf8 dol5500_sch_a/F_SCH_A_2015_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2015/Latest/F_SCH_A_2015_Latest.zip e5b8adefefd9cd28ea136421a9c96e8a91375dabc52172e0f6b322cc2fecca54 dol5500_sch_a/F_SCH_A_2016_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2016/Latest/F_SCH_A_2016_Latest.zip cd12c72b30fd14dc9d19182c257fa3babdcb5f809a2cdde037700a7220d50d18 dol5500_sch_a/F_SCH_A_2017_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2017/Latest/F_SCH_A_2017_Latest.zip ad2641c7ef3fcf583a5516e4afa19d489a469c574e5e01dbf4d51a24a6865eb8 dol5500_sch_a/F_SCH_A_2018_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2018/Latest/F_SCH_A_2018_Latest.zip 0a9c6afcd8de98cf958e88a8f661b53cdd91817593b015d10b59882577b0aa08 dol5500_sch_a/F_SCH_A_2019_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2019/Latest/F_SCH_A_2019_Latest.zip 9f497c3098f0405cb038c3a42c3a2c4cc8b5e1110b243dc4e512e5ec723e8a03 dol5500_sch_a/F_SCH_A_2020_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2020/Latest/F_SCH_A_2020_Latest.zip c73f8631ef284af37ca6b7d8f4285b22f7f7a545747d7f76ed49339303961415 dol5500_sch_a/F_SCH_A_2021_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2021/Latest/F_SCH_A_2021_Latest.zip 6f180bcdc4a525d590cd37c52ae61c8393be57214502b41dd0f67e098a6b5836 dol5500_sch_a/F_SCH_A_2022_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2022/Latest/F_SCH_A_2022_Latest.zip c672b03eab3cde828d4617fb2a5a5e06c2d1803e45fb06594f1ce6667a18ee2b dol5500_sch_a/F_SCH_A_2023_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2023/Latest/F_SCH_A_2023_Latest.zip 41189738784c55021c25cefaa5560967e931e51e65021eefbd0b2c2a6cec17e3 dol5500_sch_a/F_SCH_A_2024_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2024/Latest/F_SCH_A_2024_Latest.zip 86a7f9dc09b5d5770c938e0a7606d39ad4c01f7817a0659826becc08801a5c00 dol5500_sch_a/F_SCH_A_2025_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2025/Latest/F_SCH_A_2025_Latest.zip ffadd372b316e36ce494aab8fdf78979019e86a6f0a0184d5b8eeb591cfa7ab2 dol5500_sch_h/F_SCH_H_2009_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2009/Latest/F_SCH_H_2009_Latest.zip 82877873a8c866d5d602c5e85c1913952c0a1f4c9149e0c97977d7aa61946180 dol5500_sch_h/F_SCH_H_2010_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2010/Latest/F_SCH_H_2010_Latest.zip 852efa921dc8840e16bb0569d1c7b00976dda80f2e35adb2de8b3be5eece5ff8 dol5500_sch_h/F_SCH_H_2011_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2011/Latest/F_SCH_H_2011_Latest.zip 98f62efc3cd619499f9a27d47499449334a7e9f7985a3d008cbf456073d53f06 dol5500_sch_h/F_SCH_H_2012_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2012/Latest/F_SCH_H_2012_Latest.zip 5c0e4469f41bc4ccf8af1ad2e3fd3cc7dfb8a6a1eafd893c791a266853d93c50 dol5500_sch_h/F_SCH_H_2013_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2013/Latest/F_SCH_H_2013_Latest.zip 6e4017792d92df0083b9a92a7f475f9475bbea6352a0d8774663e418197cdcc0 dol5500_sch_h/F_SCH_H_2014_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2014/Latest/F_SCH_H_2014_Latest.zip e223908908e568474719db5b734bc33221b28182207b4bfd029f823f1a2bcecf dol5500_sch_h/F_SCH_H_2015_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2015/Latest/F_SCH_H_2015_Latest.zip bd958d260ac3e3ea6279b12048cf9d12b436e0d6143219b09222644d01089d0a dol5500_sch_h/F_SCH_H_2016_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2016/Latest/F_SCH_H_2016_Latest.zip 3a10515c196b45217b55f268453f302f9a89494eac72fd5c6c8dc675483bcb1d dol5500_sch_h/F_SCH_H_2017_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2017/Latest/F_SCH_H_2017_Latest.zip fb2ca0ec16a67200585fb6bcd40785fbeda04950cac026dbd0f2a248d88df40c dol5500_sch_h/F_SCH_H_2018_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2018/Latest/F_SCH_H_2018_Latest.zip 4f6857a677360278ef2f6e419c90445b3810c4f28ace6dc78b21d54eaca66287 dol5500_sch_h/F_SCH_H_2019_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2019/Latest/F_SCH_H_2019_Latest.zip d30fbe31ac62d71e415b80e8a853f7f01b2306d391b4f883f1b8a937e65021f3 dol5500_sch_h/F_SCH_H_2020_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2020/Latest/F_SCH_H_2020_Latest.zip 4062355645e6158faa3bca197259e0dedb9ede487ad17a940c0da6900bbdd612 dol5500_sch_h/F_SCH_H_2021_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2021/Latest/F_SCH_H_2021_Latest.zip 3701eeadc4b669891cf4f50556baf918bae01ca137dea12f3bc93e0869eded5f dol5500_sch_h/F_SCH_H_2022_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2022/Latest/F_SCH_H_2022_Latest.zip c3a581897c066452c15e8c1ddbb529274d4a208ccad12d7ed4e5a310823a64b6 dol5500_sch_h/F_SCH_H_2023_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2023/Latest/F_SCH_H_2023_Latest.zip bb5c080627e97ec8b4c9d79ffc602b250f88df6d8de3b5e0cc446b6afffdfc75 dol5500_sch_h/F_SCH_H_2024_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2024/Latest/F_SCH_H_2024_Latest.zip 401280176a160863f667c5cc6e5321d3e96c1f0e581230e11a82574f93175765 dol5500_sch_h/F_SCH_H_2025_Latest.zip https://www.askebsa.dol.gov/FOIA%20Files/2025/Latest/F_SCH_H_2025_Latest.zip 015a7ecbd8ff73f1d941852a8021920c1fda9523d8e64b65227062777f50aa0c dol5500_pre2009/F_5500_1999.zip https://www.askebsa.dol.gov/FOIA%20Files/1999/F_5500_1999.zip 2637773cee34d63214ac5376761a25eaddce56e301a54764deca2a2cf9d852b8 dol5500_pre2009/F_5500_2000.zip https://www.askebsa.dol.gov/FOIA%20Files/2000/F_5500_2000.zip f65b9a45d183f668b6e8b6d4414fd8bcba1d78f862cb9fe352fb97572f261c0a dol5500_pre2009/F_5500_2001.zip https://www.askebsa.dol.gov/FOIA%20Files/2001/F_5500_2001.zip 9c96d8a41474405b241f602c5926f87f270baba4e096510c9b5422009b16f1c3 dol5500_pre2009/F_5500_2002.zip https://www.askebsa.dol.gov/FOIA%20Files/2002/F_5500_2002.zip 66b701abcf7e7876b2e33e3d072a08bf8b433f92b9678b6508ef80b1dd7dfe3e dol5500_pre2009/F_5500_2003.zip https://www.askebsa.dol.gov/FOIA%20Files/2003/F_5500_2003.zip 5ee3d028da362e97a1e39123d0f65e5eee7f18f66378fb63da368857fdd4be84 dol5500_pre2009/F_5500_2004.zip https://www.askebsa.dol.gov/FOIA%20Files/2004/F_5500_2004.zip 58b33f9103eef17061ade010c07bee7edbaa9305abe8c567f2607718df414aa2 dol5500_pre2009/F_5500_2005.zip https://www.askebsa.dol.gov/FOIA%20Files/2005/F_5500_2005.zip 0cc29899be6054420a5cde3c88c3649dd13862d42f28b1bc98e0aca6e3446cef dol5500_pre2009/F_5500_2006.zip https://www.askebsa.dol.gov/FOIA%20Files/2006/F_5500_2006.zip 13e66567bc6960cfdeccfd8cf9fbaf2167c05bf7cb533fc647472b3d17ad43e2 dol5500_pre2009/F_5500_2007.zip https://www.askebsa.dol.gov/FOIA%20Files/2007/F_5500_2007.zip 5f2c36237d9b5030031d0e94ed7a25c0de19a5b9dc2254611f7a9b6cee5dd712 dol5500_pre2009/F_5500_2008.zip https://www.askebsa.dol.gov/FOIA%20Files/2008/F_5500_2008.zip c5735ac7345971ac6c8fd59c5ea523a7635b53ee3345dd722ec012c995e5d09a dol5500_pre2009/F_SCH_A_1999.zip https://www.askebsa.dol.gov/FOIA%20Files/1999/F_SCH_A_1999.zip 897489a9a8f30f8ef7cec2b016647bb4e4553e575185ae3991663cb5bf11bdbb dol5500_pre2009/F_SCH_A_2000.zip https://www.askebsa.dol.gov/FOIA%20Files/2000/F_SCH_A_2000.zip 43ed1bf87dd3aa4fd4db9252f5e582c3f07b3ea3f0648153b2f5dd73ed17952c dol5500_pre2009/F_SCH_A_2001.zip https://www.askebsa.dol.gov/FOIA%20Files/2001/F_SCH_A_2001.zip e158ad7f4d5f35926c0bc4d4ea695a5519019eeb44a8cb1ec5eea06fd2a75704 dol5500_pre2009/F_SCH_A_2002.zip https://www.askebsa.dol.gov/FOIA%20Files/2002/F_SCH_A_2002.zip a98a93d248aee0fa8a95fbe2c6abee33ea95d7bf8792efd71e06161cd4e4fe83 dol5500_pre2009/F_SCH_A_2003.zip https://www.askebsa.dol.gov/FOIA%20Files/2003/F_SCH_A_2003.zip 1b3bad3066955e12b9ae470feb55ded0665e7e75092f3f3f76eab3d7c6bfa294 dol5500_pre2009/F_SCH_A_2004.zip https://www.askebsa.dol.gov/FOIA%20Files/2004/F_SCH_A_2004.zip f57b9798de55ec6e28a531a997c18f76e959d92069c6623b218d9ea2d9cdc5bb dol5500_pre2009/F_SCH_A_2005.zip https://www.askebsa.dol.gov/FOIA%20Files/2005/F_SCH_A_2005.zip 27dd58e8c07f36e98e9c34aaa41d17581edb91bd5e8ffe281ad5cc31574bf496 dol5500_pre2009/F_SCH_A_2006.zip https://www.askebsa.dol.gov/FOIA%20Files/2006/F_SCH_A_2006.zip 1f85a6aec2662b137e3bb65e84dc58aefddfdd8985e99b486bc92ea8391697ba dol5500_pre2009/F_SCH_A_2007.zip https://www.askebsa.dol.gov/FOIA%20Files/2007/F_SCH_A_2007.zip e90fd50899de453882c1f29928894cd7fbe5e969810700519092b85607ab0c15 dol5500_pre2009/F_SCH_A_2008.zip https://www.askebsa.dol.gov/FOIA%20Files/2008/F_SCH_A_2008.zip Not used: pre-2009 Schedule H (F_SCH_H_1999..2008), CMS NHE Table 21 (Table 5 benchmark), SEC 10-K figures.