Public Company Federal Compliance Record

This dataset joins federal workplace enforcement records with SEC parent-company financial data for 42,302 US establishments operated by 714 publicly traded companies. Each row is one establishment with its parent company's financial context attached.

The joining is the point. OSHA inspection records, WHD wage cases, NLRB labor relations filings, and EPA environmental compliance are each available separately. SEC financial data is available separately. Joining them at the establishment level — with parent-company rollup applied — surfaces patterns that single-source searches miss.

What's in the data

Establishment identity: name, city, state, ZIP, NAICS classification

Parent identity: parent name, SEC CIK, ticker

Workplace safety (OSHA): inspection count, violations, penalties, fatalities, hospitalizations, severe violator program flag, inspection-trigger breakdown (accident / complaint / referral)

Wage enforcement (WHD): case count, total back wages, employees affected

Labor relations (NLRB): total cases, unfair labor practice cases, representation cases

Environmental (EPA): inspections, formal actions, non-compliance quarters, penalties, current compliance status

Parent financials (SEC): revenue, net income, total assets, facts-as-of date

FastDOL risk artifacts: risk tier (LOW / MEDIUM / ELEVATED / HIGH), risk score, agency violation count, peer violation percentile

Debarment status: SAM.gov exclusion flag

Findings to explore

The dataset surfaces patterns at the parent-company level that aren't visible in single-agency searches.

NLRB concentration in utilities. Edison International runs 89.2 NLRB cases per establishment across 115 locations. PG&E runs 84.6 across 237 locations. Major utilities cluster at 56–89 NLRB cases per establishment, far above any other sector represented in the data.

UPS and labor disputes. United Parcel Service has 149,690 NLRB cases across 1,586 establishments, the highest absolute count in the dataset by a wide margin.

Fatality density vs absolute count. Walmart has the most absolute OSHA fatalities (143). Tyson Foods has 117 fatalities across only 421 establishments — substantially higher per-establishment fatality density than any other major public company.

Restaurant chains skew toward wage cases. McDonald's has 1,249 WHD cases against 330 OSHA violations. Yum Brands and Restaurant Brands International show similar profiles. Wage enforcement, not workplace safety, is the dominant federal enforcement axis for QSR.

Risk distribution. 239 establishments are flagged HIGH risk and 2,041 ELEVATED. The remaining 39,022 are LOW or MEDIUM. The HIGH/ELEVATED subset (5.4% of the data) is where most cross-agency patterns concentrate.

Public-company debarments. 30 establishments in the dataset have public-company parents AND active SAM.gov federal contracting exclusions.

本数据集将联邦职场执法记录与714家上市公司运营的42302家美国经营场所的美国证券交易委员会（SEC）母公司财务数据进行关联整合。每一行数据对应一家经营场所，并附带其母公司的财务背景信息。

本次关联整合为本数据集的核心价值所在。目前职业安全与健康管理局（OSHA）检查记录、工资与工时司（WHD）工资纠纷案件、全国劳动关系委员会（NLRB）劳动关系备案文件以及环境保护署（EPA）环境合规数据均为独立公开数据源，SEC财务数据亦单独可获取。本数据集以经营场所为关联维度，并应用母公司聚合逻辑，能够揭示单一数据源检索无法发现的模式规律。

数据集包含以下内容：
1. 经营场所标识：名称、所在城市、州、邮政编码、北美行业分类系统（NAICS）分类
2. 母公司标识：母公司名称、SEC中央索引密钥（CIK, Central Index Key）、股票代码
3. 职场安全（OSHA）：检查次数、违规次数、罚款金额、死亡人数、住院人数、严重违规项目标记、检查触发类型细分（事故触发/投诉触发/转介触发）
4. 工资执法（WHD）：案件数量、欠薪总额、受影响员工人数
5. 劳动关系（NLRB）：总案件数、不公平劳工实践案件数、代表权案件数
6. 环境合规（EPA）：检查次数、正式执法行动次数、不合规季度数、罚款金额、当前合规状态
7. 母公司财务数据（SEC）：营收、净利润、总资产、数据截至日期
8. FastDOL风险特征：风险等级（低/中/升高/高）、风险评分、机构违规次数、同行违规百分位
9. 取消资格状态：SAM.gov系统排除标记

可探索的研究发现方向：
1. 母公司层面的隐藏规律：本数据集能够揭示单一机构检索无法发现的母公司层面执法模式。
2. 公用事业行业的NLRB案件集中度：爱迪生国际（Edison International）在其115家经营场所中，平均每家经营场所对应89.2起NLRB案件；太平洋天然气与电力公司（PG&E）在237家经营场所中，平均每家对应84.6起NLRB案件。多数公用事业企业的单经营场所NLRB案件数处于56至89区间，远高于数据集内其他行业。
3. 联合包裹服务（UPS）与劳资纠纷：联合包裹服务（UPS）在1586家经营场所中累计发生149690起NLRB案件，是数据集中绝对案件数最高的企业，优势显著。
4. 死亡密度与绝对数量：沃尔玛（Walmart）的OSHA监管死亡总人数最多，达143人。泰森食品（Tyson Foods）仅在421家经营场所中就累计发生117起死亡事故，其单经营场所死亡密度远高于其他大型上市公司。
5. 餐饮连锁企业的工资执法倾向：麦当劳（McDonald's）涉及1249起WHD工资执法案件，对应330起OSHA违规案件。百胜餐饮集团（Yum Brands）及国际餐饮品牌（Restaurant Brands International）呈现相似的案件分布特征。对于快餐连锁行业而言，工资执法而非职场安全是联邦执法的主要维度。
6. 风险等级分布：数据集中共有239家经营场所被标记为高风险，2041家为升高风险，剩余39022家为低风险或中风险。高风险与升高风险子集占数据集的5.4%，该子集集中了多数跨机构执法模式。
7. 上市公司取消资格情况：数据集中共有30家经营场所的母公司为上市公司，且处于SAM.gov系统的联邦合同有效排除期内。