Home

Filer ID: 1385619

Table: cvr_lobby_disclosure

filing_id		2060117		2099980		2174680		2156575		2126759		2192723		2275688		2210816		2242590		2344877		2398026		2380439		2319387		2419596		2470076		2440231		2528262		2486719		2550767		2599513		2624825		2580623		2678021		2644954		2707474		2746686
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635
sender_id		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619
filer_id		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619
entity_cd		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM
filer_naml		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)
filer_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
filer_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
filer_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
report_num		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2016-07-22 00:00:00		2016-10-21 00:00:00		2017-07-13 00:00:00		2017-04-26 00:00:00		2017-01-16 00:00:00		2017-10-11 00:00:00		2018-07-10 00:00:00		2018-01-13 00:00:00		2018-04-17 00:00:00		2019-01-10 00:00:00		2019-07-10 00:00:00		2019-04-11 00:00:00		2018-10-17 00:00:00		2019-10-11 00:00:00		2020-04-14 00:00:00		2020-01-09 00:00:00		2020-10-09 00:00:00		2020-07-14 00:00:00		2021-01-13 00:00:00		2021-07-13 00:00:00		2021-10-13 00:00:00		2021-04-16 00:00:00		2022-04-20 00:00:00		2022-01-11 00:00:00		2022-07-22 00:00:00		2022-10-16 00:00:00
from_date		2016-04-01 00:00:00		2016-07-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2016-10-01 00:00:00		2017-07-01 00:00:00		2018-04-01 00:00:00		2017-10-01 00:00:00		2018-01-01 00:00:00		2018-10-01 00:00:00		2019-04-01 00:00:00		2019-01-01 00:00:00		2018-07-01 00:00:00		2019-07-01 00:00:00		2020-01-01 00:00:00		2019-10-01 00:00:00		2020-07-01 00:00:00		2020-04-01 00:00:00		2020-10-01 00:00:00		2021-04-01 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2021-10-01 00:00:00		2022-04-01 00:00:00		2022-07-01 00:00:00
thru_date		2016-06-30 00:00:00		2016-09-30 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2016-12-31 00:00:00		2017-09-30 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2018-03-31 00:00:00		2018-12-31 00:00:00		2019-06-30 00:00:00		2019-03-31 00:00:00		2018-09-30 00:00:00		2019-09-30 00:00:00		2020-03-31 00:00:00		2019-12-31 00:00:00		2020-09-30 00:00:00		2020-06-30 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2021-09-30 00:00:00		2021-03-31 00:00:00		2022-03-31 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00		2022-09-30 00:00:00
cum_beg_dt		2016-04-01 00:00:00		2016-04-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2016-04-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00
firm_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1385619		None		1385619		1385619
firm_name		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)
firm_city		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND
firm_st		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR
firm_zip4		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229
firm_phon		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651
mail_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_date		2016-07-22 00:00:00		2016-10-21 00:00:00		2017-07-13 00:00:00		2017-04-26 00:00:00		2017-01-16 00:00:00		2017-10-11 00:00:00		2018-07-10 00:00:00		2018-01-13 00:00:00		2018-04-17 00:00:00		2019-01-10 00:00:00		2019-07-10 00:00:00		2019-04-11 00:00:00		2018-10-17 00:00:00		2019-10-11 00:00:00		2020-04-14 00:00:00		2020-01-09 00:00:00		2020-10-09 00:00:00		2020-07-14 00:00:00		2021-01-13 00:00:00		2021-07-13 00:00:00		2021-10-13 00:00:00		2021-04-16 00:00:00		2022-04-20 00:00:00		2022-01-11 00:00:00		2022-07-22 00:00:00		2022-10-16 00:00:00
sig_loc		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR
sig_naml		MILLER, M.D.		MILLER, M.D.		BONILLA, MD		MILLER, M.D.		MILLER, M.D.		SCHWINDT, MD		SCHWINDT, MD		SCHWINDT, MD		SCHWINDT, MD		SCHWINDT, MD		EITCHES, MD		EITCHES, MD		SCHWINDT, MD		EITCHES, MD		EITCHES, MD		EITCHES, MD		SCHWINDT, MD		SCHWINDT, MD		ANDERSON		ANDERSON		ANDERSON		ANDERSON		ANDERSON		ANDERSON		ANDERSON		ANDERSON
sig_namf		TRAVIS A.		TRAVIS A.		SHEILA		TRAVIS A.		TRAVIS A.		CHRISTINA		CHRISTINA		CHRISTINA		CHRISTINA		CHRISTINA		ROBERT		ROBERT		CHRISTINA		ROBERT		ROBERT		ROBERT		CHRISTINA		CHRISTINA		KAROL		KAROL		KAROL		KAROL		KAROL		KAROL		KAROL		KAROL
sig_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
sig_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
prn_naml		MILLER, M.D.		MILLER, M.D.		BONILLA, MD		MILLER, M.D.		MILLER, M.D.		SCHWINDT, MD		SCHWINDT, MD		SCHWINDT, MD		SCHWINDT, MD		SCHWINDT, MD		EITCHES, MD		EITCHES, MD		SCHWINDT, MD		EITCHES, MD		EITCHES, MD		EITCHES, MD		SCHWINDT, MD		SCHWINDT, MD		ANDERSON		ANDERSON		ANDERSON		ANDERSON		ANDERSON		ANDERSON		ANDERSON		ANDERSON
prn_namf		TRAVIS A.		TRAVIS A.		SHEILA		TRAVIS A.		TRAVIS A.		CHRISTINA		CHRISTINA		CHRISTINA		CHRISTINA		CHRISTINA		ROBERT		ROBERT		CHRISTINA		ROBERT		ROBERT		ROBERT		CHRISTINA		CHRISTINA		KAROL		KAROL		KAROL		KAROL		KAROL		KAROL		KAROL		KAROL
prn_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
prn_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
sig_title		PRESIDENT 4565KAU		PRESIDENT 4565KAU		PRESIDENT 4565KAU		PRESIDENT 4565KAU		PRESIDENT 4565KAU		PRESIDENT 4565KAU		PRESIDENT 4565SSB		PRESIDENT 4565KAU		PRESIDENT 4565SSB		PRESIDENT 4565SSB		PRESIDENT 4565SSB		PRESIDENT 4565SSB		PRESIDENT 4565SSB		PRESIDENT 4565SSB		PRESIDENT 4565SSB		PRESIDENT 4565SSB		PRESIDENT 4565SSB		PRESIDENT 4565SSB		ADMINISTRATIVE DIRECTOR		ADMINISTRATIVE DIRECTOR		ADMINISTRATIVE DIRECTOR		ADMINISTRATIVE DIRECTOR		ADMINISTRATIVE DIRECTOR		ADMINISTRATIVE DIRECTOR		ADMINISTRATIVE DIRECTOR		ADMINISTRATIVE DIRECTOR
nopart1_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nopart2_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
part1_1_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
part1_2_cb		None		None		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_n_cb		None		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X
ctrib_y_cb		X		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lby_actvty		AB 1386		AB 1384, 1386		SB 562		NONE		NONE		SB 790		NONE		NONE		NONE		NONE		AB 1531, SB 207, SB 276, SB 677		AB 1532		AB 3088, 3098		SB 207, SB 276, SB 677		NONE		NONE		AB 890		AB 890		NONE		SB 242, AB 650, AB 359, AB 1130; GOVERNOR'S OFFICE RE: STATE BUDGET		AB 359; SB 242; DEPARTMENT OF FINANCE, DEPARTMENT OF PUBLIC HEALTH RE: STATE BUDGET		NONE		NONE		NONE		NONE		AB 2098, 2236, 2640
lobby_n_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lobby_y_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_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
major_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
major_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
rcpcmte_nm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpcmte_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

Table: cvr_registration

filing_id		2062221		2115276		2334280		2543146
amend_id		0		0		0		0
rec_type		CVR		CVR		CVR		CVR
form_type		F602		F602		F602		F602
sender_id		1354236		1354236		1354236		1354236
filer_id		1385619		1385619		1385619		1385619
entity_cd		LEM		LEM		LEM		LEM
filer_naml		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)
filer_namf		None		None		None		None
filer_namt		None		None		None		None
filer_nams		None		None		None		None
report_num		000		000		000		000
rpt_date		2016-04-15 00:00:00		2016-11-22 00:00:00		2018-11-08 00:00:00		2020-12-09 00:00:00
ls_beg_yr		2015		2017		2019		2021
ls_end_yr		2016		2018		2020		2022
qual_date		None		None		None		None
eff_date		2016-05-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00
bus_city		PORTLAND		PORTLAND		PORTLAND		PORTLAND
bus_st		OR		OR		OR		OR
bus_zip4		97229		97229		97229		97229
bus_phon		(971) 244-2651		(971) 244-2651		(971) 244-2651		(971) 244-2651
bus_fax		None		None		None		None
bus_email		None		None		None		None
mail_city		None		None		None		None
mail_st		None		None		None		None
mail_zip4		None		None		None		None
mail_phon		None		None		None		None
sig_date		2016-04-15 00:00:00		2016-04-15 00:00:00		2018-11-08 00:00:00		2020-12-09 00:00:00
sig_loc		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR		PORTLAND, OR
sig_naml		MILLER, M.D.		MILLER, M.D.		SCHWINDT		ANDERSON
sig_namf		TRAVIS A.		TRAVIS A.		CHRISTINA		KAROL
sig_namt		None		None		None		None
sig_nams		None		None		None		None
prn_naml		MILLER, M.D.		MILLER, M.D.		SCHWINDT		ANDERSON
prn_namf		TRAVIS A.		TRAVIS A.		CHRISTINA		KAROL
prn_namt		None		None		None		None
prn_nams		None		None		None		None
sig_title		PRESIDENT		PRESIDENT		PRESIDENT		ADMINISTRATIVE DIRECTOR
stmt_firm		None		None		None		None
ind_cb		None		None		None		None
bus_cb		X		X		X		X
trade_cb		None		None		None		None
oth_cb		None		None		None		None
a_b_name		None		None		None		None
a_b_city		None		None		None		None
a_b_st		None		None		None		None
a_b_zip4		None		None		None		None
descrip_1		ALLERGY AND IMMUNOLOGY		ALLERGY AND IMMUNOLOGY		ALLERGY AND IMMUNOLOGY		ALLERGY AND IMMUNOLOGY
descrip_2		None		None		None		None
c_less50		None		None		None		None
c_more50		None		None		None		None
ind_class		None		None		None		None
ind_descr		None		None		None		None
bus_class		OTH		OTH		OTH		OTH
bus_descr		HEALTHCARE		HEALTHCARE		HEALTHCARE		HEALTHCARE
auth_name		CLEAR ADVOCACY		CLEAR ADVOCACY		CLEAR ADVOCACY		CLEAR ADVOCACY
auth_city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
auth_st		CA		CA		CA		CA
auth_zip4		95814		95814		95814		95814
lobby_int		None		None		None		None
influen_yn		None		None		None		None
firm_name		None		None		None		None
newcert_cb		None		None		None		None
rencert_cb		None		None		None		None
complet_dt		None		None		None		None
lby_reg_cb		None		None		None		None
lby_604_cb		None		None		None		None
st_leg_yn		None		None		None		None
st_agency		None		None		None		None
lobby_cb		None		None		None		None
l_firm_cb		None		None		None		None

Table: filer_acronyms

acronym		CSAAI
filer_id		1385619

Table: filer_address

filer_id		1385619		1385619		1385619		1385619		1385619
adrid		2395990		2518327		2415835		2553741		2472471
effect_dt		2016-05-01 00:00:00		2021-01-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00		2019-01-01 00:00:00
add_type		7051		7051		7051		7051		7051
session_id		2015		2021		2017		2023		2019

Table: filer_filings

filer_id		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619
filing_id		2419596		2550767		2334280		2440231		2380439		2041271		2041282		2062221		2060117		2099980		2126759		2115276		2156575		2141411		2174680		2319387		2275688		2398026		2242590		2344877		2543146		2363169		2528262		2486719		2210816		2470076		2192723		2584528		2599513		2678021		2707474		2624825		2580623		2644954		2746686
period_id		239		244		236		240		237		None		None		226		226		227		228		228		229		None		230		235		234		238		233		236		244		None		243		242		232		241		231		None		246		249		250		247		245		248		251
form_id		F635		F635		F602		F635		F635		F602		F999		F602		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		2019-10-31 00:00:00		2021-01-29 00:00:00		2019-01-14 00:00:00		2020-01-30 00:00:00		2019-04-30 00:00:00		2016-05-05 00:00:00		2016-05-05 00:00:00		2016-07-29 00:00:00		2016-07-28 00:00:00		2016-10-29 00:00:00		2017-01-30 00:00:00		2016-12-29 00:00:00		2017-04-29 00:00:00		2016-12-29 00:00:00		2017-07-30 00:00:00		2018-10-31 00:00:00		2018-07-31 00:00:00		2019-07-31 00:00:00		2018-04-30 00:00:00		2019-01-30 00:00:00		2021-01-10 00:00:00		2019-01-14 00:00:00		2020-10-30 00:00:00		2020-07-31 00:00:00		2018-01-31 00:00:00		2020-04-30 00:00:00		2017-10-30 00:00:00		2021-01-12 00:00:00		2021-07-29 00:00:00		2022-05-02 00:00:00		2022-08-01 00:00:00		2021-11-01 00:00:00		2021-04-30 00:00:00		2022-01-31 00:00:00		2022-10-30 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10005		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001
stmnt_status		11001		11001		11003		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11003
session_id		2019		2019		2019		2019		2019		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2019		2017		2017		2021		2019		2019		2019		2017		2019		2017		2021		2021		2021		2021		2021		2021		2021		2021
user_id		SUSHAKOV		GTAYLOR		CAFILER		GTAYLOR		VUKSTINA		GPEREZ		GPEREZ		CAFILER		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		AGLADNEY		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		VUKSTINA		AGLADNEY		AGLADNEY		MKIRKHAM		DMCCASTL		GTAYLOR		MKIRKHAM		AGLADNEY		GTAYLOR		AGLADNEY		MKIRKHAM		GTAYLOR		CAFILER		CAFILER		MKIRKHAM		GTAYLOR		GTAYLOR		CAFILER
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11003		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11001		11003
rpt_start		2019-07-01 00:00:00		2020-10-01 00:00:00		2018-11-08 00:00:00		2019-10-01 00:00:00		2019-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2016-04-15 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		2016-11-22 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2018-07-01 00:00:00		2018-04-01 00:00:00		2019-04-01 00:00:00		2018-01-01 00:00:00		2018-10-01 00:00:00		2020-12-09 00:00:00		1900-01-01 00:00:00		2020-07-01 00:00:00		2020-04-01 00:00:00		2017-10-01 00:00:00		2020-01-01 00:00:00		2017-07-01 00:00:00		1900-01-01 00:00:00		2021-04-01 00:00:00		2022-01-01 00:00:00		2022-04-01 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2021-10-01 00:00:00		2022-07-01 00:00:00
rpt_end		2019-09-30 00:00:00		2020-12-31 00:00:00		2018-11-08 00:00:00		2019-12-31 00:00:00		2019-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2016-04-15 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2016-11-22 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2018-09-30 00:00:00		2018-06-30 00:00:00		2019-06-30 00:00:00		2018-03-31 00:00:00		2018-12-31 00:00:00		2020-12-09 00:00:00		1900-01-01 00:00:00		2020-09-30 00:00:00		2020-06-30 00:00:00		2017-12-31 00:00:00		2020-03-31 00:00:00		2017-09-30 00:00:00		1900-01-01 00:00:00		2021-06-30 00:00:00		2022-03-31 00:00:00		2022-06-30 00:00:00		2021-09-30 00:00:00		2021-03-31 00:00:00		2021-12-31 00:00:00		2022-09-30 00:00:00
rpt_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
filing_type		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001

Table: filer_interests

filer_id		1385619		1385619		1385619		1385619		1385619
session_id		2017		2019		2015		2021		2023
interest_cd		40312		40312		40306		40312		40312
effect_date		2017-01-01 00:00:00		2019-01-01 00:00:00		2016-05-01 00:00:00		2021-01-01 00:00:00		2023-01-01 00:00:00

Table: filer_to_filer_type

filer_id		1385619		1385619		1385619		1385619		1385619
filer_type		1		1		1		1		1
active		Y		Y		Y		Y		N
race		None		None		0		None		None
session_id		2021		2019		2015		2017		2023
category		None		None		0		None		None
category_type		None		None		0		None		None
sub_category		None		None		0		None		None
effect_dt		2021-01-01 00:00:00		2019-01-01 00:00:00		2016-05-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		None		None		0		None		None
election_type		None		None		0		None		None
sub_category_a		None		None		None		None		None
nyq_dt		None		None		None		None		None
party_cd		None		None		0		None		None
county_cd		None		None		0		None		None
district_cd		None		None		0		None		None

Table: filer_xref

filer_id		1385619
xref_id		1385619
effect_dt		2016-05-10 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619
filer_id		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619		1385619
filer_type		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT
status		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00
naml		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)
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
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
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
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND		PORTLAND
st		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR		OR
zip4		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229		97229
phon		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651		9712442651
fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filers

filer_id		1385619

Table: lobbying_chg_log

filer_id		1385619
change_no		0
session_id		2015
log_dt		2016-05-05 00:00:00
filer_type		1
correction_flg		Y
action		ADDED
attribute_changed		FIRM
ethics_dt		None
interests		None
filer_full_name		CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)
filer_city		None
filer_st		None
filer_zip		None
filer_phone		None
entity_type		3
entity_name		CLEAR ADVOCACY, LLC
entity_city		None
entity_st		None
entity_zip		None
entity_phone		None
entity_id		1354236
responsible_officer		None
effect_dt		2016-05-01 00:00:00

Table: received_filings

filer_id		1385619		1385619		1385619
filing_file_name		2678021_0.cal		2746686_0.cal		2707474_0.cal
received_date		2022-05-02 00:00:00		2022-10-30 00:00:00		2022-08-01 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		2678021		2746686		2707474
form_id		F635		F635		F635
receive_comment		Filing accepted		Filing accepted		Filing accepted