Name: CANDIDATE_CAMPAIGNS

Display Field: CANDIDATE_NAME

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• candidate_name (type: esriFieldTypeString, alias: CANDIDATE_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• election_year (type: esriFieldTypeInteger, alias: ELECTION_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• election_date (type: esriFieldTypeDate, alias: ELECTION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• election_type (type: esriFieldTypeString, alias: ELECTION_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• office_sought (type: esriFieldTypeString, alias: OFFICE_SOUGHT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• party (type: esriFieldTypeString, alias: PARTY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• district_num (type: esriFieldTypeString, alias: DISTRICT_NUM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• district_name (type: esriFieldTypeString, alias: DISTRICT_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• incumbency (type: esriFieldTypeString, alias: INCUMBENCY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• election_outcome (type: esriFieldTypeString, alias: ELECTION_OUTCOME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• endorsement (type: esriFieldTypeString, alias: ENDORSEMENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• name_ballot (type: esriFieldTypeString, alias: NAME_BALLOT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• filer_id_desg_committee (type: esriFieldTypeString, alias: FILER_ID_DESG_COMMITTEE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• active_candidate_date (type: esriFieldTypeDate, alias: ACTIVE_CANDIDATE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• cand_form_received (type: esriFieldTypeDate, alias: CAND_FORM_RECEIVED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• candidate_self_name (type: esriFieldTypeString, alias: CANDIDATE_SELF_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cco_form_received (type: esriFieldTypeDate, alias: CCO_FORM_RECEIVED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• debt_free_date (type: esriFieldTypeDate, alias: DEBT_FREE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• declared_public (type: esriFieldTypeDate, alias: DECLARED_PUBLIC, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• desg_committee_name (type: esriFieldTypeString, alias: DESG_COMMITTEE_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• district_label (type: esriFieldTypeString, alias: DISTRICT_LABEL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dropout_date (type: esriFieldTypeDate, alias: DROPOUT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• filer_id_candidate_self (type: esriFieldTypeString, alias: FILER_ID_CANDIDATE_SELF, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• filer_no_committee_flag (type: esriFieldTypeString, alias: FILER_NO_COMMITTEE_FLAG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• former_candidate_date (type: esriFieldTypeDate, alias: FORMER_CANDIDATE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• office_label (type: esriFieldTypeString, alias: OFFICE_LABEL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• office_level (type: esriFieldTypeString, alias: OFFICE_LEVEL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cand_num_filings (type: esriFieldTypeInteger, alias: CAND_NUM_FILINGS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cand_filings_status (type: esriFieldTypeString, alias: CAND_FILINGS_STATUS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cand_debt_filings (type: esriFieldTypeInteger, alias: CAND_DEBT_FILINGS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cand_24hr_filings (type: esriFieldTypeInteger, alias: CAND_24HR_FILINGS, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: CANDIDATE_CAMPAIGNS
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/25/2025 10:06:35 AM

Schema Last Edit Date: 7/25/2025 10:06:35 AM

Data Last Edit Date: 7/25/2025 10:06:35 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat