SFEC Campaign Consultant Employee Reports from December 2024

San Francisco Ethics Commission data on employees of registered campaign consultants, starting from December 9, 2024. Information is created when consultants electronically file Form 1 Registration or Form 2 Re-registration reports. The dataset is updated via the Socrata Publisher API as new filings are submitted and signed.

Use Cases

• Tracking employment relationships in political campaigns based on consultant registration data.
• Analyzing the scale and structure of campaign consulting firms based on reported employee information.
• Joining with related datasets for detailed reporting on consultant activities using the 'Envelope Id' key.

Strengths

• Data collection has a defined start date of December 9, 2024.
• Update process is automated via an API as forms are filed.
• Provides a unique row identifier ('Entry Id') for joining and deduplication.

Limitations

• Column-level documentation is absent; field semantics must be inferred after download.
• Row count is unknown, which may limit suitability assessment.
• Description metadata is limited; actual data quality requires manual inspection after download.

Provenance

Source

City of San Francisco Ethics Commission

Collection Method

Electronically filed campaign consultant reports (Form 1 and Form 2).

Time Range

From December 9, 2024 onward.

Freshness

Last updated 2026-03-22 04:16:54.176514; freshness should be verified.

Geography

San Francisco, California, United States.