Who builds and owns in Berkeley: active real-estate players

Organization name. The company, partnership, or nonprofit as it appears in the public record.

Produce it: Legal or trading name as the record writes it. Organizations only. Never an individual's name, even if they are a sole developer.

Output path: org_name

Coverage: 100 minimum populated · 125 preferred · 150 maximum · 100% minimum · 100% target

Flat-file columns: nameorgcompany

Example: Fourth Street Partners LLC

Missing values: Not allowed.

Source: The record the name was read from.

Buyer review: Any row naming a natural person fails the submission outright.

Organization type. The role this organization plays in Berkeley projects.

Produce it: Exactly one of: developer, property_owner, architect, general_contractor, affordable_housing_nonprofit, investor, land_use_consultant. Pick the role the Berkeley records actually show them in.

Output path: org_type

Coverage: 100 minimum populated · 125 preferred · 150 maximum · 100% minimum · 100% target

Flat-file columns: typerole

Example: developer

Missing values: Not allowed.

Buyer review: Role must be supported by the cited Berkeley project.

Berkeley projects found. How many distinct Berkeley projects this organization appears on.

Produce it: Count of distinct city case numbers you found them on. Minimum 1; an organization with no Berkeley project does not belong in this dataset.

Output path: berkeley_project_count

Coverage: 100 minimum populated · 125 preferred · 150 maximum · 100% minimum · 100% target

Flat-file columns: project_countcount

Example: 3

Missing values: Not allowed.

Source: Cite where the value came from.

Buyer review: Re-count from the cited cases. Inflated counts fail the submission.

Example Berkeley case numbers. City case numbers proving this organization is active in Berkeley.

Produce it: Up to three city case numbers, semicolon separated. At least one required. These are what make the row verifiable.

Output path: example_case_numbers

Coverage: 100 minimum populated · 125 preferred · 150 maximum · 100% minimum · 100% target

Flat-file columns: casesprojects

Example: ZP2024-0123; ZP2023-0088

Missing values: Not allowed.

Source: Cite where the value came from.

Buyer review: Open a sampled case. If the organization does not appear on it, the row fails.

Example project address. Address of one Berkeley project the organization worked on.

Produce it: Street address plus 'Berkeley, CA'. Must correspond to one of the cited case numbers.

Output path: example_project_address

Coverage: 100 minimum populated · 125 preferred · 150 maximum · 100% minimum · 100% target

Flat-file columns: address

Example: 1900 Fourth Street, Berkeley, CA

Missing values: Not allowed.

Source: Cite where the value came from.

Buyer review: Address must match the cited case.

Headquarters city. City the organization is based in.

Produce it: City name only. Tells us whether Berkeley development is local or out-of-town capital.

Output path: headquarters_city

Coverage: 70 minimum populated · 110 preferred · 150 maximum · 60% minimum · 85% target

Flat-file columns: cityhq_city

Example: Oakland

Missing values: Allowed When no public record states a business address..

Source: Cite where the value came from.

Buyer review: Must match a public business record.

Headquarters state. US state or territory the organization is based in.

Produce it: Two-letter uppercase code, for example CA. Blank if the headquarters is outside the United States, and say so in the notes.

Output path: headquarters_state

Coverage: 70 minimum populated · 110 preferred · 150 maximum · 60% minimum · 85% target

Flat-file columns: statehq_state

Example: CA

Missing values: Allowed When the headquarters is outside the United States or not publicly stated..

Source: Cite where the value came from.

Buyer review: Must be a valid two-letter code.

Business registration number. California Secretary of State entity number, where the organization is registered.

Produce it: The entity number as the state publishes it. Blank if the organization is not registered in California or you cannot find it.

Output path: entity_registration_id

Coverage: 40 minimum populated · 90 preferred · 150 maximum · 30% minimum · 70% target

Flat-file columns: entity_idsos_number

Example: 202312345678

Missing values: Allowed When the organization has no findable California registration..

Source: The state business search record.

Buyer review: A registration number that does not resolve on the state site fails the field.

Website. The organization's public website.

Produce it: Working public URL. Blank if the organization has none.

Output path: website_url

Coverage: 50 minimum populated · 100 preferred · 150 maximum · 40% minimum · 75% target

Flat-file columns: website

Example: https://example-developer.com

Missing values: Allowed When the organization has no public website..

Buyer review: Sampled URLs must resolve.

First year active in Berkeley. Earliest year you found this organization on a Berkeley project.

Produce it: Four-digit year of the earliest cited case. Read from the record, not guessed from company age.

Output path: first_seen_year

Coverage: 70 minimum populated · 110 preferred · 150 maximum · 60% minimum · 85% target

Flat-file columns: first_year

Example: 2019

Missing values: Allowed When no filing date can be established from the cited cases..

Source: Cite where the value came from.

Buyer review: Must match the earliest cited case.

Source URL. Public link to the record this row was read from.

Produce it: A working public URL on berkeleyca.gov, an official permit portal, the state legislature site, or another official host. No paywalled or login-gated links.

Output path: source_url

Coverage: 100 minimum populated · 125 preferred · 150 maximum · 100% minimum · 100% target

Flat-file columns: urllinksource

Example: https://berkeleyca.gov/construction-development/land-use-development/zoning-adjustments-board

Missing values: Not allowed.

Source: This column is the source link.

Buyer review: Sampled links must resolve publicly and must contain the claimed information.

Date captured. The date this row was read from its source.

Produce it: ISO 8601, YYYY-MM-DD. Must be within 60 days of submission.

Output path: captured_at

Coverage: 100 minimum populated · 125 preferred · 150 maximum · 100% minimum · 100% target

Flat-file columns: datecaptured_at

Example: 2026-08-12

Missing values: Not allowed.

Buyer review: Reject rows captured more than 60 days before submission.