FILER_TO_FILER_TYPE_CD

Links a filer to a set of characteristics that describe the filer.

Fields

Information about the 17 fields and the definitions of any abbreviated values.

FILER_ID Integer · Unique

Filer's unique identification number

FILER_TYPE Integer · Unique

Foreign key referencing FilerTypesCd.filer_type

ACTIVE String (up to 1)

Indicates if the filer is currently active

RACE Integer

If applicable indicates the race in which the filer is running

Code	Definition
`0`	N/A
`30002`	GOVERNOR
`30003`	LIEUTENANT GOVERNOR
`30004`	SECRETARY OF STATE
`30005`	CONTROLLER
`30006`	TREASURER
`30007`	ATTORNEY GENERAL
`30008`	SUPERINTENDENT OF PUBLIC INSTRUCTION
`30009`	MEMBER BOARD OF EQUALIZATION
`30010`	OXNARD HARBOR COMMISSIONER
`30011`	CITY CONTROLLER
`30012`	STATE SENATE
`30013`	ASSEMBLY
`30014`	INSURANCE COMMISSIONER
`30015`	JUDGE
`30016`	BOARD MEMBER
`30017`	TAX COLLECTOR
`30018`	TRUSTEE
`30019`	SUPERVISOR
`30020`	SHERIFF
`30021`	CORONER
`30022`	MARSHALL
`30023`	CITY CLERK
`30024`	SCHOOL BOARD
`30025`	HARBOR COMMISSIONER
`30026`	DISTRICT ATTORNEY
`30027`	COUNTY CLERK
`30028`	AUDITOR
`30029`	MAYOR
`30030`	CITY ATTORNEY
`30031`	DEMOCRATIC COUNTY CENTRAL COMMITTEE
`30032`	TOWN COUNCIL
`30033`	ASSESSOR
`30034`	CITY TREASURER
`30035`	CITY COUNCIL
`30036`	COMMISSIONER
`30037`	REPUBLICAN COUNTY CENTRAL COMMITTEE
`30038`	DIRECTOR
`30039`	DIRECTOR OF ZONE 7
`30040`	COMMUNITY COLLEGE BOARD
`30041`	POLICE CHIEF
`30042`	CHIEF OF POLICE
`30043`	CENTRAL COMMITTEE
`30044`	BOARD OF EDUCATION
`30045`	BOARD OF DIRECTORS
`30046`	COLLEGE BOARD
`30047`	BART BOARD DIRECTOR
`30048`	BOARD OF TRUSTEES
`30049`	IRRIGATION
`30050`	WATER BOARD
`30051`	COMMUNITY PLANNING GROUP
`30052`	BOARD OF SUPERVISORS
`30053`	SUPERIOR COURT JUDGE
`30054`	DISTRICT ATTORNEY/PUBLIC DEFENDER
`30055`	MEASURE
`30056`	CITY PROSECUTOR
`30057`	SUPREME COURT JUDGE
`30058`	PUBLIC EMPLOYEES RETIREMENT BOARD
`30059`	APPELLATE COURT JUDGE
`50001`	Ag
`50002`	Assembly
`50003`	Assessor
`50004`	Assessor/Clerk/Recorder
`50005`	Assessor/County Clerk/Recorder
`50006`	Assessor/Recorder
`50007`	Associate Justice
`50008`	Auditor
`50009`	Auditor/Controller
`50010`	Auditor/Controller/Clerk/Recorder
`50011`	Auditor/Controller/Recorder
`50012`	Auditor/Controller/Treasurer/Tax Collector
`50013`	Auditor/Recorder
`50014`	Board Member
`50015`	Board Of Director
`50016`	Board Of Supervisor
`50017`	Boe
`50018`	Chief Justice
`50019`	City
`50020`	City Attorney
`50021`	City Auditor
`50022`	City Clerk
`50023`	City Council
`50024`	City Of Los Angeles
`50025`	City Of South El Monte
`50026`	City Prosecutor
`50027`	City Treasurer
`50028`	Clerk/Auditor
`50029`	Clerk/Record/Public Admin
`50030`	Clerk/Recorder
`50031`	Clerk/Recorder/Registar
`50032`	Clerk/Recorder/Registrar
`50033`	Commissioner
`50034`	Controller
`50035`	Costa Mesa
`50036`	Council Member
`50037`	County Clerk
`50038`	County Clerk/Auditor
`50039`	County Clerk/Auditor/Controller
`50040`	County Clerk/Recorder
`50041`	County Clerk/Recorder/Assessor
`50042`	County Clerk/Recorder/Public Admin
`50043`	Democratic County Central Committee
`50044`	Director
`50045`	District Attorney
`50046`	District Attorney/Public Administrator
`50047`	Gccc
`50048`	Governor
`50049`	Harbor Commissioner
`50050`	Ic
`50051`	Irrigation Dist
`50052`	Judge
`50053`	Justice
`50054`	Legislature
`50055`	Lieutenant Governor
`50056`	Mayor
`50057`	N/A
`50058`	Placentia
`50059`	Public Administrator
`50060`	Public Administrator/Guardian
`50061`	Rent Stabilization Board
`50062`	Republican Central Committee
`50063`	San Francisco Dccc
`50064`	Sanger
`50065`	School Board
`50066`	Secretary Of State
`50067`	Senator
`50068`	Sheriff
`50069`	Sheriff/Coroner
`50070`	Sheriff/Coroner/Marshall
`50071`	Sheriff/Coroner/Public Administrator
`50072`	Solana Beach
`50073`	Superintendent
`50074`	Supervisor
`50075`	Supt Of Schools
`50076`	Tax Collector
`50077`	Town Council
`50078`	Treasurer
`50079`	Treasurer/Tax Collector
`50080`	Treasurer/Tax Collector/Clerk
`50081`	Treasurer/Tax Collector/Public Administrator
`50082`	Treasurer/Tax Collector/Public Administrator/County Clerk
`50083`	Treasurer/Tax Collector/Recorder
`50084`	Trustee
`50085`	Weed Recreation Board Member
Sources: Lookup-Codes-Cd (16-18, 20-22)

SESSION_ID Integer · Unique

Legislative session identification number

CATEGORY Integer

Defines the filer's category such as controlled, jointly controlled, etc. (subset of filer's type)

Code	Definition
`0`	N/A
`40000`	CATEGORY
`40001`	JOINTLY CONTROLLED
`40002`	CONTROLLED
`40003`	CAUCUS COMMITTEE
`40004`	Unknown
Sources: Lookup-Codes-Cd (18)

CATEGORY_TYPE Integer

When applicable, the category type specifies additional information about the category. (e.g. state, local, etc.)

Code	Definition
`0`	N/A
`40501`	LOCAL
`40502`	STATE
`40503`	COUNTY
`40504`	MULTI-COUNTY
`40505`	CITY
`40506`	FEDERAL
`40507`	SUPERIOR COURT JUDGE
Sources: Lookup-Codes-Cd (19-20)

SUB_CATEGORY Integer

When applicable specifies general purpose, primarily formed, etc.

Code	Definition
`0`	N/A
`40101`	PRIMARILY FORMED MEASURE
`40102`	PRIMARILY FORMED CANDIDATE
`40103`	GENERAL PURPOSE
`40104`	GENERAL PURPOSE POLITICAL PARTY
`40105`	GENERAL PURPOSE MEASURE
`40112`	Unknown
Sources: Lookup-Codes-Cd (18)

EFFECT_DT Date (without time) · Unique

The date the filer assumed the current class or type

SUB_CATEGORY_TYPE Integer

When applicable specifies broad based or small contributor

Code	Definition
`0`	N/A
`40202`	BROAD-BASED
`40203`	SMALL CONTRIBUTOR
`40204`	MPO - NON PROFIT
`40205`	MPO - NON PROFIT CY
`40206`	MPO - OTHER
`40207`	MPO - OTHER CY
`40208`	FEDERAL PAC
`40209`	OUT OF STATE PAC
Sources: Lookup-Codes-Cd (18-19)

ELECTION_TYPE Integer

Indicates type of election (general, primary, special)

Code	Definition
`0`	N/A
`3001`	GENERAL
`3002`	PRIMARY
`3003`	RECALL
`3004`	SPECIAL ELECTION
`3005`	OFFICEHOLDER
`3006`	SPECIAL RUNOFF
`3010`	Unknown
`3007`	Unknown
Sources: Lookup-Codes-Cd (3-4)

SUB_CATEGORY_A String (up to 1)

Indicates if sponsored or not

NYQ_DT Date (without time)

Indicates the date when a committee reached its qualifying level of activity

PARTY_CD Integer

Filer's political party

Code	Definition
`16001`	DEMOCRATIC
`16002`	REPUBLICAN
`16003`	GREEN PARTY
`16004`	REFORM PARTY
`16005`	AMERICAN INDEPENDENT PARTY
`16006`	PEACE AND FREEDOM
`16007`	INDEPENDENT
`16008`	LIBERTARIAN
`16009`	NON PARTISAN
`16010`	NATURAL LAW
`16011`	UNKNOWN
`16012`	NO PARTY PREFERENCE
`16013`	AMERICANS ELECT
`16020`	PEACE AND FREEDOM
`16014`	UNKNOWN
`0`	UNKNOWN
`None`	NONE
Sources: Lookup-Codes-Cd (10-11)

COUNTY_CD Integer

Filer's county code

Code	Definition
`0`	N/A
`18001`	01
`18002`	12
`18003`	23
`18004`	34
`18005`	45
`18006`	55
`18007`	56
`18008`	57
`18009`	58
`18010`	02
`18011`	03
`18012`	04
`18013`	05
`18014`	06
`18015`	07
`18016`	08
`18017`	09
`18018`	10
`18019`	11
`18020`	13
`18021`	14
`18022`	15
`18023`	16
`18024`	17
`18025`	18
`18026`	19
`18027`	20
`18028`	21
`18029`	22
`18030`	24
`18031`	25
`18032`	26
`18033`	27
`18034`	28
`18035`	29
`18036`	30
`18037`	31
`18038`	32
`18039`	33
`18040`	35
`18041`	36
`18042`	37
`18043`	38
`18044`	39
`18045`	40
`18046`	41
`18047`	42
`18048`	43
`18049`	44
`18050`	46
`18051`	47
`18052`	48
`18053`	49
`18054`	50
`18055`	51
`18056`	52
`18057`	53
`18058`	54
Sources: Lookup-Codes-Cd (13-15)

DISTRICT_CD Integer

Filer's district number for the office being sought. Populated for Senate, Assembly or Board of Equalization races

Code	Definition
`0`	N/A
`17001`	01
`17002`	13
`17003`	24
`17004`	35
`17005`	46
`17006`	57
`17007`	68
`17008`	79
`17009`	02
`17010`	05
`17011`	04
`17013`	06
`17014`	07
`17015`	08
`17016`	19
`17017`	10
`17018`	11
`17019`	12
`17020`	14
`17021`	15
`17022`	16
`17023`	17
`17024`	18
`17026`	20
`17027`	21
`17028`	22
`17029`	23
`17030`	25
`17031`	26
`17032`	27
`17033`	28
`17034`	29
`17035`	30
`17036`	31
`17037`	32
`17038`	33
`17039`	34
`17040`	36
`17041`	37
`17042`	38
`17043`	39
`17044`	40
`17045`	41
`17046`	42
`17047`	43
`17048`	44
`17049`	45
`17050`	47
`17051`	48
`17052`	49
`17053`	50
`17054`	51
`17055`	52
`17056`	53
`17057`	54
`17058`	55
`17059`	56
`17060`	03
`17061`	59
`17062`	60
`17063`	61
`17064`	62
`17065`	63
`17066`	64
`17067`	65
`17068`	66
`17069`	67
`17070`	69
`17071`	70
`17072`	71
`17073`	72
`17074`	73
`17075`	74
`17076`	75
`17077`	76
`17078`	77
`17079`	78
`17080`	80
`17081`	09
`17090`	58
`17091`	Unknown
`17083`	Unknown
`17093`	Unknown
`17094`	Unknown
`17088`	Unknown
`17096`	Unknown
`17012`	Unknown
`17095`	Unknown
`17092`	Unknown
`17086`	Unknown
`17099`	Unknown
`17082`	Unknown
`17025`	Unknown
`17085`	Unknown
`17084`	Unknown
`17087`	Unknown
`17098`	Unknown
`17089`	Unknown
Sources: Lookup-Codes-Cd (11-13)

References

The documents that provided the information on this page.

CAL-ACCESS Tables, Columns and Indexes (p. 9, 69-70)