Office Schema

The office schema has one section:

  • office_data section contains all information related to the office. We can think of the office name, phone number, email address, URLs, social networks, financial information, industrial classification, and location.

  • office_metrics contains statistical indicators on the office.

{
  "office_data": {
    "office_creation_date": "timestamp",
    "office_last_modified_date": "timestamp (yyyy-MM-dd HH:mm:ss)",
    "office_last_seen_date": "timestamp (yyyy-MM-dd HH:mm:ss)",
    "company_id": "string",
    "company_name": "string",
    "company_domain": "string",
    "company_description": "string",
    "company_logo_url": "string",
    "office_id": "string",
    "office_name": "string",
    "office_domain": "string",
    "office_type": "string",
    "office_number_of_detected_technologies": "number",
    "office_number_of_profiles": "number",
    "office_number_of_contacts": "long",
    "office_alternative_names": {
      "trade_names": [
        "string"
      ],
      "alias_names": [
        "string"
      ],
      "previous_names": [
        "string"
      ]
    },
    "office_phones": [
      {
        "phone": "string",
        "ddi": "boolean",
        "dnc": "boolean",
        "type": "string",
        "carrier": "string",
        "status": "string",
        "status_last_verification_date": "timestamp",
        "score": "decimal",
        "priority": "number"
      }
    ],
    "office_fax": {
      "fax": "string",
      "type": "string",
      "carrier": "string",
      "status": "string",
      "status_last_verification_date": "timestamp",
      "score": "decimal"
    },
    "office_emails": [
      {
        "email": "string",
        "status": "string",
        "status_last_verification_date": "timestamp",
        "score": "decimal",
        "priority": "number"
      }
    ],
    "office_web_address": {
      "url": "string",
      "rank": "number",
      "status": "string",
      "status_last_verification_date": "timestamp"
    },
    "office_web_address_aliases": [
      "string"
    ],
    "office_domain_aliases": [
      "string"
    ],
    "office_social_links": {
      "linkedin": {
        "url": "string",
        "status": "string",
        "status_last_verification_date": "timestamp"
      },
      "twitter": {
        "url": "string",
        "status": "string",
        "status_last_verification_date": "timestamp"
      },
      "facebook": {
        "url": "string",
        "status": "string",
        "status_last_verification_date": "timestamp"
      },
      "instagram": {
        "url": "string",
        "status": "string",
        "status_last_verification_date": "timestamp"
      },
      "youtube": {
        "url": "string",
        "status": "string",
        "status_last_verification_date": "timestamp"
      },
      "yelp": {
        "url": "string",
        "status": "string",
        "status_last_verification_date": "timestamp"
      },
      "crunchbase": {
        "url": "string",
        "status": "string",
        "status_last_verification_date": "timestamp"
      }
    },
    "office_tags": [
      "string"
    ],
    "office_national_registration": {
      "name": "string",
      "number": "string"
    },
    "office_profile": {
      "date_founded": "date",
      "date_closed": "date",
      "marketable": "boolean"
    },
    "office_status": {
      "status": "string",
      "status_last_verification_date": "timestamp",
      "score": "decimal"
    },
    "office_employees": {
      "number_of_employees": "number",
      "number_of_employees_code": "string"
    },
    "office_financials": [
      {
        "yearly_revenue": {
          "revenue": "decimal",
          "code": "string",
          "currency": "string",
          "year": "number",
          "reported_date": "date",
          "type": "string",
          "score": "decimal"
        },
        "yearly_growth": {
          "percentage": "decimal",
          "code": "string",
          "type": "string",
          "year": "number",
          "score": "decimal"
        },
        "priority": "number"
      }
    ],
    "office_revenue_in_usd": "decimal",
    "office_revenue_in_usd_code": "string",
    "office_industries": [
      {
        "id": "string",
        "code2": "string",
        "name2": "string",
        "code3": "string",
        "name3": "string",
        "code4": "string",
        "name4": "string",
        "code5": "string",
        "name5": "string",
        "code6": "string",
        "name6": "string",
        "standard": "string",
        "activity_priority": "number",
        "priority": "number"
      }
    ],
    "office_primary_address": {
      "last_modified_date": "timestamp",
      "formatted_address": "string",
      "street_address": "string",
      "place_id": "string",
      "lat": "decimal",
      "lng": "decimal",
      "accuracy": "string",
      "confidence_score": "decimal",
      "quality": "string",
      "administrative_area_level_1": "string",
      "administrative_area_level_2": "string",
      "administrative_area_level_3": "string",
      "administrative_area_level_4": "string",
      "administrative_area_level_5": "string",
      "continent": "string",
      "country": "string",
      "country_code": "string",
      "establishment": "string",
      "locality": "string",
      "postal_code": "string",
      "postal_town": "string",
      "premise": "string",
      "county": "string",
      "state": "string",
      "state_code": "string",
      "city": "string",
      "street": "string",
      "region": "string",
      "street_number": "string",
      "sublocality": "string",
      "subpremise": "string",
      "score": "decimal"
    },
    "office_registered_address": {
      "last_modified_date": "timestamp",
      "formatted_address": "string",
      "street_address": "string",
      "place_id": "string",
      "lat": "decimal",
      "lng": "decimal",
      "accuracy": "string",
      "confidence_score": "decimal",
      "quality": "string",
      "administrative_area_level_1": "string",
      "administrative_area_level_2": "string",
      "administrative_area_level_3": "string",
      "administrative_area_level_4": "string",
      "administrative_area_level_5": "string",
      "continent": "string",
      "country": "string",
      "country_code": "string",
      "establishment": "string",
      "locality": "string",
      "postal_code": "string",
      "postal_town": "string",
      "premise": "string",
      "county": "string",
      "state": "string",
      "city": "string",
      "street": "string",
      "street_number": "string",
      "sublocality": "string",
      "subpremise": "string",
      "score": "decimal"
    }
  },
  "office_metrics": {
    "marketability_score": "decimal",
    "completion_score": "decimal"
  }
}

    
dfdfdf

What’s Next