AGENCY_ID
PRIMARY_AGENCY_ID
PROD_ABBR
PROD_LINE
STATE_ABBR
STAT_PROFILE_DATE_YEAR
RETENTION_POLY_QTY
POLY_INFORCE_QTY
PREV_POLY_INFORCE_QTY
NB_WRTN_PREM_AMT
WRTN_PREM_AMT
PREV_WRTN_PREM_AMT
PRD_ERND_PREM_AMT
PRD_INCRD_LOSSES_AMT
MONTHS
RETENTION_RATIO
LOSS_RATIO
LOSS_RATIO_3YR
GROWTH_RATE_3YR
AGENCY_APPOINTMENT_YEAR
ACTIVE_PRODUCERS
MAX_AGE
MIN_AGE
VENDOR_IND
VENDOR
PL_START_YEAR
PL_END_YEAR
COMMISIONS_START_YEAR
COMMISIONS_END_YEAR
CL_START_YEAR
CL_END_YEAR
ACTIVITY_NOTES_START_YEAR
ACTIVITY_NOTES_END_YEAR
CL_BOUND_CT_MDS
CL_QUO_CT_MDS
CL_BOUND_CT_SBZ
CL_QUO_CT_SBZ
CL_BOUND_CT_eQT
CL_QUO_CT_eQT
PL_BOUND_CT_ELINKS
PL_QUO_CT_ELINKS
PL_BOUND_CT_PLRANK
PL_QUO_CT_PLRANK
PL_BOUND_CT_eQTte
PL_QUO_CT_eQTte
PL_BOUND_CT_APPLIED
PL_QUO_CT_APPLIED
PL_BOUND_CT_TRANSACTNOW
PL_QUO_CT_TRANSACTNOW
Description
master agency if part of group
33 products of which 14 are CL and 19 are PL
commercial lines (CL) or personal lines (PL)
data starts in mid-2005 and continues into 2015
current number of policies that are still active from previous year
number of policies active for that year
number of policies active in the previous year
new business in written premium
total written premium
written premium during the same period in the previous year
amount of premium taken in
losses
number of months included in the data for that year; the original data was monthly and some months were missing
so the aggregate doesn’t make up the entire year if the months value is less than 12
computed & computed for each row in the data as RETENTION_POLY_QTY / PREV_POLY_INFORCE_QTY; therefore it’s a
granular measure of the retention for that agency writing that particular product in that particular state from the
previous year
compute & computed for each row in the data as PRD_INCRD_LOSSES_AMT / WRTN_PREM_AMT; currently I’m only
computing results where the WRTN_PREM_AMT is greater than 0; however there are many cases where there are
losses but no premium maybe from a previous claim that’s still being paid, so I included codes to indicate whether
there are positive or negative losses on zero premiums; they are located at the end of this document
computed & computed by agency by line of business by year for the three year period ending in that year, if there is
data for three years, otherwise the two years or one year of data available; to make this more tangible, the first
complete year of data we have for an agency will have the loss ratio for that year; the second complete year of data
will have the mean loss ratio for that year and the previous year; the third complete year of data will have the mean
loss ratio for those three years; then the fourth and greater will have the mean of the three year period ending in that
year; note that the mean loss ratios are computed independently for PL and CL
computed & computed by agency by line of business by year for the three year period ending in that year; measures
the average growth in written premium for that agency in that line of business; only computes results for agencies
that have data for the entire range of years; since the measure is over three years of growth, there needs to be a base
year to be used as a standard so four years of data are needed; in order to include as many results as possible, the
PREV_WRTN_PREM_AMT column is used if it exists in the first year of data available, so that it can be used as a base
year, otherwise the WRTN_PREM_AMT is the only column used
year the agency started doing business with Azure
number of active producers in the agency
contains missing values & results may not be accurate) maximum age producer at that agency
minimum age producer at that agency
indicator column to specify whether the agency subscribes to a vendor
the vendor that the agency subscribes to
year the agency started using the PL vendor
year the agency stopped using the PL vendor
year the agency started using the COMMISIONS vendor
year the agency stopped using the COMMISIONS vendor
year the agency started using the CL vendor
year the agency stopped using the CL vendor
year the agency started using the ACTIVITY NOTES vendor
year the agency stopped using the ACTIVITY NOTES vendor
number of bound policies quoted through a MDS (probably a data recording error, should be DSM) in the current
year to date, that is the first six months of 2015, in commercial lines )
number of quoted policies through a MDS (probably a data recording error, should be DSM) in the current year to
date, that is the first six months of 2015, in commercial lines )
number of bound policies quoted through a SBZ in the current year to date, that is the first six months of 2015, in
commercial lines
number of quoted policies through a SBZ in the current year to date, that is the first six months of 2015, in
commercial lines
number of bound policies quoted through an eQT in the current year to date, that is the first six months of 2015, in
commercial lines
number of quoted policies though an eQT in the current year to date, that is the first six months of 2015, in
commercial lines
number of bound policies quoted through ELINKS since September 2013 in personal lines
number of quoted policies though ELINKS since September 2013 in personal lines
number of bound policies quoted through PLRANK since September 2013 in personal lines
number of quoted policies though PLRANK since September 2013 in personal lines
number of bound policies quoted through eQTte since September 2013 in personal lines
number of quoted policies though eQTte since September 2013 in personal lines
number of bound policies quoted through APPLIED since September 2013 in personal lines
number of quoted policies though APPLIED since September 2013 in personal lines
number of bound policies quoted through TRANSACTNOW since September 2013 in personal lines
number of quoted policies though TRANSACTNOW since September 2013 in personal lines
PROD_LINE PROD_ABBR DESCRIPTION
BOILERMACH Bolier Machinery
BOP Business Owner's Package
COMMAUTO Automobile
COMMINLMAR Inland Marine
CL
COMMPOL
COMMUMBREL Umbrella
CRIME Crime
FIREALLIED Fire Allied
GARAGE Garage Keeper's Liability
GENERALIAB General Liability
WORKCOMP Worker's Compensation
ANNIV
ANNIV 12
CYCLES Cycles
CYCLES 12
DTALK
DTALK 12
DWELLFIRE Dwell Fire
HOMEOWNERS Homeowners
MOBILEHOME Mobilehome
PL
MOTORHOM12
MOTORHOME automobiel
PERSAIP Special Automobile Insurance Policy
PERSINLMAR Inland Marine
PERSUMBREL Umbrella
SNOWMOBI12
SNOWMOBILE Snowmobile
YACHT Yacht
DESCRIPTION DETAILED
Policy provides coverage for physical damage to and financial loss from equipment
breakdown. Boiler and machinery insurance, also called equipment breakdown
insurance, covers the cost of repairing or replacing the damaged equipment and
business losses incurred from the equipment not functioning
comprehensive package of Property and Liability Coverages for a wide variety of small
to mid-sized business entities
vehicles used for business
Type of Property Insurance policy that covers certain kinds of moveable property and
other specialized items that standard Property Insurance policies can't cover. Many
Inland Marine policies cover insured property no matter where it's located.
range of items, such as cameras, musical instruments, and catering equipment. These
things move from location to location, which subjects them to more opportunities for
loss, damage, and theft. These increased exposures call for a separate form of
property coverage, and that's where Inland Marine coverage comes in.
higher liability limits and broadened coverage.
protection from losses resulting from business-related crime
Standard fire insurance policy extended to cover associated causes of loss or damage
to the property
Policy for vehicles protection within business premeises
Broad type of insurance policy which provides liability insurance for general business
risks
Policy for employees of a firm, business or organization injured in the performance of a
job function or duty. This is mandatory coverage in a vast majority of the U.S. states.
Discounted bike insurance covering theft, accidental damage
Fire policy designed to insure a dwelling, which is another word for a shelter or
structure people may live in
Policy covers losses and damages to an individual's house and to assets in the home
Policy for mobile and manufactured homes
Policy forhome car insurance
helps make auto insurance available to drivers who are likely to go uninsured because
of limited financial resources.
same as commercial
Policy designed to add extra liability coverage over and above another insurance
policy, such as auto or homeowners insurance.
Policy to protect snowy adventure
Policy that provides indemnity liability coverage on pleasure boats
