SFEC Form 126f4: San Francisco City Contract Approval Affiliates and Subcontractors

Notifications of contract approvals filed with the San Francisco Ethics Commission when a City elective officer approves a contract valued at $100,000 or more. This dataset lists affiliates and subcontractors associated with those approved contracts and must be joined with a parent dataset using a DocuSignID key. The data is provided by the City of San Francisco and was last updated on March 15, 2026.

Use Cases

• Analyzing contractor networks based on affiliate and subcontractor relationships mentioned in the description.
• Tracking compliance with city ethics regulations based on the filing requirement for contracts over $100,000.
• Mapping connections between approved contracts and associated entities based on the described join key.

Strengths

• Data is structured for relational analysis, requiring a join with a parent dataset via a specific key (DocuSignID).
• Provides a specific filing threshold ($100,000) for contract approvals.
• Last updated March 15, 2026, indicating recent maintenance.

Limitations

• Column-level documentation is absent; field semantics must be inferred after download.
• Row count is unknown, which may limit suitability assessment.
• Data may reflect geographic bias inherent to San Francisco city government sources.

Provenance

Source

City of San Francisco

Collection Method

Electronic filings submitted to the San Francisco Ethics Commission.

Freshness

Last updated 2026-03-15 03:09:43.304149; freshness should be verified.

Geography

San Francisco