Home

Filer ID: 1319173

Table: cvr_lobby_disclosure
filing_id   1433872   1450101   1503878   1463182   1482663   1706804   1763781   1734716   1763781   1800592   1783500   1814911   1872747   1844631   1909603   1981767   1965430   1933529   1996374   2061183   2033712   2012717   2101791   2158166   2158166   2130857   2176975   2191420   2207663   2271754   2236357   2318448   2380840   2346360   2443572   2399201   2419250   2399201   2469404   2554985   2531693   2484409   2600951   2625044   2578705   2641807   2676921   2707068   2747549
amend_id   0   0   0   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   1   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   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   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   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173
filer_id   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173
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   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   American Cancer Society Cancer Action Network (ACS CAN)   American Cancer Society Cancer Action Network (ACS CAN)   American Cancer Society Cancer Action Network (ACS CAN)   American Cancer Society Cancer Action Network (ACS CAN)   American Cancer Society Cancer Action Network (ACS CAN)   American Cancer Society Cancer Action Network (ACS CAN)   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network (ACS CAN)   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.
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   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   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   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   001   000   000   000   000   000   000   000   000   000   000   000   000   000   000   001   000   000   000   000   000   000   000   000   000   000   000   001   000   000   000   000   000   000   000   000   000   000   000   000   000
rpt_date   2009-07-27 00:00:00   2009-10-27 00:00:00   2010-07-27 00:00:00   2010-01-29 00:00:00   2010-04-27 00:00:00   2012-10-29 00:00:00   2013-04-29 00:00:00   2013-01-29 00:00:00   2013-07-11 00:00:00   2013-10-28 00:00:00   2013-07-31 00:00:00   2014-01-28 00:00:00   2014-07-24 00:00:00   2014-04-23 00:00:00   2014-10-23 00:00:00   2015-07-30 00:00:00   2015-04-27 00:00:00   2015-01-28 00:00:00   2015-10-23 00:00:00   2016-07-29 00:00:00   2016-04-26 00:00:00   2016-01-28 00:00:00   2016-10-26 00:00:00   2017-07-11 00:00:00   2017-04-27 00:00:00   2017-01-26 00:00:00   2017-07-27 00:00:00   2017-10-24 00:00:00   2018-01-29 00:00:00   2018-07-19 00:00:00   2018-04-25 00:00:00   2018-10-15 00:00:00   2019-04-26 00:00:00   2019-01-25 00:00:00   2020-01-29 00:00:00   2019-10-31 00:00:00   2019-10-31 00:00:00   2019-07-26 00:00:00   2020-04-28 00:00:00   2021-01-27 00:00:00   2020-10-26 00:00:00   2020-07-23 00:00:00   2021-07-27 00:00:00   2021-10-26 00:00:00   2021-04-23 00:00:00   2022-01-25 00:00:00   2022-04-22 00:00:00   2022-08-01 00:00:00   2022-10-31 00:00:00
from_date   2009-04-01 00:00:00   2009-07-01 00:00:00   2010-04-01 00:00:00   2009-10-01 00:00:00   2010-01-01 00:00:00   2012-07-01 00:00:00   2013-01-01 00:00:00   2012-10-01 00:00:00   2013-01-01 00:00:00   2013-07-01 00:00:00   2013-04-01 00:00:00   2013-10-01 00:00:00   2014-04-01 00:00:00   2014-01-01 00:00:00   2014-07-01 00:00:00   2015-04-01 00:00:00   2015-01-01 00:00:00   2014-10-01 00:00:00   2015-07-01 00:00:00   2016-04-01 00:00:00   2016-01-01 00:00:00   2015-10-01 00:00:00   2016-07-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2016-10-01 00:00:00   2017-04-01 00:00:00   2017-07-01 00:00:00   2017-10-01 00:00:00   2018-04-01 00:00:00   2018-01-01 00:00:00   2018-07-01 00:00:00   2019-01-01 00:00:00   2018-10-01 00:00:00   2019-10-01 00:00:00   2019-04-01 00:00:00   2019-07-01 00:00:00   2019-04-01 00:00:00   2020-01-01 00:00:00   2020-10-01 00:00:00   2020-07-01 00:00:00   2020-04-01 00:00:00   2021-04-01 00:00:00   2021-07-01 00:00:00   2021-01-01 00:00:00   2021-10-01 00:00:00   2022-01-01 00:00:00   2022-04-01 00:00:00   2022-07-01 00:00:00
thru_date   2009-06-30 00:00:00   2009-09-30 00:00:00   2010-06-30 00:00:00   2009-12-31 00:00:00   2010-03-31 00:00:00   2012-09-30 00:00:00   2013-03-31 00:00:00   2012-12-31 00:00:00   2013-03-31 00:00:00   2013-09-30 00:00:00   2013-06-30 00:00:00   2013-12-31 00:00:00   2014-06-30 00:00:00   2014-03-31 00:00:00   2014-09-30 00:00:00   2015-06-30 00:00:00   2015-03-31 00:00:00   2014-12-31 00:00:00   2015-09-30 00:00:00   2016-06-30 00:00:00   2016-03-31 00:00:00   2015-12-31 00:00:00   2016-09-30 00:00:00   2017-03-31 00:00:00   2017-03-31 00:00:00   2016-12-31 00:00:00   2017-06-30 00:00:00   2017-09-30 00:00:00   2017-12-31 00:00:00   2018-06-30 00:00:00   2018-03-31 00:00:00   2018-09-30 00:00:00   2019-03-31 00:00:00   2018-12-31 00:00:00   2019-12-31 00:00:00   2019-06-30 00:00:00   2019-09-30 00:00:00   2019-06-30 00:00:00   2020-03-31 00:00:00   2020-12-31 00:00:00   2020-09-30 00:00:00   2020-06-30 00:00:00   2021-06-30 00:00:00   2021-09-30 00:00:00   2021-03-31 00:00:00   2021-12-31 00:00:00   2022-03-31 00:00:00   2022-06-30 00:00:00   2022-09-30 00:00:00
cum_beg_dt   2009-04-01 00:00:00   2009-04-01 00:00:00   2009-04-01 00:00:00   2009-04-01 00:00:00   2009-04-01 00:00:00   2011-01-01 00:00:00   2013-01-01 00:00:00   2011-01-01 00:00:00   2013-01-01 00:00:00   2013-01-01 00:00:00   2013-01-01 00:00:00   2013-01-01 00:00:00   2013-01-01 00:00:00   2013-01-01 00:00:00   2013-01-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2013-01-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2015-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   2017-01-01 00:00:00   2017-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   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   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173
firm_name   American Cancer Society Cancer Action Network (ACS CAN)   American Cancer Society Cancer Action Network (ACS CAN)   American Cancer Society Cancer Action Network (ACS CAN)   American Cancer Society Cancer Action Network (ACS CAN)   American Cancer Society Cancer Action Network (ACS CAN)   American Cancer Society Cancer Action Network (ACS CAN)   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network (ACS CAN)   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.
firm_city   Washington D.C.   Washington D.C.   Washington D.C.   Washington D.C.   Washington D.C.   Washington D.C.   Washington   Washington D.C.   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington
firm_st   None   None   None   None   None   None   DC   None   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC
firm_zip4   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20005
firm_phon   (202) 661-5727   (202) 661-5727   (202) 661-5727   (202) 661-5727   (202) 661-5727   (202) 661-5727   9164422952   (202) 661-5727   9164422952   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916-442-2952   916 448-0500   916 448-0500   916-442-2952   916-442-2952   916-442-2952   916-442-2952   916-442-2952   916-442-2952   916-442-2952
mail_city   None   None   None   None   None   None   Sacramento   None   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   None
mail_st   None   None   None   None   None   None   CA   None   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   None
mail_zip4   None   None   None   None   None   None   95814   None   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   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   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   2009-07-27 00:00:00   2009-10-21 00:00:00   2010-07-22 00:00:00   2010-01-29 00:00:00   2010-04-20 00:00:00   2012-10-23 00:00:00   2013-04-29 00:00:00   2013-01-28 00:00:00   2013-04-29 00:00:00   2013-10-28 00:00:00   2013-07-31 00:00:00   2014-01-28 00:00:00   2014-07-24 00:00:00   2014-04-23 00:00:00   2014-10-23 00:00:00   2015-07-30 00:00:00   2015-04-27 00:00:00   2015-01-28 00:00:00   2015-10-23 00:00:00   2016-07-29 00:00:00   2016-04-26 00:00:00   2016-01-28 00:00:00   2016-10-26 00:00:00   2017-07-11 00:00:00   2017-04-27 00:00:00   2017-01-26 00:00:00   2017-07-27 00:00:00   2017-10-24 00:00:00   2018-01-29 00:00:00   2018-07-19 00:00:00   2018-04-25 00:00:00   2018-10-15 00:00:00   2019-04-26 00:00:00   2019-01-25 00:00:00   2020-01-29 00:00:00   2019-10-31 00:00:00   2019-10-31 00:00:00   2019-07-26 00:00:00   2020-04-28 00:00:00   2021-01-27 00:00:00   2020-10-26 00:00:00   2020-07-23 00:00:00   2021-07-27 00:00:00   2021-10-26 00:00:00   2021-04-23 00:00:00   2022-01-25 00:00:00   2022-04-22 00:00:00   2022-07-27 00:00:00   2022-10-31 00:00:00
sig_loc   Washington, D.C.   Washington, DC   Washington, D.C.   Washington, D.C.   Washington, D.C.   Sacramento, CA   Sacramento CA   Sacramento, CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA
sig_naml   Steger   Steger   Steger   Steger   Steger   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox
sig_namf   S. Carter   S. Carter   S. Carter   S. Carter   S. Carter   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James
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   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   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   Steger   Steger   Steger   Steger   Steger   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox
prn_namf   S. Carter   S. Carter   S. Carter   S. Carter   S. Carter   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James   James
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   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   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   Senior Director, State and Local Campaigns   Senior Director, State and Local Campaigns   Senior Director, State and Local Campaigns   Senior Director, State and Local Campaigns   Senior Director, State and Local Campaigns   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy
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   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   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   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   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   X   X   X   X   X   X   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   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X
ctrib_y_cb   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
lby_actvty   SB 600; State Budget   SB 600; State Budget   None.   State Budget; Legislature: tobacco tax increase, Every Women Counts Program defense   None.   AB 369, 441, 1000, 1083, 1301, 1461, 1500, 1526, 2026, 2392; SB 255, 961, 1329, 1359; CA Health Benefit Exchange: Qualified Health Plans   See attachment 'Part 1'   Legislature: tobacco tax, smoke-free schools, oral chemotherapy, Medi-Cal expansion, CA Health Benefit Exchange: establishment grants and qualified health plans.   See attachment 'Part 1'   AB 49, 219, 411, 459, 505, 617, 889, 912, 1194, 1286; ABX1 1; SB 28, 62, 353, 402, 639, 640, 768, 799, 809; SBX1 1, 3; SCR 24.   AB 49, 219, 411, 459, 505, 617, 889, 912, 1194, 1286; ABX1 1, 2; ACR 39; SB 28, 353, 402, 639, 640, 768, 799, 809: SBX1 1, 2, 3; SCR 17, 24; Health and Human Services Agency: low carbon fuel standard; Department of Health Care Services: low income health program transition, communication and outreach strategy.   AB 49, 320; SB 768; Legislature: pain management, colorectal cancer control program, tobacco tax, tobacco control program, metastatic breast cancer, flavored tobacco product ban; Covered CA: prescription drug formulary   AB 369, 467, 1500, 1819, 1917, 2139, 2418; ACR 111; AJR 5; SB 500, 508, 648, 912, 964, 1000, 1019, 1052, 1100, 1176, 1204, 1275; Legislature: SNAP Ed, California Colon Cancer Control Program   AB 369, 467, 1500, 1819, 2418, 2139, 2339; ACR 111; AJR 5; SB 500, 508, 912, 964, 1052; Legislature: budget change proposal to SNAP Ed, colorectal cancer control program, tobacco tax   AB 49, 209, 609, 617, 1917, 2139, 2418; SB 18, 204, 508, 648, 912, 1004, 1019, 1034, 1052, 1151, 1176, 2102; Legislature: tobacco tax; Board of Pharmacy: smoke-free pharmacy resolution   AB 137, 176, 374, 533, 556, 635, 708, 768, 990, 1162, 1321, 1396, 1464; SB 24, 32, 140, 151, 203, 350, 388, 591, 671, 763; SCR 26.   AB 556, 768, 1162, 1305, 1396; SB 24, 137, 140, 151, 591; Legislature: tobacco tax   Legislature: tobacco tax, electronic cigarettes, cancer registry   AB 137, 176, 347, 533, 556, 635, 768, 990, 1162, 1321, 1396, 1464; SB 24, 140, 151, 203, 388, 438, 591, 671; SCR 26; AB X2-6, 7, 8, 9, 10, 11, 16; SB X2-5, 6, 7, 8, 9, 10, 13, 14; Legislature: tobacco tax.   AB 533, 1594, 1696, 1726, 1763, 1795, 1901, 2325; SB 908, 923, 977, 1333, 1383, 1400, 2077; SCR 117, 118; ABX2-7, X2-9, X2-10, X2-11; SBX2-5, X2-7; Legislature: Colorectal Cancer Screening, Palliative Care, Tobacco Cessation; Breast Cancer Screening; California Cancer Registry.   AB 533, 1594, 1696, 1726, 1763, 1795, 1901, 2325; ABX2-7, X2-9, X2-10, X2-11; SB 908, 923, 977, 1333, 1383, 2077; SBX2-5, X2-7; SCR 117, 118; Legislature: Colorectal Cancer Screening, Palliative Care, Tobacco Cessation; Breast Cancer Screening; California Cancer Registry.   AB 1162; ABX2 6, 7, 8, 9, 10, 11; SBX2 5, 6, 7, 8, 9, 10, 14; Legislature: colorectal cancer screening, palliative care; California cancer registry, breast and cervical cancer screening and treatment.   AB 72, 1696, 1726, 1763, 1795, 1901, 2325, 2469; SB 32, 977, 1010, 1333, 1383, 1400, 1476, 1594; SCR 117, 118; Department of Health Care Services: Medi-Cal tobacco cessation coverage   AB 62, 179, 182, 265, 715: ACR 11, 36; SB 55, 172, 223, 294, 300, 386, 419, 440.   AB 179, 182, 715: ACR 11, 36; SB 55, 172, 223, 294, 300, 419, 440.   Legislature: palliative care, breast cancer screening, access to care, cancer research, tobacco cessation. CalPERS: proposed elimination of CalPERS' policy for portfolio divestment in tobacco stock. Department of Pesticide Regulation: pesticide near schools regulations.   AB 62, 179, 182, 709, 715, 725, 739, 1107, 1132, 1386, 1575; SB 55, 172, 223, 258, 294, 386, 419, 440, 562, 563, 641.   AB 179, 182, 709, 715, 725, 739, 1132, 1386, 1575; SB 55, 223, 258, 294, 386, 440, 563; Board of Equalization, State Auditor, Department of Justice: Prop. 56 Regulations   Department of Education: Prop. 56 Budget   AB 158, 937, 1335, 1838, 1998, 2020, 2275, 2335, 2434, 2459, 2486, 2499, 2565, 2775, 2863; ACR 163; SB 872, 910, 945, 1108, 1192, 1255; SCR 143; Tobacco Education Research Oversight Committee, California Department of Finance: multi-year spending authority for Prop. 56 funded programs   AB 937, 1860, 1998, 2020, 2335, 2499, 2775; ACR 158, 163; SB 760, 910, 945, 1108, 1192; Tobacco Education Research Oversight Committee: Prop. 56 Regulations   AB 937, 1335, 1810, 1838, 1860, 2174, 2275, 2335, 2434, 2459, 2486, 2499, 2565, 2275, 2863; ACR 163; SB 840, 910, 1108, 1192, 1255; SCR 143   AB 528, 739, 138, 414, 479, 765, 1309, 1625; ACR 32; SB 38, 39, 650, 8, 65, 175, 210, 260, 346, 452, 600.   SB 38, 39   None   AB 138, 414, 479, 528, 647, 739, 765, 1309, 1465, 1468, 1625; ACR 32; SB 8, 38, 39, 44, 65, 175, 210, 260, 346, 452, 574, 600, 650.   AB 528, 647, 1309, 1639, 1718; SB 8, 39, 44, 65, 210, 260, 452, 574, 600, 650   AB 138, 414, 479, 528, 647, 739, 765, 1309, 1465, 1468, 1625; ACR 32; SB 8, 38, 39, 44, 65, 175, 210, 260, 346, 452, 574, 600, 650.   AB 1986, 2949; SB 244, 793, 983.   Legislature: colorectal cancer screening, nutrition, access to care and tobacco.   SB 793   AB 479, 1693, 1965, 1986, 2144, 2158, 2230, 2466, 2949; SB 65, 406, 793, 983   AB 342, 347, 541, 1043, 1520; SB 247, 310, 395, 487, 535; SCR 11   AB 45, 342, 347, 541, 1034; ACR 98; SB 247, 310, 395, 535; SCR 11; SR 46   AB 342, AB 1163, AB 1197, SB 310   AB 45, 342, 347, 541, 593, 1520; SB 247, 310, 368, 395; SR 46; SCR 11.   AB 558, 1880, 2638; SB 912, 934, 987; Legislature: California Cancer Registry, Rare Disease Control.   SB 912, SB 987, SB 84, AB 558, AB 1690, AB 1880, AB 2638, SB 934   SB 912, 987,84, 934; AB 558, 1690, 1880, 2638
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   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   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   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   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   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   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   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   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   1688523   1717654   1717654   1717654   1918639   1918639   1918639   1918639   1986801   2114498   1918639   2329073   2329073   2537383   2537383
amend_id   0   0   1   2   0   1   2   3   0   0   4   0   1   0   1
rec_type   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR
form_type   F603   F603   F603   F603   F603   F603   F603   F603   F602   F603   F603   F603   F603   F603   F603
sender_id   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   F24880   1319173   1319173   1319173   1319173   1319173   1319173
filer_id   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173
entity_cd   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM
filer_naml   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   AMERICAN CANCER SOCIETY ACTION NETWORK (ACS CAN)   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.   American Cancer Society Cancer Action Network Inc.
filer_namf   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
filer_nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
report_num   000   000   001   002   000   001   002   003   000   000   004   000   001   000   001
rpt_date   2012-09-07 00:00:00   2013-01-01 00:00:00   2013-07-31 00:00:00   2014-09-01 00:00:00   2015-01-01 00:00:00   2015-03-03 00:00:00   2015-04-29 00:00:00   2015-07-21 00:00:00   2015-07-20 00:00:00   2018-12-31 00:00:00   2016-12-06 00:00:00   2020-12-31 00:00:00   2020-06-06 00:00:00   2022-12-31 00:00:00   2022-08-18 00:00:00
ls_beg_yr   2011   2013   2013   2013   2015   2015   2015   2015   2015   2017   2015   2019   2019   2021   2021
ls_end_yr   2012   2014   2014   2014   2016   2016   2016   2016   2016   2018   2016   2020   2020   2022   2022
qual_date   2012-09-01 00:00:00   None   None   None   None   None   None   None   None   None   None   None   None   None   None
eff_date   None   None   None   None   None   None   None   None   2015-07-20 00:00:00   None   None   None   None   None   None
bus_city   Washington   Washington   Washington   Washington   Washington   Washington   Washington   Washington   WASHINGTON   Washington   Washington   Washington   Washington   Washington   Washington
bus_st   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC
bus_zip4   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20004   20005
bus_phon   (916) 442-2952   9164422952   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   (916) 448-0500   916 448-0500   916 448-0500   916 448-0500   916 448-0500   916-442-2952   916-442-2952
bus_fax   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_email   None   None   None   None   None   [email protected]   [email protected]   [email protected]   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]
mail_city   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   None   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   None
mail_st   CA   CA   CA   CA   CA   CA   CA   CA   None   CA   CA   CA   CA   CA   None
mail_zip4   95814   95814   95814   95814   95814   95814   95814   95814   None   95814   95814   95814   95814   95814   None
mail_phon   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
sig_date   2012-08-31 00:00:00   2012-11-19 00:00:00   2013-07-31 00:00:00   2014-10-14 00:00:00   2014-11-24 00:00:00   2015-03-03 00:00:00   2015-04-29 00:00:00   2015-08-04 00:00:00   2015-07-20 00:00:00   2016-12-08 00:00:00   2016-12-06 00:00:00   2018-12-18 00:00:00   2020-05-29 00:00:00   2020-11-19 00:00:00   2022-09-15 00:00:00
sig_loc   None   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   WASHINGTON, DC   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA
sig_naml   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   KNOX   Knox   Knox   Knox   Knox   Knox   Knox
sig_namf   James   James   James   James   James   James   James   James   JAMES   James   James   James   James   James   James
sig_namt   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
prn_naml   Knox   Knox   Knox   Knox   Knox   Knox   Knox   Knox   KNOX   Knox   Knox   Knox   Knox   Knox   Knox
prn_namf   James   James   James   James   James   James   James   James   JAMES   James   James   James   James   James   James
prn_namt   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
sig_title   None   Vice President, Legislative Advocate   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   VP, LEGISLATIVE ADVOCACY 4351KAU   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy   Vice President, Legislative Advocacy
stmt_firm   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
ind_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
trade_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
oth_cb   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X
a_b_name   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
a_b_city   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
a_b_st   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
a_b_zip4   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
descrip_1   Nonprofit voluntary health organization with specific concerns for issues relating to cancer.   Nonprofit voluntary health organization with specific concerns to issues relating to cancer.   Nonprofit voluntary health organization with specific concerns to issues relating to cancer.   Nonprofit voluntary health organization with specific concerns to issues relating to cancer.   Nonprofit voluntary health organization with specific concerns to issues relating to cancer.   Nonprofit voluntary health organization with specific concerns to issues relating to cancer.   Nonprofit voluntary health organization with specific concerns to issues relating to cancer.   Nonprofit voluntary health organization with specific concerns to issues relating to cancer.   NONPROFIT VOLUNTARY HEALTH ORGANIZATION WITH SPECIFIC CONCERNS TO ISSUES RELATING TO CANCER   Nonprofit voluntary health organization with specific concerns to issues relating to cancer.   Nonprofit voluntary health organization with specific concerns to issues relating to cancer.   Nonprofit voluntary health organization with specific concerns to issues relating to cancer.   Nonprofit voluntary health organization with specific concerns to issues relating to cancer.   Nonprofit voluntary health organization with specific concerns to issues relating to cancer.   Nonprofit voluntary health organization with specific concerns to issues relating to cancer.
descrip_2   N/A   None   Legislation and regulations related to health, Medi-Cal, insurance , toxics, tobacco and research.   Legislation and regulations related to health, Medi-Cal, insurance , toxics, tobacco and research.   None   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A
c_less50   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
c_more50   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
ind_class   HEA   HEA   HEA   HEA   HEA   HEA   HEA   HEA   HEA   HEA   HEA   HEA   HEA   HEA   HEA
ind_descr   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_class   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_descr   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
auth_name   None   None   None   None   None   None   None   None   PLATINUM ADVISORS, LLC   None   None   None   None   None   None
auth_city   None   None   None   None   None   None   None   None   SACRAMENTO   None   None   None   None   None   None
auth_st   None   None   None   None   None   None   None   None   CA   None   None   None   None   None   None
auth_zip4   None   None   None   None   None   None   None   None   95814   None   None   None   None   None   None
lobby_int   Legislation and regulations related to health, Medi-Cal, insurance, toxics, tobacco and research.   Legislation and regulations related to health, Medi-Cal, insurance , toxics, tobacco and research.   Legislation and regulations related to health, Medi-Cal, insurance , toxics, tobacco and research.   Legislation and regulations related to health, Medi-Cal, insurance , toxics, tobacco and research.   Legislation and regulations related to health, Medi-Cal, insurance , toxics, tobacco and research.   Legislation and regulations related to health, Medi-Cal, insurance , toxics, tobacco and research.   Legislation and regulations related to health, Medi-Cal, insurance , toxics, tobacco and research.   Legislation and regulations related to health, Medi-Cal, insurance , toxics, tobacco and research.   None   Legislation and regulations related to health, Medi-Cal, insurance , toxics, tobacco and research.   Legislation and regulations related to health, Medi-Cal, insurance , toxics, tobacco and research.   Legislation and regulations related to health, Medi-Cal, insurance , toxics, tobacco and research.   Legislation and regulations related to health, Medi-Cal, insurance , toxics, tobacco and research.   Legislation and regulations related to health, Medi-Cal, insurance , toxics, tobacco and research.   Legislation and regulations related to health, Medi-Cal, insurance , toxics, tobacco and research.
influen_yn   Y   Y   Y   Y   Y   Y   Y   Y   None   Y   Y   Y   Y   Y   Y
firm_name   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
newcert_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
rencert_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
complet_dt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
lby_reg_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
lby_604_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
st_leg_yn   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
st_agency   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
lobby_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
l_firm_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: filer_acronyms
acronym   ACS CAN
filer_id   1319173
Table: filer_address
filer_id   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173
adrid   2169955   2409732   2409733   2504704   2504705   2544599   2544600   2553626   2465086   2465087   2246245   2246243   2256196   2256197   2337213   2337214
effect_dt   2009-05-25 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2022-08-18 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2012-09-01 00:00:00   2012-09-01 00:00:00   2013-01-01 00:00:00   2013-01-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00
add_type   7051   7051   7082   7051   7082   7051   7082   7051   7051   7082   7051   7082   7051   7082   7051   7082
session_id   2009   2017   2017   2021   2021   2023   2023   2021   2019   2019   2011   2011   2013   2013   2015   2015
Table: filer_filings
filer_id   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173
filing_id   1763781   1783500   1789453   1717654   1981767   1918639   1965430   1844631   1800592   1918639   1918639   1909603   1717654   1433872   1428869   1428871   1450101   1482663   1463182   1503878   1814911   1688523   1691209   1933529   1919860   1901479   1717654   1706804   1872747   1724308   1734716   1763781   1970171   1996374   1986801   1987060   1918639   1989243   2419250   2333234   2207663   2484409   2318448   2019365   2033712   2012717   2061183   2101791   2116353   2116757   1918639   2114498   2130857   2176975   2158166   2158166   2346360   2380840   2539421   2329073   2191420   2537383   2271754   2443572   2236357   2469404   2531693   2477209   2399201   2329073   2399201   2676921   2707068   2641807   2537383   2578705   2554985   2625044   2600951   2747549   2736182
period_id   213   214   None   215   222   222   221   217   215   221   221   219   219   198   None   None   199   201   200   202   216   211   None   220   None   None   213   211   218   None   212   213   None   223   223   None   223   None   239   None   232   242   235   None   225   224   226   227   None   None   228   236   228   230   229   229   236   237   None   242   231   252   234   240   233   241   243   None   238   244   238   249   250   248   251   245   244   247   246   251   None
form_id   F635   F635   F605   F603   F635   F603   F635   F635   F635   F603   F603   F635   F603   F635   F602   F999   F635   F635   F635   F635   F635   F603   F603   F635   F603   F605   F603   F635   F635   F603   F635   F635   F605   F635   F602   F602   F603   F605   F635   F603   F635   F635   F635   F605   F635   F635   F635   F635   F604   F605   F603   F603   F635   F635   F635   F635   F635   F635   F603   F603   F635   F603   F635   F635   F635   F635   F635   F605   F635   F603   F635   F635   F635   F635   F603   F635   F635   F635   F635   F635   F605
filing_sequence   1   0   0   1   0   2   0   0   0   1   0   0   2   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   3   0   0   0   0   0   0   0   0   0   0   0   0   0   4   0   0   0   1   0   0   0   0   1   0   0   0   0   0   0   0   0   1   0   0   0   0   0   1   0   0   0   0   0   0
filing_date   2013-07-11 00:00:00   2013-07-31 00:00:00   2013-08-05 00:00:00   2013-08-05 00:00:00   2015-07-31 00:00:00   2015-05-04 00:00:00   2015-04-30 00:00:00   2014-04-30 00:00:00   2013-10-31 00:00:00   2015-03-03 00:00:00   2014-12-16 00:00:00   2014-10-30 00:00:00   2014-10-20 00:00:00   2009-07-27 00:00:00   2009-06-15 00:00:00   2009-07-06 00:00:00   2009-10-27 00:00:00   2010-04-27 00:00:00   2010-01-29 00:00:00   2010-07-27 00:00:00   2014-01-29 00:00:00   2012-09-07 00:00:00   2012-09-06 00:00:00   2015-01-30 00:00:00   2014-12-16 00:00:00   2014-10-20 00:00:00   2012-12-17 00:00:00   2012-10-29 00:00:00   2014-07-31 00:00:00   2012-12-17 00:00:00   2013-01-29 00:00:00   2013-04-29 00:00:00   2015-05-04 00:00:00   2015-10-29 00:00:00   2015-08-21 00:00:00   2015-07-21 00:00:00   2015-08-05 00:00:00   2015-08-05 00:00:00   2019-10-31 00:00:00   2018-12-20 00:00:00   2018-01-29 00:00:00   2020-07-30 00:00:00   2018-10-31 00:00:00   2015-03-03 00:00:00   2016-04-27 00:00:00   2016-02-01 00:00:00   2016-07-29 00:00:00   2016-10-31 00:00:00   2016-12-28 00:00:00   2016-12-28 00:00:00   2016-12-28 00:00:00   2016-12-28 00:00:00   2017-01-31 00:00:00   2017-07-31 00:00:00   2017-07-18 00:00:00   2017-05-01 00:00:00   2019-01-30 00:00:00   2019-04-30 00:00:00   2020-12-11 00:00:00   2020-07-01 00:00:00   2017-10-27 00:00:00   2020-12-17 00:00:00   2018-07-30 00:00:00   2020-01-31 00:00:00   2018-04-25 00:00:00   2020-04-29 00:00:00   2020-11-02 00:00:00   2020-07-02 00:00:00   2019-10-31 00:00:00   2018-12-20 00:00:00   2019-07-31 00:00:00   2022-05-02 00:00:00   2022-08-01 00:00:00   2022-01-29 00:00:00   2022-09-27 00:00:00   2021-04-29 00:00:00   2021-02-01 00:00:00   2021-11-01 00:00:00   2021-07-30 00:00:00   2022-10-31 00:00:00   2022-09-27 00:00:00
stmnt_type   10002   10001   10005   10002   10001   10002   10001   10001   10001   10002   10001   10001   10002   10001   10005   10005   10001   10001   10001   10001   10001   10001   10005   10001   10005   10006   10001   10001   10001   10005   10001   10001   10006   10001   10001   10005   10002   10006   10001   10005   10001   10001   10001   10006   10001   10001   10001   10001   10005   10006   10002   10001   10001   10001   10002   10001   10001   10001   10005   10002   10001   10001   10001   10001   10001   10001   10001   10005   10002   10001   10001   10001   10001   10001   10002   10001   10001   10001   10001   10001   10002
stmnt_status   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11001   11001   11001   11001   11001   11003   11001
session_id   2013   2013   2013   2013   2015   2015   2015   2013   2013   2015   2015   2013   2013   2009   2009   2009   2009   2009   2009   2009   2013   2011   2011   2013   2015   2013   2013   2011   2013   2013   2011   2013   2015   2015   2015   2015   2015   2015   2019   2019   2017   2019   2017   2015   2015   2015   2015   2015   2017   2015   2015   2017   2015   2017   2017   2017   2017   2019   2021   2019   2017   2021   2017   2019   2017   2019   2019   2019   2019   2019   2019   2021   2021   2021   2021   2021   2019   2021   2021   2021   2021
user_id   AGLADNEY   AGLADNEY   SARRIAGA   SARRIAGA   MPACHECO   YRODRIGU   MPACHECO   AGLADNEY   AGLADNEY   YRODRIGU   YRODRIGU   AGLADNEY   YRODRIGU   JGRISSUM   CFLAGG   CFLAGG   MGUERRA   ASAETERN   MGUERRA   ASAETERN   ASAETERN   YRODRIGU   YRODRIGU   MPACHECO   GKURIMOT   YRODRIGU   SARRIAGA   AGLADNEY   AGLADNEY   SARRIAGA   AGLADNEY   AGLADNEY   YRODRIGU   MPACHECO   YRODRIGU   YRODRIGU   YRODRIGU   YRODRIGU   SUSHAKOV   GPEREZ   AGLADNEY   GTAYLOR   AGLADNEY   PBANFORD   JINGRAM   AGLADNEY   AGLADNEY   AGLADNEY   SARRIAGA   YRODRIGU   YRODRIGU   CAFILER   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   SUSHAKOV   AROJAS   GPEREZ   AGLADNEY   AROJAS   AGLADNEY   AGLADNEY   AGLADNEY   SUSHAKOV   GTAYLOR   GPEREZ   AGLADNEY   GPEREZ   SUSHAKOV   CAFILER   CAFILER   CHATRIDGE   CVANLIEW   CHATRIDGE   CHARTRIDGE   MKIRKHAM   CHATRIDGE   CAFILER   CVANLIEW
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   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   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003
fine_audit   11001   11001   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11003   11001   11001   11001   11001   11001   11001   11003   11003   11001   11003   11001   11001   11001   11001   11003   11003   11001   11003   11001   11003   11003   11001   11003   11001   11001   11001   11001   11003   11003
rpt_start   2013-01-01 00:00:00   2013-04-01 00:00:00   1900-01-01 00:00:00   2013-07-31 00:00:00   2015-04-01 00:00:00   2015-04-29 00:00:00   2015-01-01 00:00:00   2014-01-01 00:00:00   2013-07-01 00:00:00   2015-03-03 00:00:00   2015-01-01 00:00:00   2014-07-01 00:00:00   2014-09-01 00:00:00   2009-04-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2009-07-01 00:00:00   2010-01-01 00:00:00   2009-10-01 00:00:00   2010-04-01 00:00:00   2013-10-01 00:00:00   2012-09-07 00:00:00   1900-01-01 00:00:00   2014-10-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2013-01-01 00:00:00   2012-07-01 00:00:00   2014-04-01 00:00:00   1900-01-01 00:00:00   2012-10-01 00:00:00   2013-01-01 00:00:00   1900-01-01 00:00:00   2015-07-01 00:00:00   2015-07-20 00:00:00   1900-01-01 00:00:00   2015-07-21 00:00:00   1900-01-01 00:00:00   2019-07-01 00:00:00   1900-01-01 00:00:00   2017-10-01 00:00:00   2020-04-01 00:00:00   2018-07-01 00:00:00   1900-01-01 00:00:00   2016-01-01 00:00:00   2015-10-01 00:00:00   2016-04-01 00:00:00   2016-07-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2016-12-06 00:00:00   2018-12-31 00:00:00   2016-10-01 00:00:00   2017-04-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2018-10-01 00:00:00   2019-01-01 00:00:00   1900-01-01 00:00:00   2020-06-06 00:00:00   2017-07-01 00:00:00   2022-12-31 00:00:00   2018-04-01 00:00:00   2019-10-01 00:00:00   2018-01-01 00:00:00   2020-01-01 00:00:00   2020-07-01 00:00:00   1900-01-01 00:00:00   2019-04-01 00:00:00   2020-12-31 00:00:00   2019-04-01 00:00:00   2022-01-01 00:00:00   2022-04-01 00:00:00   2021-10-01 00:00:00   2022-08-18 00:00:00   2021-01-01 00:00:00   2020-10-01 00:00:00   2021-07-01 00:00:00   2021-04-01 00:00:00   2022-07-01 00:00:00   1900-01-01 00:00:00
rpt_end   2013-03-31 00:00:00   2013-06-30 00:00:00   1900-01-01 00:00:00   2013-07-31 00:00:00   2015-06-30 00:00:00   2015-04-29 00:00:00   2015-03-31 00:00:00   2014-03-31 00:00:00   2013-09-30 00:00:00   2015-03-03 00:00:00   2015-01-01 00:00:00   2014-09-30 00:00:00   2014-09-01 00:00:00   2009-06-30 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2009-09-30 00:00:00   2010-03-31 00:00:00   2009-12-31 00:00:00   2010-06-30 00:00:00   2013-12-31 00:00:00   2012-09-07 00:00:00   1900-01-01 00:00:00   2014-12-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2013-01-01 00:00:00   2012-09-30 00:00:00   2014-06-30 00:00:00   1900-01-01 00:00:00   2012-12-31 00:00:00   2013-03-31 00:00:00   1900-01-01 00:00:00   2015-09-30 00:00:00   2015-07-20 00:00:00   1900-01-01 00:00:00   2015-07-21 00:00:00   1900-01-01 00:00:00   2019-09-30 00:00:00   1900-01-01 00:00:00   2017-12-31 00:00:00   2020-06-30 00:00:00   2018-09-30 00:00:00   1900-01-01 00:00:00   2016-03-31 00:00:00   2015-12-31 00:00:00   2016-06-30 00:00:00   2016-09-30 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2016-12-06 00:00:00   2018-12-31 00:00:00   2016-12-31 00:00:00   2017-06-30 00:00:00   2017-03-31 00:00:00   2017-03-31 00:00:00   2018-12-31 00:00:00   2019-03-31 00:00:00   1900-01-01 00:00:00   2020-06-06 00:00:00   2017-09-30 00:00:00   2022-12-31 00:00:00   2018-06-30 00:00:00   2019-12-31 00:00:00   2018-03-31 00:00:00   2020-03-31 00:00:00   2020-09-30 00:00:00   1900-01-01 00:00:00   2019-06-30 00:00:00   2020-12-31 00:00:00   2019-06-30 00:00:00   2022-03-31 00:00:00   2022-06-30 00:00:00   2021-12-31 00:00:00   2022-08-18 00:00:00   2021-03-31 00:00:00   2020-12-31 00:00:00   2021-09-30 00:00:00   2021-06-30 00:00:00   2022-09-30 00:00:00   1900-01-01 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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   None   22001   22001   22001   22001   22001   22001   None   22001   None   None   22001   22001   22001   None   22001   22001   None   22001   22001   None   22001   None   22001   None   22001   22001   22001   None   22001   22001   22001   22001   None   None   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None
Table: filer_interests
filer_id   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173
session_id   2011   2013   2009   2017   2019   2015   2021   2023
interest_cd   40306   40306   40312   40306   40306   40306   40306   40306
effect_date   2012-09-01 00:00:00   2013-01-01 00:00:00   2009-05-25 00:00:00   2017-01-01 00:00:00   2019-01-01 00:00:00   2015-01-01 00:00:00   2021-01-01 00:00:00   2023-01-01 00:00:00
Table: filer_to_filer_type
filer_id   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173
filer_type   1   2   2   1   2   2   2   2   2
active   T   Y   Y   Y   Y   Y   Y   Y   N
race   0   None   0   0   None   None   None   None   None
session_id   2009   2013   2011   2009   2021   2015   2017   2019   2023
category   0   None   0   0   None   None   None   None   None
category_type   0   None   0   0   None   None   None   None   None
sub_category   0   None   0   0   None   None   None   None   None
effect_dt   2010-06-01 00:00:00   2013-01-01 00:00:00   2012-09-01 00:00:00   2009-05-25 00:00:00   2021-01-01 00:00:00   2015-01-01 00:00:00   2017-01-01 00:00:00   2019-01-01 00:00:00   2023-01-01 00:00:00
sub_category_type   0   None   0   0   None   None   None   None   None
election_type   0   None   0   0   None   None   None   None   None
sub_category_a   None   None   None   None   None   None   None   None   None
nyq_dt   None   None   None   None   None   None   None   None   None
party_cd   0   None   0   0   None   None   None   None   None
county_cd   0   None   0   0   None   None   None   None   None
district_cd   0   None   0   0   None   None   None   None   None
Table: filer_xref
filer_id   1319173
xref_id   1319173
effect_dt   2009-07-06 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173
filer_id   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173
filer_type   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER
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   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   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   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   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   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   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   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   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   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   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00
naml   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)
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
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
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
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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   WASHINGTON   SACRAMENTO   WASHINGTON   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   WASHINGTON   SACRAMENTO   WASHINGTON   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   WASHINGTON   SACRAMENTO   WASHINGTON   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   WASHINGTON   SACRAMENTO   WASHINGTON   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   WASHINGTON   SACRAMENTO   WASHINGTON   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   WASHINGTON   SACRAMENTO   WASHINGTON   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   WASHINGTON   SACRAMENTO   WASHINGTON   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   WASHINGTON   SACRAMENTO   WASHINGTON   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON   SACRAMENTO   WASHINGTON
st   DC   CA   DC   DC   CA   DC   CA   DC   CA   DC   CA   DC   CA   DC   CA   DC   DC   CA   DC   DC   CA   DC   CA   DC   CA   DC   CA   DC   CA   DC   CA   DC   DC   CA   DC   DC   CA   DC   CA   DC   CA   DC   CA   DC   CA   DC   CA   DC   DC   CA   DC   DC   CA   DC   CA   DC   CA   DC   CA   DC   CA   DC   CA   DC   DC   CA   DC   DC   CA   DC   CA   DC   CA   DC   CA   DC   CA   DC   CA   DC   DC   CA   DC   DC   CA   DC   CA   DC   CA   DC   CA   DC   CA   DC   CA   DC   DC   CA   DC   DC   CA   DC   CA   DC   CA   DC   CA   DC   CA   DC   CA   DC   DC   CA   DC   DC   CA   DC   CA   DC   CA   DC   CA   DC   CA   DC   CA   DC
zip4   20004   95814   20004   20004   95814   20004   95814   20004   95814   20004   95814   20004   95814   20004   95814   20005   20004   95814   20004   20004   95814   20004   95814   20004   95814   20004   95814   20004   95814   20004   95814   20005   20004   95814   20004   20004   95814   20004   95814   20004   95814   20004   95814   20004   95814   20004   95814   20005   20004   95814   20004   20004   95814   20004   95814   20004   95814   20004   95814   20004   95814   20004   95814   20005   20004   95814   20004   20004   95814   20004   95814   20004   95814   20004   95814   20004   95814   20004   95814   20005   20004   95814   20004   20004   95814   20004   95814   20004   95814   20004   95814   20004   95814   20004   95814   20005   20004   95814   20004   20004   95814   20004   95814   20004   95814   20004   95814   20004   95814   20004   95814   20005   20004   95814   20004   20004   95814   20004   95814   20004   95814   20004   95814   20004   95814   20004   95814   20005
phon   2026615700      9164422952   9164480500      9164480500      9164480500      9164480500      9164422952      9164422952      9164422952   2026615700      9164422952   9164480500      9164480500      9164480500      9164480500      9164422952      9164422952      9164422952   2026615700      9164422952   9164480500      9164480500      9164480500      9164480500      9164422952      9164422952      9164422952   2026615700      9164422952   9164480500      9164480500      9164480500      9164480500      9164422952      9164422952      9164422952   2026615700      9164422952   9164480500      9164480500      9164480500      9164480500      9164422952      9164422952      9164422952   2026615700      9164422952   9164480500      9164480500      9164480500      9164480500      9164422952      9164422952      9164422952   2026615700      9164422952   9164480500      9164480500      9164480500      9164480500      9164422952      9164422952      9164422952   2026615700      9164422952   9164480500      9164480500      9164480500      9164480500      9164422952      9164422952      9164422952
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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   None   None   None   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   None   None   None   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   None   None   None   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   None   None   None   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   None   None   None   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   None   None   None   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   None   None   None   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]
Table: filers
filer_id   1319173
Table: lobbying_chg_log
filer_id   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173
change_no   0   1   4   2   3   5   6   7   8   9
session_id   2009   2009   2011   2011   2011   2013   2015   2015   2015   2019
log_dt   2009-06-15 00:00:00   2010-06-29 00:00:00   2012-09-06 00:00:00   2012-09-06 00:00:00   2012-09-06 00:00:00   2014-10-20 00:00:00   2015-07-21 00:00:00   2015-03-03 00:00:00   2016-04-14 00:00:00   2020-07-02 00:00:00
filer_type   1   1   2   1   1   2   2   2   2   2
correction_flg   Y   Y   Y   None   None   None   Y   Y   Y   None
action   ADDED   DELETED   ADDED   SET ACTIVE   CHANGED   DELETED   ADDED   ADDED   DELETED   DELETED
attribute_changed   FIRM   FIRM   LOBBYIST      NAME   LOBBYIST   FIRM   LOBBYIST   FIRM   LOBBYIST
ethics_dt   None   None   None   None   None   None   None   None   None   None
interests   None   None   None   None   None   None   None   None   None   None
filer_full_name   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK (ASC CAN)   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.
filer_city   None   None   WASHINGTON   None   None   None   WASHINGTON   WASHINGTON   None   None
filer_st   None   None   DC   None   None   None   DC   DC   None   None
filer_zip   None   None   20004   None   None   None   20004   20004   None   None
filer_phone   None   None   9164422952   None   None   None   9164422952   9164422952   None   None
entity_type   3   3   4   1   1   4   3   4   3   4
entity_name   PLATINUM ADVISORS, LLC   PLATINUM ADVISORS, LLC   RAMEY, ALISON   None   AMERICAN CANCER SOCIETY CANCER ACTION NETWORK INC.,   ALISON RAMEY   PLATINUM ADVISORS, LLC   OGDEN, AUTUMN   PLATINUM ADVISORS, LLC   TIMOTHY GIBBS
entity_city   None   None   None   None   None   None   None   None   None   None
entity_st   None   None   None   None   None   None   None   None   None   None
entity_zip   None   None   None   None   None   None   None   None   None   None
entity_phone   None   None   None   None   None   None   None   None   None   None
entity_id   1147749   1147749   None   0   0   1344388   None   None   1147749   1293990
responsible_officer   None   None   None   None   None   None   None   None   None   None
effect_dt   2009-05-25 00:00:00   2010-06-01 00:00:00   2012-09-01 00:00:00   2012-09-01 00:00:00   2012-09-01 00:00:00   2014-08-29 00:00:00   2015-07-20 00:00:00   2013-02-23 00:00:00   2015-12-31 00:00:00   2020-06-05 00:00:00
Table: received_filings
filer_id   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173   1319173
filing_file_name   1844631_0.cal   468983.cal   1814911_0.cal   1800592_0.cal   1763781_0.cal   1763781_1.cal   243590.cal   245082.cal   1981767_0.cal   2130857_0.cal   2101791_0.cal   1909603_0.cal   2061183_0.cal   2033712_0.cal   1933529_0.cal   2419250_0.cal   2318448_0.cal   2207663_0.cal   2346360_0.cal   2443572_0.cal   2191420_0.cal   2469404_0.cal   2236357_0.cal   2484409_0.cal   2676921_0.cal   2625044_0.cal   2554985_0.cal   2707068_0.cal   2531693_0.cal   2600951_0.cal   2641807_0.cal   2578705_0.cal   2747549_0.cal
received_date   2014-04-30 00:00:00   2012-09-07 00:00:00   2014-01-29 00:00:00   2013-10-31 00:00:00   2013-04-29 00:00:00   2013-07-11 00:00:00   2012-10-29 00:00:00   2012-10-29 00:00:00   2015-07-31 00:00:00   2017-01-31 00:00:00   2016-10-31 00:00:00   2014-10-30 00:00:00   2016-07-29 00:00:00   2016-04-27 00:00:00   2015-01-30 00:00:00   2019-10-31 00:00:00   2018-10-31 00:00:00   2018-01-29 00:00:00   2019-01-30 00:00:00   2020-01-31 00:00:00   2017-10-27 00:00:00   2020-04-29 00:00:00   2018-04-25 00:00:00   2020-07-30 00:00:00   2022-05-02 00:00:00   2021-11-01 00:00:00   2021-02-01 00:00:00   2022-08-01 00:00:00   2020-11-02 00:00:00   2021-07-30 00:00:00   2022-01-29 00:00:00   2021-04-29 00:00:00   2022-10-31 00:00:00
filing_directory   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal
filing_id   1844631   None   1814911   1800592   1763781   1763781   None   None   1981767   2130857   2101791   1909603   2061183   2033712   1933529   2419250   2318448   2207663   2346360   2443572   2191420   2469404   2236357   2484409   2676921   2625044   2554985   2707068   2531693   2600951   2641807   2578705   2747549
form_id   F635   None   F635   F635   F635   F635   None   None   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
receive_comment   Filing accepted   Filing did not pass validation   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing did not pass validation   Filing did not pass validation   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted