OpenCalAccess

Filing ID: 2181920

PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2181920&amendid=1

Table: cvr_campaign_disclosure
filing_id	2181920	2181920
amend_id	0	1
rec_type	CVR	CVR
form_type	F497	F497
filer_id	892177	892177
entity_cd	RCP	RCP
filer_naml	California Association of Health Underwriters Political Action Committee	California Association of Health Underwriters Political Action Committee
filer_namf	None	None
filer_namt	None	None
filer_nams	None	None
report_num	000	001
rpt_date	2017-08-23 00:00:00	2017-09-13 00:00:00
stmt_type	None	None
late_rptno	226501-24	226501-24
from_date	None	None
thru_date	None	None
elect_date	None	None
filer_city	Sacramento	Sacramento
filer_st	CA	CA
filer_zip4	95814	95814
filer_phon	916-442-7757	916-442-7757
filer_fax	916-442-7759	916-442-7759
file_email	[email protected]	[email protected]
mail_city	None	None
mail_st	None	None
mail_zip4	None	None
tres_naml	Hiltachk	Hiltachk
tres_namf	Thomas W.	Thomas W.
tres_namt	None	None
tres_nams	None	None
tres_city	Sacramento	Sacramento
tres_st	CA	CA
tres_zip4	95814	95814
tres_phon	916-442-7757	916-442-7757
tres_fax	None	None
tres_email	None	None
cmtte_type	None	None
control_yn	None	None
sponsor_yn	None	None
primfrm_yn	None	None
brdbase_yn	None	None
amendexp_1	None	Update with contributions received by filer in accordance with Gov. Code 84204.5
amendexp_2	None	None
amendexp_3	None	None
rpt_att_cb	None	None
cmtte_id	None	None
reportname	None	None
rptfromdt	None	None
rptthrudt	None	None
emplbus_cb	None	None
bus_name	None	None
bus_city	None	None
bus_st	None	None
bus_zip4	None	None
bus_inter	None	None
busact_cb	None	None
busactvity	None	None
assoc_cb	None	None
assoc_int	None	None
other_cb	None	None
other_int	None	None
cand_naml	None	None
cand_namf	None	None
cand_namt	None	None
cand_nams	None	None
cand_city	None	None
cand_st	None	None
cand_zip4	None	None
cand_phon	None	None
cand_fax	None	None
cand_email	None	None
bal_name	None	None
bal_num	None	None
bal_juris	None	None
office_cd	None	None
offic_dscr	None	None
juris_cd	None	None
juris_dscr	None	None
dist_no	None	None
off_s_h_cd	None	None
sup_opp_cd	None	None
employer	None	None
occupation	None	None
selfemp_cb	None	None
bal_id	None	None
cand_id	None	None

Table: filer_filings
filer_id	1049575	1049575
filing_id	2181920	2181920
period_id	231	231
form_id	F497	F497
filing_sequence	1	0
filing_date	2017-09-13 00:00:00	2017-08-24 00:00:00
stmnt_type	10002	10001
stmnt_status	11001	11001
session_id	2017	2017
user_id	PBANFORD	PBANFORD
special_audit	11003	11003
fine_audit	11001	11001
rpt_start	2017-09-13 00:00:00	2017-08-23 00:00:00
rpt_end	2017-09-13 00:00:00	2017-08-23 00:00:00
rpt_date	2017-09-13 00:00:00	2017-08-23 00:00:00
filing_type	22001	22001

Table: filings
filing_id		2181920
filing_type		22001

Table: hdr
filing_id	2181920	2181920
amend_id	0	1
rec_type	HDR	HDR
ef_type	CAL	CAL
state_cd	CA	CA
cal_ver	2.01	2.01
soft_name	NETFILE	NETFILE
soft_ver	199233	199233
hdrcomment	None	None

Table: s497
filing_id	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920	2181920
amend_id	0	0	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
line_item	1	2	119	120	121	122	123	124	125	126	127	128	129	130	131	132	133	134	135	136	137	138	139	140	141	142	143	144	145	146	147	148	149	150	151	152	153	154	155	156	157	158	159	160	161	162	163	164	165	166	167	168	169	170	171	172	173	174	175	176	177	178	179	180	181	182	183	184	185	186	187	188	189	190	191	192	193	194	195	196	197	198	199	200	201	202	203	204	205	206	207	208	209	210	211	212	213	214	215	216	217	218	219	220	221	222	223	224	225	226	227	228	229	230	231	232	233	234	235	236	237	238	239	240	241	242	243	244	245	246	247	248	249	250	251	252	253	254	255	256	257	258	259	260	261	262	263	264	265	266	267	268	269	270	271	272	273	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60	61	62	63	64	65	66	67	68	69	70	71	72	73	74	75	76	77	78	79	80	81	82	83	84	85	86	87	88	89	90	91	92	93	94	95	96	97	98	99	100	101	102	103	104	105	106	107	108	109	110	111	112	113	114	115	116	117	118
rec_type	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497	S497
form_type	F497P2	F497P2	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P2	F497P2	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1	F497P1
tran_id	EXP48909	EXP48910	INC48875	INC48876	INC48877	INC48878	INC48879	INC48880	INC48881	INC48882	INC48883	INC48884	INC48885	INC48886	INC48887	INC48888	INC48889	INC48890	INC48891	INC48892	INC48893	INC48894	INC48895	INC48896	INC48897	INC48898	INC48900	INC48901	INC48908	INC48931	INC48932	INC48933	INC48934	INC48935	INC48936	INC48937	INC48938	INC48939	INC48940	INC48941	INC48942	INC48944	INC48945	INC48946	INC48947	INC48948	INC48949	INC48950	INC48951	INC48952	INC48953	INC48954	INC48955	INC48956	INC48957	INC48958	INC48959	INC48960	INC48961	INC48962	INC48963	INC48965	INC48966	INC48969	INC48970	INC48971	INC48972	INC48974	INC48975	INC48976	INC48977	INC48978	INC48981	INC48982	INC48983	INC48984	INC48985	INC48986	INC48987	INC48988	INC48989	INC48990	INC48991	INC48992	INC48993	INC48994	INC48995	INC48996	INC48997	INC48998	INC48999	INC49000	INC49001	INC49002	INC49004	INC49005	INC49006	INC49007	INC49008	INC49009	INC49012	INC49013	INC49015	INC49016	INC49017	INC49018	INC49019	INC49020	INC49021	INC49022	INC49023	INC49024	INC49025	INC49026	INC49027	INC49030	INC49031	INC49032	INC49033	INC49034	INC49035	INC49036	INC49037	INC49038	INC49039	INC49040	INC49041	INC49042	INC49043	INC49044	INC49045	INC49046	INC49047	INC49048	INC49049	INC49050	INC49051	INC49052	INC49053	INC49054	INC49055	INC49056	INC49057	INC49058	INC49059	INC49060	INC49061	INC49062	INC49063	INC49064	INC49066	INC49068	INC49069	INC49070	INC49071	INC49072	INC49073	EXP48909	EXP48910	INC48575	INC48576	INC48726	INC48734	INC48737	INC48738	INC48739	INC48740	INC48741	INC48744	INC48745	INC48746	INC48747	INC48748	INC48749	INC48750	INC48751	INC48752	INC48753	INC48756	INC48757	INC48758	INC48759	INC48760	INC48762	INC48763	INC48764	INC48766	INC48767	INC48768	INC48769	INC48770	INC48773	INC48774	INC48775	INC48776	INC48777	INC48778	INC48779	INC48780	INC48781	INC48782	INC48783	INC48784	INC48785	INC48786	INC48787	INC48788	INC48789	INC48791	INC48792	INC48793	INC48794	INC48795	INC48796	INC48797	INC48798	INC48799	INC48800	INC48801	INC48802	INC48803	INC48805	INC48806	INC48809	INC48810	INC48811	INC48812	INC48813	INC48814	INC48815	INC48816	INC48817	INC48818	INC48819	INC48820	INC48821	INC48822	INC48823	INC48824	INC48825	INC48826	INC48827	INC48828	INC48831	INC48832	INC48833	INC48834	INC48835	INC48836	INC48837	INC48838	INC48839	INC48840	INC48841	INC48842	INC48843	INC48844	INC48845	INC48856	INC48857	INC48858	INC48859	INC48860	INC48861	INC48862	INC48864	INC48866	INC48867	INC48868	INC48869	INC48870	INC48871	INC48872	INC48873	INC48874
entity_cd	PTY	PTY	IND	IND	IND	IND	IND	IND	IND	IND	OTH	IND	IND	IND	IND	IND	IND	IND	IND	OTH	IND	IND	IND	IND	IND	IND	OTH	OTH	IND	IND	IND	OTH	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	OTH	OTH	OTH	IND	OTH	OTH	OTH	OTH	OTH	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	OTH	OTH	IND	OTH	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	OTH	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	OTH	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	OTH	PTY	PTY	OTH	OTH	IND	IND	OTH	OTH	OTH	IND	OTH	IND	IND	IND	OTH	OTH	OTH	OTH	OTH	IND	OTH	OTH	OTH	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	OTH	IND	IND	IND	IND	IND	IND	IND	IND	OTH	OTH	IND	IND	OTH	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	OTH	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND	IND
enty_naml	California Republican Party	California Republican Party	Heckler	Bright	Hopwood	Lederman	Hennessy	Hilanto	Jarvis	Zajac	Business Choice Insurance Services	Cartier	Canter	Coburn	Crosby	Moore	Novak	Metcalfe	McComb	Judy Maxwell Insurance Services	Blander	Bealu	Benton	Finster	Denton	McFarland	Golden Gate Association of Health Underwriters	Golden Gate Association of Health Underwriters	Davis	Mariscal	Merken	AMIC Health Insurance Services, Inc.	Miller	McCarville	Strouf	Cohn	Harmon	Marcus	Good	Chaffin	Cohn	Clark	Liu	Simonsen	Leonard	Macaluso	Cecy	Freeman	Dutenhoefer	Bernier	Musser	Dahl	Musser	Valencia	Youngblood	Seltzer	Santaella	Stricklan	Mihalyi-Stiffler	Sunday	Stoddard	Petrocelli	Walker	Rude	Stratmeyer	Henehan	Johnston	Bullion	Neace	Fear, Jr.	M&L Hurley Insurance & Financial, Inc.	Van Nest Ventures, Inc.	Leslie A. Williams Insurance Services	Scopp	Stedt Insurance Services	Shasta Health Insurance Services, Inc.	Essential Exchange Insurance Services	John Helms & Associates	Health Insurance Infosystem	Kenney	Webb	Washington	Berger	Cociu	Brecher	Weber	Larsen	Kane	Friedman	Underhill	Style	Lisanti	Daugherty	Barbara C. Oberman Insurance Services	Barbara McClaskey Insurance Services	Burns	Barbara McClaskey Insurance Services	Morrison	Vaillancourt	Malachowski	Kaelin	Ashby	Herkey	King	Stiller	Ringer	Manning	Bikmaz	Okon	Ives	Goodacre	Lowther	Frankel	Balsdon	Yurek	Trapani	Roberts	Coburn	Business Choice Insurance Services	Canter	Crosby	Cartier	Benton	Blander	Bealu	Jarvis	Hennessy	Hilanto	Finster	Lee	Denton	Zajac	Novak	Moore	McComb	Metcalfe	Judy Maxwell Insurance Services	Lederman	Hopwood	Bright	Heckler	Fortier	Holt	Haskell	Murphy	Davis	Canova	Hoover	Koehler	Pauli	Peters	Hutcherson	Collins	Broner	Buttera West	Hanson	IntelliBenefits Insurance Services, Inc.	California Republican Party	California Republican Party	Maniaci Insurance Services, Inc.	George Geldin Insurance Services	McFarland	Underhill	Golden Gate Association of Health Underwriters	Los Angeles Association of Health Underwriters	Los Angeles Association of Health Underwriters	Canter	Kirk R. Warner Agency Account	Washington	Webb	Kenney	Health Insurance Infosystem	John Helms & Associates	Essential Exchange Insurance Services	Shasta Health Insurance Services, Inc.	Stedt Insurance Services	Scopp	Leslie A. Williams Insurance Services	Van Nest Ventures, Inc.	M&L Hurley Insurance & Financial, Inc.	Fear, Jr.	Neace	Bullion	Youngblood	Seltzer	Santaella	Valencia	Stoddard	Stricklan	Sunday	Mihalyi-Stiffler	Henehan	Johnston	Stratmeyer	Rude	Walker	Petrocelli	Musser	Musser	Dahl	Marcus	Cohn	Harmon	Cohn	Chaffin	Good	Simonsen	Macaluso	Liu	Clark	Leonard	Cecy	Freeman	Dutenhoefer	Bernier	Strouf	McCarville	AMIC Health Insurance Services, Inc.	Mariscal	Miller	Merken	Ashby	Kaelin	Malachowski	Vaillancourt	Morrison	Barbara McClaskey Insurance Services	Barbara McClaskey Insurance Services	Burns	Daugherty	Barbara C. Oberman Insurance Services	Lisanti	Larsen	Kane	Underhill	Style	Cociu	Weber	Rowe	Brecher	Friedman	Lee	Berger	Yurek	Balsdon	Frankel	Lowther	Goodacre	Ives	Okon	Bikmaz	Manning	King	Stiller	Herkey	Ringer	Roberts	Trapani	IntelliBenefits Insurance Services, Inc.	Hanson	Coker	Buttera West	Broner	Collins	Hutcherson	Peters	Pauli	Koehler	Hoover	Canova	Davis	Murphy	Holt	Fortier	Haskell
enty_namf	None	None	Paula	Hazel	Kym	Helene	Pat	Amer	Dennis	Helen	None	Fred	Julianne	Richard	Neil	Kelly	Kim	Mary	Meg	None	Debbie	Sandra	Bruce	James K.	Christopher	Dawn	None	None	Brad	D'Vorah	Monte A.	None	Jeff	Jacqueline	Jean	Renee	Jon	Joel	John	Debbie	Barry	E. Stanton	Allan	Kimmarie	Marilyn	Todd	Brian	Michael	Scott	Norman	Ray	Lisa	Fern	Louise	William	Linda	Toni	J. Edward	Patricia	Kathleen	Kirk	Christine	Steven	Mike	Casey	Joseph	David	Barbara	Ryan	David	None	None	None	Kenneth N.	None	None	None	None	None	Michael	Yolanda	Dale L.	Stephanie	Dorothy	David	Mary Jane	Sue	Jeffrey	Stuart	Charles	David	Jennifer	Cathy	None	None	Patrick	None	James	Gale Kathleen	Laurann	Bobbi	Sharon	Peter	Colleen	Tiffany	John	Richard	Joanne	Izak	Terry Lee	James	Jim	Teri	Shawn	Teresa	Lisa	Kevin	Richard	None	Julianne	Neil	Fred	Bruce	Debbie	Sandra	Dennis	Pat	Amer	James K.	Philip	Christopher	Helen	Kim	Kelly	Meg	Mary	None	Helene	Kym	Hazel	Paula	Roger	James A.	Mark	Laura	C. Bradshaw	Rebecca	Shelley	Linda R.	Jeff B.	David	Lisa	Ronald	Christiane	Cindy	Tracy	None	None	None	None	None	Dawn	Elizabeth J.	None	None	None	Julianne	None	Dale L.	Yolanda	Michael	None	None	None	None	None	Kenneth N.	None	None	None	David	Ryan	Barbara	William	Linda	Toni	Louise	Kirk	J. Edward	Kathleen	Patricia	Joseph	David	Casey	Mike	Steven	Christine	Ray	Fern	Lisa	Joel	Renee	Jon	Barry	Debbie	John	Kimmarie	Todd	Allan	E. Stanton	Marilyn	Brian	Michael	Scott	Norman	Jean	Jacqueline	None	D'Vorah	Jeff	Monte A.	Sharon	Bobbi	Laurann	Gale Kathleen	James	None	None	Patrick	Cathy	None	Jennifer	Sue	Jeffrey	Charles	David	Dorothy	Mary Jane	Eugene	David	Stuart	Philip	Stephanie	Teresa	Shawn	Teri	Jim	James	Terry Lee	Izak	Joanne	Richard	Colleen	Tiffany	Peter	John	Kevin	Lisa	None	Tracy	Kenneth	Cindy	Christiane	Ronald	Lisa	David	Jeff B.	Linda R.	Shelley	Rebecca	C. Bradshaw	Laura	James A.	Roger	Mark
enty_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
enty_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
enty_city	Sacramento	Sacramento	Walnut Creek	Concord	Brentwood	Stevenson Ranch	Walnut Creek	Spring Valley	Carmel	Mission Viejo	La Mesa	Spring Valley	Simi Valley	San Rafael	Thousand Oaks	Irvine	Goleta	Apple Valley	Huntington Beach	Redding	Thousand Oaks	San Jose	Woodland Hills	Fallbrook	Agoura Hills	Reseda	Sacramento	Sacramento	Sacramento	Orange	West Hills	Redding	Fortuna	Bakersfield	Jamul	Canoga Park	Palm Springs	Carlsbad	Chino Hills	Fresno	Canoga Park	Chino Hills	San Jose	Rancho Santa Margari	San Jose	Vista	Santa Cruz	San Diego	Orange	Los Angeles	Upland	Chatsworth	Upland	Irvine	Rancho Mirage	El Cajon	Santa Barbara	San Bernardino	Corona	Fresno	San Jose	Santa Cruz	Watsonville	Fresno	Martinez	San Bernardino	Rancho Cucamonga	Folsom	Fresno	Lincoln	Redding	Saratoga	Redding	Los Angeles	San Clemente	Redding	Brentwood	Walnut Creek	Camarillo	Thousand Oaks	Chino	Cypress	Camarillo	Yorba Linda	Encino	Upland	Santa Barbara	Watsonville	Irvine	Woodland Hills	Tarzana	Alameda	Newport Beach	Woodland Hills	Redding	Oakland	Redding	Carlsbad	San Francisco	Los Angeles	Riverside	San Ramon	Sunland	Northridge	Los Angeles	Huntington Beach	Granada Hills	Diamond Bar	Tarzana	San Clemente	Carmel	La Mesa	Woodland Hills	San Francisco	San Diego	Alamo	Clayton	San Rafael	La Mesa	Simi Valley	Thousand Oaks	Spring Valley	Woodland Hills	Thousand Oaks	San Jose	Carmel	Walnut Creek	Spring Valley	Fallbrook	Lafayette	Agoura Hills	Mission Viejo	Goleta	Irvine	Huntington Beach	Apple Valley	Redding	Stevenson Ranch	Brentwood	Concord	Walnut Creek	Phelan	Walnut Creek	Carlsbad	San Luis Obispo	San Diego	Walnut Creek	Riverside	Livermore	Arcata	Santa Barbara	Elk Grove	Redwood City	Albany	Thousand Oaks	Anaheim Hills	Tustin	Sacramento	Sacramento	Palos Verdes Peninsu	Westlake Village	Reseda	Sherman Oaks	Sacramento	Sacramento	Sacramento	Simi Valley	Glendora	Cypress	Chino	Thousand Oaks	Camarillo	Walnut Creek	Brentwood	Redding	San Clemente	Los Angeles	Redding	Saratoga	Redding	Lincoln	Fresno	Folsom	Rancho Mirage	El Cajon	Santa Barbara	Irvine	San Jose	San Bernardino	Fresno	Corona	San Bernardino	Rancho Cucamonga	Martinez	Fresno	Watsonville	Santa Cruz	Upland	Upland	Chatsworth	Carlsbad	Canoga Park	Palm Springs	Canoga Park	Fresno	Chino Hills	Rancho Santa Margari	Vista	San Jose	Chino Hills	San Jose	Santa Cruz	San Diego	Orange	Los Angeles	Jamul	Bakersfield	Redding	Orange	Fortuna	West Hills	San Ramon	Riverside	Los Angeles	San Francisco	Carlsbad	Redding	Redding	Oakland	Newport Beach	Woodland Hills	Alameda	Santa Barbara	Watsonville	Woodland Hills	Tarzana	Yorba Linda	Upland	Encino	Encino	Irvine	Lafayette	Camarillo	San Diego	San Francisco	Woodland Hills	La Mesa	Carmel	San Clemente	Tarzana	Diamond Bar	Granada Hills	Northridge	Los Angeles	Sunland	Huntington Beach	Clayton	Alamo	Tustin	Anaheim Hills	Benicia	Thousand Oaks	Albany	Redwood City	Elk Grove	Santa Barbara	Arcata	Livermore	Riverside	Walnut Creek	San Diego	San Luis Obispo	Walnut Creek	Phelan	Carlsbad
enty_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
enty_zip4	95814	95814	94597	94520	94513	91381	94597	91978	93923	92691	91941	91978	93063	94903	91362	92612	93117	92308	92646-8226	96003	91362	95112	91364	92028	91301	91335	95833	95833	95835	92868-6612	91307	96001	95540	93312	91935	91303	92264-7894	92009-6626	91709-6018	93726-4027	91303	91709-2618	95110-1359	92688	95148-2829	92081-8784	95060	92108-4043	92866-3215	90025-4416	91784	91311	91784	92606-1026	92270-1727	92020	93105-3507	92408-3550	92880	93720-2945	95125-4331	95062-2033	95076-0751	93726-0955	94553	92408	91730	95630	93704	95648	96002	95070	96002	90025	92673	96003	94513	94597	93010	91360	91710	90630	93010	92887	91436	91784	93111	95076-3202	92614	91367-4110	91356	94502	92663	91364	96001	94618	96001	92009	94115	90046	92507	94583	91040	91324	90048	92648	91344	91789	91356-4252	92673	93923	91941	91367	94109	92129	94507	94517	94903	91941	93063	91362	91978	91364	91362	95112	93923	94597	91978	92028	94549	91301	92691	93117	92612	92646-8226	92308	96003	91381	94513	94520	94597	92371-8209	94596	92008	93401	92108	94598	92506	94550	95521	93105	95624	94063	94706	91360	92808	92780	95814	95814	90275	91362	91335	91423	95833	95833	95833	93063	91741	90630	91710	91360	93010	94597	94513	96003	92673	90025	96002	95070	96002	95648	93704	95630	92270-1727	92020	93105-3507	92606-1026	95125-4331	92408-3550	93720-2945	92880	92408	91730	94553	93726-0955	95076-0751	95062-2033	91784	91784	91311	92009-6626	91303	92264-7894	91303	93726-4027	91709-6018	92688	92081-8784	95110-1359	91709-2618	95148-2829	95060	92108-4043	92866-3215	90025-4416	91935	93312	96001	92868-6612	95540	91307	94583	92507	90046	94115	92009	96001	96001	94618	92663	91364	94502	93111	95076-3202	91367-4110	91356	92887	91784	91436	91436	92614	94549	93010	92129	94109	91367	91941	93923	92673	91356-4252	91789	91344	91324	90048	91040	92648	94517	94507	92780	92808	94510	91360	94706	94063	95624	93105	95521	94550	92506	94598	92108	93401	94596	92371-8209	92008
ctrib_emp	None	None	Lincoln Financial Advisors	HB Resources Insurance Services, Inc.	Dealey, Renton & Associates	CIS Insurance Services Inc.	beere&purves	Hilanto Financial & Insurance Services, Inc.	Goodacre Insurance Services	Warner Pacific Insurance Services	None	Rogers Benefit Group	Warner Pacific Insurance Services	Word & Brown	Warner Pacific Insurance Services	Moore Benefits, Inc.	Warner Pacific Insurance Services	Mary Metcalfe Insurance Services	Meg McComb Insurance Services	None	DEB Consulting	LISI	Creative Employee Benefits Insurance Service, Inc.	Cyan Insurance Solutions, Inc.	Warner Pacific Insurance Services	M&M Benefit Solutions Insurance Services	None	None	Wraith, Scarlett & Randolph Insurance Services, Inc.	BenefitMall	Merken Insurance & Investment Services	None	Harbers Insurance Agency	First Solutions Insurance Services	Teague Financial Insurance Services, Inc.	Really Great Employee Benefits	Jon Harmon Insurance Services, LLC	Joe Marcus Insurance Services	Good & Associates	Chaffin Insurance Services	Really Great Employee Benefits	Clark & Associates	Prudent Choice Inusrance Services	Kimmarie Simonsen Insurance Services	Beacon Ridge Health Insurance Services	United Health Group	Cecy Insurance Services	Countywide Health Ins. Services, Inc.	BCIS Insurance Services, Inc.	Norman W. Bernier, CLU, ChFC	Ray M. Musser & Associates, Inc.	Hoffman Brown Company	Ray M. Musser & Associates, Inc.	ManageEase, Inc.	William Youngblood Insurance, Inc.	Teague Financial Insurance Services	Santaella & Associates	The Henehan Company	Options in Insurance Agency LLC	Horstmann Financial & Insurance Services	Kirk Stoddard Agency	Progressive Benefit Group	Coast Benefits & Insurance Services, Inc.	Mike Rude Insurance Services	Payroll Systems	Joseph E. Henehan Financial and Insurance Services, Inc.	Self Employed - David N. Johnston	Transamerica	Administrative Solutions, Inc.	Shepler & Fear General Agency	None	None	None	First Financial Resources	None	None	None	None	None	Mike Kenney Insurance Agency	Webb Insurance Solutions	Easy Choice Health Plan	HLS Insurance Services Corporation	Advanced Benefit Consulting & Insurance Services, Inc.	Brecher Insurance & Financial Services	Morgan & Franz Insurance and Financial Services, Inc.	Larsen Insurance	KBK Insurance Agency	AXA Advisors, LLC	Underhill Insurance Agency	Corporate Benefit Marketing	Beere & Purves Inc.	Bridgeport Benefits	None	None	Burns Employee Benefits Insurance Services, LLC	None	James M. Morrison Insurance Services, Inc.	Claremont Insurance Services	M&M Benefits Solutions Insurance Services	PayPro Administrators	Ashby & Hammond Insurance Services	PGH Insurance Marketing	Colleen King Insurance Agency	BenefitMall	John Ringer Insurance	Manning Insurance Services dba Accessible Health Insurance	Fisher & Associates	Q.S.R Insurance Agency	Executive Financial Advisors, Inc.	James W. Goodacre II RHU,REBC	Prescott & Lowther Insurance Agency	Leavitt Insurance Services Los Angeles	Pinnacle Claims	Terri Yurek Insurance Services	Anthem Blue Cross	KR Benefits Insurance Services	Word & Brown	None	Warner Pacific Insurance Services	Warner Pacific Insurance Services	Rogers Benefit Group	Creative Employee Benefits Insurance Service, Inc.	DEB Consulting	LISI	Goodacre Insurance Services	beere&purves	Hilanto Financial & Insurance Services, Inc.	Cyan Insurance Solutions, Inc.	Lee Health Insurance Services (BLIS Corporation)	Warner Pacific Insurance Services	Warner Pacific Insurance Services	Warner Pacific Insurance Services	Moore Benefits, Inc.	Meg McComb Insurance Services	Mary Metcalfe Insurance Services	None	CIS Insurance Services Inc.	Dealey, Renton & Associates	HB Resources Insurance Services, Inc.	Lincoln Financial Advisors	Fortier Insurance & Investment Services	Holt Financial Services	Haskell Enrollment & Insurance Services, Inc.	Humana	C. Bradshaw Davis, CLU, ChFC, CLTC	Warner Pacific Insurance Services	Dickerson Employee Benefits	Herzog Insurance Agency, Inc.	Anderson Robinson Starkey Insurance	Peters & Milam Insurance Services	AFLAC	RSC Financial & Insurance Services, Inc.	Broner Financial Services	Word & Brown	Blue Shield of California	None	None	None	None	None	M&M Benefit Solutions Insurance Services	Underhill Insurance Agency, Inc.	None	None	None	Warner Pacific Insurance Services	Kirk Warner Insurance Agency	Easy Choice Health Plan	Webb Insurance Solutions	Mike Kenney Insurance Agency	None	None	None	None	None	First Financial Resources	None	None	None	Shepler & Fear General Agency	Administrative Solutions, Inc.	Transamerica	William Youngblood Insurance, Inc.	Teague Financial Insurance Services	Santaella & Associates	ManageEase, Inc.	Kirk Stoddard Agency	The Henehan Company	Horstmann Financial & Insurance Services	Options in Insurance Agency LLC	Joseph E. Henehan Financial and Insurance Services, Inc.	Self Employed - David N. Johnston	Payroll Systems	Mike Rude Insurance Services	Coast Benefits & Insurance Services, Inc.	Progressive Benefit Group	Ray M. Musser & Associates, Inc.	Ray M. Musser & Associates, Inc.	Hoffman Brown Company	Joe Marcus Insurance Services	Really Great Employee Benefits	Jon Harmon Insurance Services, LLC	Really Great Employee Benefits	Chaffin Insurance Services	Good & Associates	Kimmarie Simonsen Insurance Services	United Health Group	Prudent Choice Inusrance Services	Clark & Associates	Beacon Ridge Health Insurance Services	Cecy Insurance Services	Countywide Health Ins. Services, Inc.	BCIS Insurance Services, Inc.	Norman W. Bernier, CLU, ChFC	Teague Financial Insurance Services, Inc.	First Solutions Insurance Services	None	BenefitMall	Harbers Insurance Agency	Merken Insurance & Investment Services	Ashby & Hammond Insurance Services	PayPro Administrators	M&M Benefits Solutions Insurance Services	Claremont Insurance Services	James M. Morrison Insurance Services, Inc.	None	None	Burns Employee Benefits Insurance Services, LLC	Bridgeport Benefits	None	Beere & Purves Inc.	Larsen Insurance	KBK Insurance Agency	Underhill Insurance Agency	Corporate Benefit Marketing	Advanced Benefit Consulting & Insurance Services, Inc.	Morgan & Franz Insurance and Financial Services, Inc.	Eugene Rowe & Associates, Inc.	Brecher Insurance & Financial Services	AXA Advisors, LLC	Lee Health Insurance Services (BLIS Corporation)	HLS Insurance Services Corporation	Terri Yurek Insurance Services	Pinnacle Claims	Leavitt Insurance Services Los Angeles	Prescott & Lowther Insurance Agency	James W. Goodacre II RHU,REBC	Executive Financial Advisors, Inc.	Q.S.R Insurance Agency	Fisher & Associates	Manning Insurance Services dba Accessible Health Insurance	Colleen King Insurance Agency	BenefitMall	PGH Insurance Marketing	John Ringer Insurance	KR Benefits Insurance Services	Anthem Blue Cross	None	Blue Shield of California	Coker Wayne & Associates	Word & Brown	Broner Financial Services	RSC Financial & Insurance Services, Inc.	AFLAC	Peters & Milam Insurance Services	Anderson Robinson Starkey Insurance	Herzog Insurance Agency, Inc.	Dickerson Employee Benefits	Warner Pacific Insurance Services	C. Bradshaw Davis, CLU, ChFC, CLTC	Humana	Holt Financial Services	Fortier Insurance & Investment Services	Haskell Enrollment & Insurance Services, Inc.
ctrib_occ	None	None	Insurance Agent	Broker	Insurance Agent	Insurance Agent	Sales Representative	Agent / Broker	Insurance Agent	Account Executive	None	Account Executive	Sales Executive	Health Insurance Sales	Insurance Management	President	Regional Sales Manager	Broker	Insurance Broker	None	Owner	Regional Sales Manager	Insurance Agent/Broker	Insurance Agent	Healthcare Sales	Insurance Agent / Owner	None	None	V.P. Employee Benefits, Owner	Broker Sales Executive	Insurance and Investment Broker	None	Insurance Broker	Broker	Insurance Agent	Employee Benefits	Insurance Agent	Insurance Sales	Broker	Insurance Agent	Employee Benefits	Broker	Insurance Broker	Health & Life Insurance Agent	Insurance Broker	Health Insurance Agent	Insurance Broker	Insurance Agent	President	Insurance Broker	Insurance Agent	Broker	Insurance Agent	Director, Employee Benefits	Insurance Broker	Insurance Agent	Insurance Broker	Life & Health Broker	Agent	Employee Benefit Administrator	Broker	Owner	Owner	Independent Agent	VP Business Development	Insurance Agent	Insurance Sales	Regional Vice President	Vice President of Sales	Agent / Consultant	None	None	None	Certified Financial Planner and Certified Senior Advisor	None	None	None	None	None	Insurance Agent	President	District Sales Manager	Agent	Health Insurance Agent	Insurance Broker	Executive	Agent - Insurance Sales	Insurance Broker	Financial Consultant	Insurance Broker/Owner	Broker	Director of Sales	Insurance Sales	None	None	Insurance Broker	None	Insurance Broker	Sales	Insurance Sales	Vice President	Insurance Agent	Insurance Broker	Insurance Agent	Vice President, Carrier Relations	Life & Health Broker	CEO & Owner	Business Development and Client Consulting	Owner	Insurance Agent	Insurance Broker	Health Insurance Broker	Employee Benefits Consultant / Managing Principal	Director of Sales	Insurance Broker	Specialty Sales Executive	Insurance Broker	Health Insurance Sales	None	Sales Executive	Insurance Management	Account Executive	Insurance Agent/Broker	Owner	Regional Sales Manager	Insurance Agent	Sales Representative	Agent / Broker	Insurance Agent	Insurance Broker	Healthcare Sales	Account Executive	Regional Sales Manager	President	Insurance Broker	Broker	None	Insurance Agent	Insurance Agent	Broker	Insurance Agent	Insurance Sales	Broker	Broker, President, and CEO	Agency Relationship Manager	Insurance Agent	Healthcare Insurance Sales	Director of Sales	Sales Manager	Insurance Broker	Insurance Agent	Insurance	Insurance Agent	Broker	Field Sales Director	Regional Sales Executive	None	None	None	None	None	Insurance Agent / Owner	Agent - Broker / Vice President	None	None	None	Sales Executive	Insurance Sales	District Sales Manager	President	Insurance Agent	None	None	None	None	None	Certified Financial Planner and Certified Senior Advisor	None	None	None	Agent / Consultant	Vice President of Sales	Regional Vice President	Insurance Broker	Insurance Agent	Insurance Broker	Director, Employee Benefits	Broker	Life & Health Broker	Employee Benefit Administrator	Agent	Insurance Agent	Insurance Sales	VP Business Development	Independent Agent	Owner	Owner	Insurance Agent	Insurance Agent	Broker	Insurance Sales	Employee Benefits	Insurance Agent	Employee Benefits	Insurance Agent	Broker	Health & Life Insurance Agent	Health Insurance Agent	Insurance Broker	Broker	Insurance Broker	Insurance Broker	Insurance Agent	President	Insurance Broker	Insurance Agent	Broker	None	Broker Sales Executive	Insurance Broker	Insurance and Investment Broker	Insurance Agent	Vice President	Insurance Sales	Sales	Insurance Broker	None	None	Insurance Broker	Insurance Sales	None	Director of Sales	Agent - Insurance Sales	Insurance Broker	Insurance Broker/Owner	Broker	Health Insurance Agent	Executive	Insurance Broker	Insurance Broker	Financial Consultant	Insurance Broker	Agent	Insurance Broker	Director of Sales	Employee Benefits Consultant / Managing Principal	Health Insurance Broker	Insurance Broker	Insurance Agent	Owner	Business Development and Client Consulting	CEO & Owner	Insurance Agent	Vice President, Carrier Relations	Insurance Broker	Life & Health Broker	Insurance Broker	Specialty Sales Executive	None	Regional Sales Executive	Broker	Field Sales Director	Broker	Insurance Agent	Insurance	Insurance Agent	Insurance Broker	Sales Manager	Director of Sales	Healthcare Insurance Sales	Insurance Agent	Agency Relationship Manager	Broker	Insurance Sales	Broker, President, and CEO
ctrib_self	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
elec_date	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ctrib_date	2017-08-23 00:00:00	2017-08-23 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-08-11 00:00:00	2017-08-14 00:00:00	2017-08-14 00:00:00	2017-08-17 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-10 00:00:00	2017-08-23 00:00:00	2017-08-23 00:00:00	2017-07-03 00:00:00	2017-07-03 00:00:00	2017-07-11 00:00:00	2017-07-20 00:00:00	2017-07-24 00:00:00	2017-07-26 00:00:00	2017-07-26 00:00:00	2017-07-26 00:00:00	2017-07-28 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00	2017-07-10 00:00:00
date_thru	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
amount	36500	1000	100	85	85	21	21	85	25	21	85	42	21	250	85	21	21	21	85	85	21	60	85	25	21	10	3800	1200	500	20	42	42	21	25	100	100	25	20	30	21	100	15	42	21	85	21	50	170	60	21	21	21	21	21	21	21	100	21	42	21	21	60	21	21	21	85	21	25	21	25	42	85	42	21	85	42	21	21	42	100	85	42	85	85	25	170	21	85	21	60	85	21	85	42	85	85	21	90	85	21	21	21	100	21	21	21	85	21	50	21	21	21	21	21	85	25	21	250	85	21	85	42	85	21	60	25	21	85	25	42	21	21	21	21	85	21	85	21	85	85	100	100	85	85	15	21	21	30	85	85	60	21	21	25	21	21	25	36500	1000	250	400	10	250	2500	4700	5300	100	250	42	85	100	42	21	21	42	85	21	42	85	42	25	21	25	21	21	100	21	21	21	21	42	85	21	21	21	21	60	21	21	21	20	100	25	100	21	30	21	21	42	15	85	50	170	60	21	100	25	42	20	21	42	21	21	21	85	90	21	85	85	85	42	21	21	85	60	85	85	170	85	25	21	21	85	85	21	21	21	21	21	50	21	85	21	21	100	21	21	25	25	21	25	21	25	21	21	60	85	85	30	21	21	15	85	100	85
cmte_id	810163	810163	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	810163	810163	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_naml	California Republican Party	California Republican Party	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	California Republican Party	California Republican Party	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
office_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
offic_dscr	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
juris_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
juris_dscr	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
dist_no	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
off_s_h_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bal_name	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bal_num	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bal_juris	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
memo_code	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
memo_refno	EXP:S497:48909	EXP:S497:48910	INC:A:48875	INC:A:48876	INC:A:48877	INC:A:48878	INC:A:48879	INC:A:48880	INC:A:48881	INC:A:48882	INC:A:48883	INC:A:48884	INC:A:48885	INC:A:48886	INC:A:48887	INC:A:48888	INC:A:48889	INC:A:48890	INC:A:48891	INC:A:48892	INC:A:48893	INC:A:48894	INC:A:48895	INC:A:48896	INC:A:48897	INC:A:48898	INC:A:48900	INC:A:48901	INC:A:48908	INC:A:48931	INC:A:48932	INC:A:48933	INC:A:48934	INC:A:48935	INC:A:48936	INC:A:48937	INC:A:48938	INC:A:48939	INC:A:48940	INC:A:48941	INC:A:48942	INC:A:48944	INC:A:48945	INC:A:48946	INC:A:48947	INC:A:48948	INC:A:48949	INC:A:48950	INC:A:48951	INC:A:48952	INC:A:48953	INC:A:48954	INC:A:48955	INC:A:48956	INC:A:48957	INC:A:48958	INC:A:48959	INC:A:48960	INC:A:48961	INC:A:48962	INC:A:48963	INC:A:48965	INC:A:48966	INC:A:48969	INC:A:48970	INC:A:48971	INC:A:48972	INC:A:48974	INC:A:48975	INC:A:48976	INC:A:48977	INC:A:48978	INC:A:48981	INC:A:48982	INC:A:48983	INC:A:48984	INC:A:48985	INC:A:48986	INC:A:48987	INC:A:48988	INC:A:48989	INC:A:48990	INC:A:48991	INC:A:48992	INC:A:48993	INC:A:48994	INC:A:48995	INC:A:48996	INC:A:48997	INC:A:48998	INC:A:48999	INC:A:49000	INC:A:49001	INC:A:49002	INC:A:49004	INC:A:49005	INC:A:49006	INC:A:49007	INC:A:49008	INC:A:49009	INC:A:49012	INC:A:49013	INC:A:49015	INC:A:49016	INC:A:49017	INC:A:49018	INC:A:49019	INC:A:49020	INC:A:49021	INC:A:49022	INC:A:49023	INC:A:49024	INC:A:49025	INC:A:49026	INC:A:49027	INC:A:49030	INC:A:49031	INC:A:49032	INC:A:49033	INC:A:49034	INC:A:49035	INC:A:49036	INC:A:49037	INC:A:49038	INC:A:49039	INC:A:49040	INC:A:49041	INC:A:49042	INC:A:49043	INC:A:49044	INC:A:49045	INC:A:49046	INC:A:49047	INC:A:49048	INC:A:49049	INC:A:49050	INC:A:49051	INC:A:49052	INC:A:49053	INC:A:49054	INC:A:49055	INC:A:49056	INC:A:49057	INC:A:49058	INC:A:49059	INC:A:49060	INC:A:49061	INC:A:49062	INC:A:49063	INC:A:49064	INC:A:49066	INC:A:49068	INC:A:49069	INC:A:49070	INC:A:49071	INC:A:49072	INC:A:49073	EXP:S497:48909	EXP:S497:48910	INC:A:48575	INC:A:48576	INC:A:48726	INC:A:48734	INC:A:48737	INC:A:48738	INC:A:48739	INC:A:48740	INC:A:48741	INC:A:48744	INC:A:48745	INC:A:48746	INC:A:48747	INC:A:48748	INC:A:48749	INC:A:48750	INC:A:48751	INC:A:48752	INC:A:48753	INC:A:48756	INC:A:48757	INC:A:48758	INC:A:48759	INC:A:48760	INC:A:48762	INC:A:48763	INC:A:48764	INC:A:48766	INC:A:48767	INC:A:48768	INC:A:48769	INC:A:48770	INC:A:48773	INC:A:48774	INC:A:48775	INC:A:48776	INC:A:48777	INC:A:48778	INC:A:48779	INC:A:48780	INC:A:48781	INC:A:48782	INC:A:48783	INC:A:48784	INC:A:48785	INC:A:48786	INC:A:48787	INC:A:48788	INC:A:48789	INC:A:48791	INC:A:48792	INC:A:48793	INC:A:48794	INC:A:48795	INC:A:48796	INC:A:48797	INC:A:48798	INC:A:48799	INC:A:48800	INC:A:48801	INC:A:48802	INC:A:48803	INC:A:48805	INC:A:48806	INC:A:48809	INC:A:48810	INC:A:48811	INC:A:48812	INC:A:48813	INC:A:48814	INC:A:48815	INC:A:48816	INC:A:48817	INC:A:48818	INC:A:48819	INC:A:48820	INC:A:48821	INC:A:48822	INC:A:48823	INC:A:48824	INC:A:48825	INC:A:48826	INC:A:48827	INC:A:48828	INC:A:48831	INC:A:48832	INC:A:48833	INC:A:48834	INC:A:48835	INC:A:48836	INC:A:48837	INC:A:48838	INC:A:48839	INC:A:48840	INC:A:48841	INC:A:48842	INC:A:48843	INC:A:48844	INC:A:48845	INC:A:48856	INC:A:48857	INC:A:48858	INC:A:48859	INC:A:48860	INC:A:48861	INC:A:48862	INC:A:48864	INC:A:48866	INC:A:48867	INC:A:48868	INC:A:48869	INC:A:48870	INC:A:48871	INC:A:48872	INC:A:48873	INC:A:48874
bal_id	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_id	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sup_off_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sup_opp_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None