Home

Filer ID: 1346831

Table: cvr_lobby_disclosure
filing_id   1655301   1708330   1670993   1734588   1800086   1778410   1762474   1815200   1864610   1864610   1843558   1909248   1909248   1981877   1964669   1933749   1995145   2060930   2036217   2009900   2097814   2171591   2153641   2128372   2187872   2187872   2171591   2153641   2200718   2239829
amend_id   0   0   0   0   0   0   0   0   1   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   1   0   1   1   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
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
sender_id   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831
filer_id   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831
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
filer_naml   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.
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
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
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
report_num   000   000   000   000   000   000   000   000   001   000   000   001   000   000   000   000   000   000   000   000   000   000   000   000   001   000   001   001   000   000
rpt_date   2012-04-26 00:00:00   2012-10-31 00:00:00   2012-07-12 00:00:00   2013-01-29 00:00:00   2013-10-31 00:00:00   2013-07-25 00:00:00   2013-04-26 00:00:00   2014-01-29 00:00:00   2014-09-12 00:00:00   2014-07-21 00:00:00   2014-04-29 00:00:00   2014-11-12 00:00:00   2014-10-30 00:00:00   2015-07-31 00:00:00   2015-04-30 00:00:00   2015-01-30 00:00:00   2015-10-28 00:00:00   2016-07-29 00:00:00   2016-04-29 00:00:00   2016-01-29 00:00:00   2016-10-27 00:00:00   2017-07-26 00:00:00   2017-04-26 00:00:00   2017-01-31 00:00:00   2017-10-16 00:00:00   2017-10-16 00:00:00   2017-08-15 00:00:00   2017-08-15 00:00:00   2018-01-09 00:00:00   2018-04-27 00:00:00
from_date   2012-01-01 00:00:00   2012-07-01 00:00:00   2012-04-01 00:00:00   2012-10-01 00:00:00   2013-07-01 00:00:00   2013-04-01 00:00:00   2013-01-01 00:00:00   2013-10-01 00:00:00   2014-04-01 00:00:00   2014-04-01 00:00:00   2014-01-01 00:00:00   2014-07-01 00:00:00   2014-06-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-04-01 00:00:00   2017-01-01 00:00:00   2016-10-01 00:00:00   0217-07-01 00:00:00   0217-07-01 00:00:00   2017-04-01 00:00:00   2017-01-01 00:00:00   2017-10-01 00:00:00   2018-01-01 00:00:00
thru_date   2012-03-31 00:00:00   2012-09-30 00:00:00   2012-06-30 00:00:00   2012-12-31 00:00:00   2013-09-30 00:00:00   2013-06-30 00:00:00   2013-03-31 00:00:00   2013-12-31 00:00:00   2014-06-30 00:00:00   2014-06-30 00:00:00   2014-03-31 00:00:00   2014-09-30 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-06-30 00:00:00   2017-03-31 00:00:00   2016-12-31 00:00:00   2017-09-30 00:00:00   2017-09-30 00:00:00   2017-06-30 00:00:00   2017-03-31 00:00:00   2017-12-31 00:00:00   2018-03-31 00:00:00
cum_beg_dt   2012-01-01 00:00:00   2012-01-01 00:00:00   2012-01-01 00:00:00   2012-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   2013-01-01 00:00:00   2013-01-01 00:00:00   2015-04-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   2018-01-01 00:00:00
firm_id   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
firm_name   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
firm_city   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK
firm_st   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY
firm_zip4   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019
firm_phon   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700
mail_city   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
mail_st   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
mail_zip4   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
mail_phon   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
sig_date   2012-04-26 00:00:00   2012-10-31 00:00:00   2012-07-12 00:00:00   2013-01-29 00:00:00   2013-10-31 00:00:00   2013-07-25 00:00:00   2013-04-26 00:00:00   2014-01-29 00:00:00   2014-09-12 00:00:00   2014-07-21 00:00:00   2014-04-29 00:00:00   2014-11-12 00:00:00   2014-10-30 00:00:00   2015-07-31 00:00:00   2015-04-30 00:00:00   2015-01-30 00:00:00   2015-10-28 00:00:00   2016-07-27 00:00:00   2016-04-28 00:00:00   2016-01-29 00:00:00   2016-10-27 00:00:00   2017-07-26 00:00:00   2017-04-26 00:00:00   2017-01-26 00:00:00   2017-10-16 00:00:00   2017-10-16 00:00:00   2017-08-15 00:00:00   2017-08-15 00:00:00   2018-01-09 00:00:00   2018-04-27 00:00:00
sig_loc   New York, New York   New York, NY   New York   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY   New York   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY   New York, NY
sig_naml   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Coussin   Coussin   Coussin   Coussin   Coussin   Coussin   Coussin   Coussin   Coussin   Coussin
sig_namf   Timothy   Timothy   Timothy   Timothy   Timothy L.   Timothy   Timothy   Timothy L.   Timothy L.   Timothy L.   Timothy L.   Timothy L.   Timothy L.   Timothy L.   Timothy L.   Timothy L.   Timothy L.   Timothy   Timothy   Timothy L.   Halit   Halit   Halit   Halit   Halit   Halit   Halit   Halit   Halit   Halit
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
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
prn_naml   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Barefield   Coussin   Coussin   Coussin   Coussin   Coussin   Coussin   Coussin   Coussin   Coussin   Coussin
prn_namf   Timothy   Timothy   Timothy   Timothy   Timothy L.   Timothy   Timothy   Timothy L.   Timothy L.   Timothy L.   Timothy L.   Timothy L.   Timothy L.   Timothy L.   Timothy L.   Timothy L.   Timothy L.   Timothy   Timothy   Timothy L.   Halit   Halit   Halit   Halit   Halit   Halit   Halit   Halit   Halit   Halit
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
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
sig_title   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Legal Officer/Chief Compliance Officer   Chief Legal Officer/Chief Compliance Officer   Chief Legal Officer/Chief Compliance Officer   Chief Legal Officer/Chief Compliance Officer   Chief Legal Officer/ Chief Compliance Officer   Chief Legal Officer/Chief Compliance Officer   Chief Legal Officer/Chief Compliance Officer   Chief Legal Officer/ Chief Compliance Officer   Chief Legal Officer/ Chief Compliance Officer   Chief Legal Officer /Chief Compliance Officer
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
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
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
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
ctrib_n_cb   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   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   None.   Business development and marketing of investment products to CalSTRs and University of California Retirement Program.   Business development and marketing of investment products to CalSTRs and University of California Retirement Program.   Business development and marketing of investment products to CalSTRs and University of California Retirement Program.   Business development and marketing of investment products to CalPERS.   Business development and marketing of investment products to CalPERS.   Business development and marketing of investment products to CalSTRs and University of California Retirement Program.   Business development and marketing of investment products to UCRP.   Educating state legislature on issues relating to enforcement of consumer protection laws and securities regulations relating to pyramid schemes.   Educating state legislature on issues relating to enforcement of consumer protection laws and securities regulations relating to pyramid schemes.   Educating state legislature on issues relating to enforcement of consumer protection laws and securities regulations relating to pyramid schemes.   Educating state legislature on issues relating to enforcement of consumer protection laws and securities regulations relating to pyramid schemes.   Educating state legislature on issues relating to enforcement of consumer protection laws and securities regulations relating to pyramid schemes.   Educating state legislature on issues relating to enforcement of consumer protection laws and securities regulations relating to pyramid schemes, and business development and marketing of investment products to CalPERS.   Educating state legislature on issues relating to enforcement of consumer protection laws and securities regulations relating to pyramid schemes, and business development and marketing of investment products to CalSTRS.   Educating state legislature on issues relating to enforcement of consumer protection laws and securities regulations relating to pyramid schemes.   Educating state legislature on issues relating to enforcement of consumer protection laws and securities regulations relating to pyramid schemes.   SB 726. Educating state legislature on issues relating to enforcement of consumer protection laws and securities regulations relating to pyramid schemes.   Educating state legislature on issues relating to enforcement of consumer protection laws and securities regulations relating to pyramid schemes.   Educating state legislature on issues relating to enforcement of consumer protection laws and securities regulations relating to pyramid schemes, and business development and marketing of investment products to the UC Retirement Plan.   SB 726. Educating state legislature on issues relating to enforcement of consumer protection laws and securities regulations relating to pyramid schemes.   None   None   SB 726. Educating state legislature on issues relating to enforcement of consumer protection laws and securities regulations relating to pyramid schemes.   None.   None   None.   None.   None.   None.
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
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
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
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
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
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
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
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
Table: cvr_registration
filing_id   1718086   1718086   1922428   2114861   2244913
amend_id   0   1   0   0   0
rec_type   CVR   CVR   CVR   CVR   CVR
form_type   F603   F603   F603   F603   F606
sender_id   1346831   1346831   1346831   1346831   1346831
filer_id   1346831   1346831   1346831   1346831   1346831
entity_cd   LEM   LEM   LEM   LEM   LBY
filer_naml   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.
filer_namf   None   None   None   None   None
filer_namt   None   None   None   None   None
filer_nams   None   None   None   None   None
report_num   000   001   000   000   000
rpt_date   2012-12-18 00:00:00   2014-02-19 00:00:00   2014-12-31 00:00:00   2016-12-29 00:00:00   2018-05-02 00:00:00
ls_beg_yr   2013   2013   2015   2017   2017
ls_end_yr   2014   2014   2016   2018   2018
qual_date   None   None   None   2017-01-01 00:00:00   None
eff_date   None   None   None   None   2018-05-02 00:00:00
bus_city   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK
bus_st   NY   NY   NY   NY   NY
bus_zip4   10019   10019   10019   10019   10019
bus_phon   2128133700   2128133700   2128133700   2128133700   2128133700
bus_fax   2122861133   2122861133   2122861133   2122861133   None
bus_email   None   None   [email protected]   [email protected]   None
mail_city   None   None   None   None   None
mail_st   None   None   None   None   None
mail_zip4   None   None   None   None   None
mail_phon   None   None   None   None   None
sig_date   2012-12-18 00:00:00   2014-02-20 00:00:00   2014-12-31 00:00:00   2016-12-29 00:00:00   2018-05-02 00:00:00
sig_loc   None   None   None   None   None
sig_naml   Barefield   Barefield   Barefield   Coussin   Coussin
sig_namf   Timothy L.   Timothy L.   Timothy   Halit   Halit
sig_namt   None   None   None   None   None
sig_nams   None   None   None   None   None
prn_naml   Barefield   Barefield   Barefield   Coussin   Coussin
prn_namf   Timothy L.   Timothy L.   Timothy   Halit   Halit
prn_namt   None   None   None   None   None
prn_nams   None   None   None   None   None
sig_title   Chief Operating Officer   Chief Operating Officer   Chief Operating Officer   Chief Legal Officer/Chief Compliance Officer   Chief Legal Officer/Chief Compliance Officer
stmt_firm   None   None   None   None   None
ind_cb   None   None   None   None   None
bus_cb   X   X   X   X   None
trade_cb   None   None   None   None   None
oth_cb   None   None   None   None   None
a_b_name   None   None   None   None   None
a_b_city   None   None   None   None   None
a_b_st   None   None   None   None   None
a_b_zip4   None   None   None   None   None
descrip_1   None   None   None   None   None
descrip_2   Pershing Square Capital Management, L.P., a Delaware limited partnership, is an investment adviser registered with the SEC that serves as an investment manager and/or management company to various private investment funds.   Pershing Square Capital Management, L.P., a Delaware limited partnership, is an investment adviser registered with the SEC that serves as an investment manager and/or management company to various private investment funds.   Pershing Square Capital Management, L.P., a Delaware limited partnership, is an investment adviser registered with the SEC that serves as an investment manager and/or management company to various private investment funds.   Pershing Square Capital Management, L.P., a Delaware limited partnership, is an investment adviser registered with the SEC that serves as an investment manager and/or management company to various private investment funds.   None
c_less50   None   None   None   None   None
c_more50   None   None   None   None   None
ind_class   None   None   None   None   None
ind_descr   None   None   None   None   None
bus_class   FIN   FIN   FIN   FIN   None
bus_descr   None   None   None   None   None
auth_name   None   None   None   None   None
auth_city   None   None   None   None   None
auth_st   None   None   None   None   None
auth_zip4   None   None   None   None   None
lobby_int   Business development and marketing of investment products to public pension funds   Business development and marketing of investment products to public pension funds   Business development and marketing of investment products to public pension funds   Business development and marketing of investment products to public pension funds.   None
influen_yn   None   None   None   None   None
firm_name   None   None   None   None   None
newcert_cb   None   None   None   None   None
rencert_cb   None   None   None   None   None
complet_dt   None   None   None   None   None
lby_reg_cb   None   None   None   None   None
lby_604_cb   None   None   None   None   None
st_leg_yn   None   None   None   None   None
st_agency   None   None   None   None   None
lobby_cb   None   None   None   None   None
l_firm_cb   None   None   None   None   None
Table: filer_address
filer_id   1346831   1346831   1346831   1346831
adrid   2413618   2229058   2255336   2337685
effect_dt   2017-01-01 00:00:00   2012-03-28 00:00:00   2013-01-01 00:00:00   2015-01-01 00:00:00
add_type   7051   7051   7051   7051
session_id   2017   2011   2013   2015
Table: filer_filings
filer_id   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831
filing_id   1778410   1981877   1964669   1971175   1864610   1926051   1933749   1922428   1909248   1651176   1655301   1825540   1825547   1800086   1815200   1670993   1909248   1718086   1864610   1734588   1708330   1720909   1843558   1718086   1762474   1995145   2239829   2009900   2036217   2060930   2097814   2119317   2114861   2153641   2128372   2135709   2171591   2153641   2248562   2244913   2187872   2171591   2200718   2187872
period_id   214   222   221   None   218   None   220   220   218   None   209   None   None   215   216   210   219   212   218   212   211   None   217   217   213   223   233   224   225   226   227   None   228   229   228   None   230   229   None   234   231   230   232   231
form_id   F635   F635   F635   F602   F635   F603   F635   F603   F635   F603   F635   F602   F605   F635   F635   F635   F635   F603   F635   F635   F635   F603   F635   F603   F635   F635   F635   F635   F635   F635   F635   F603   F603   F635   F635   F602   F635   F635   F606   F606   F635   F635   F635   F635
filing_sequence   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   1   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   1   1   0   0
filing_date   2013-07-25 00:00:00   2015-07-31 00:00:00   2015-04-30 00:00:00   2015-06-01 00:00:00   2014-07-21 00:00:00   2015-01-06 00:00:00   2015-01-30 00:00:00   2014-12-31 00:00:00   2014-10-30 00:00:00   2012-03-28 00:00:00   2012-04-26 00:00:00   2014-02-21 00:00:00   2014-02-21 00:00:00   2013-10-31 00:00:00   2014-01-29 00:00:00   2012-07-12 00:00:00   2014-11-12 00:00:00   2012-12-18 00:00:00   2014-09-12 00:00:00   2013-01-29 00:00:00   2012-10-31 00:00:00   2012-12-19 00:00:00   2014-04-29 00:00:00   2014-02-19 00:00:00   2013-04-26 00:00:00   2015-10-28 00:00:00   2018-04-27 00:00:00   2016-01-29 00:00:00   2016-04-29 00:00:00   2016-07-29 00:00:00   2016-10-27 00:00:00   2016-12-30 00:00:00   2016-12-29 00:00:00   2017-04-26 00:00:00   2017-01-31 00:00:00   2017-01-19 00:00:00   2017-07-26 00:00:00   2017-08-15 00:00:00   2018-05-08 00:00:00   2018-05-02 00:00:00   2017-10-16 00:00:00   2017-08-15 00:00:00   2018-01-09 00:00:00   2017-10-16 00:00:00
stmnt_type   10001   10001   10001   10005   10001   10005   10001   10001   10001   10005   10001   10005   10006   10001   10001   10001   10002   10001   10002   10001   10001   10005   10001   10002   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10005   10001   10002   10003   10001   10002   10002   10001   10001
stmnt_status   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   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11003
session_id   2013   2015   2015   2015   2013   2015   2013   2015   2013   2011   2011   2013   2013   2013   2013   2011   2013   2013   2013   2011   2011   2013   2013   2013   2013   2015   2017   2015   2015   2015   2015   2017   2017   2017   2015   2017   2017   2017   2017   2017   217   2017   2017   217
user_id   AGLADNEY   AGLADNEY   AGLADNEY   YRODRIGU   AGLADNEY   GKURIMOT   MPACHECO   YRODRIGU   AGLADNEY   ASAETERN   AGLADNEY   PBANFORD   PBANFORD   ASAETERN   ASAETERN   ASAETERN   AGLADNEY   YRODRIGU   AGLADNEY   ASAETERN   ASAETERN   YRODRIGU   ASAETERN   YRODRIGU   AGLADNEY   AGLADNEY   CAFILER   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   PBANFORD   PBANFORD   AGLADNEY   AGLADNEY   GPEREZ   YRODRIGU   AGLADNEY   YRODRIGU   YRODRIGU   CAFILER   YRODRIGU   AGLADNEY   CAFILER
special_audit   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003
fine_audit   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   11003   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11003   11003   11003   11001   11001   11003
rpt_start   2013-04-01 00:00:00   2015-04-01 00:00:00   2015-01-01 00:00:00   1900-01-01 00:00:00   2014-04-01 00:00:00   1900-01-01 00:00:00   2014-10-01 00:00:00   2014-12-31 00:00:00   2014-06-01 00:00:00   1900-01-01 00:00:00   2012-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2013-07-01 00:00:00   2013-10-01 00:00:00   2012-04-01 00:00:00   2014-07-01 00:00:00   2012-12-18 00:00:00   2014-04-01 00:00:00   2012-10-01 00:00:00   2012-07-01 00:00:00   1900-01-01 00:00:00   2014-01-01 00:00:00   2014-02-19 00:00:00   2013-01-01 00:00:00   2015-07-01 00:00:00   2018-01-01 00:00:00   2015-10-01 00:00:00   2016-01-01 00:00:00   2016-04-01 00:00:00   2016-07-01 00:00:00   1900-01-01 00:00:00   2016-12-29 00:00:00   2017-01-01 00:00:00   2016-10-01 00:00:00   1900-01-01 00:00:00   2017-04-01 00:00:00   2017-01-01 00:00:00   1900-01-01 00:00:00   2018-05-02 00:00:00   0217-07-01 00:00:00   2017-04-01 00:00:00   2017-10-01 00:00:00   0217-07-01 00:00:00
rpt_end   2013-06-30 00:00:00   2015-06-30 00:00:00   2015-03-31 00:00:00   1900-01-01 00:00:00   2014-06-30 00:00:00   1900-01-01 00:00:00   2014-12-31 00:00:00   2014-12-31 00:00:00   2014-09-30 00:00:00   1900-01-01 00:00:00   2012-03-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2013-09-30 00:00:00   2013-12-31 00:00:00   2012-06-30 00:00:00   2014-09-30 00:00:00   2012-12-18 00:00:00   2014-06-30 00:00:00   2012-12-31 00:00:00   2012-09-30 00:00:00   1900-01-01 00:00:00   2014-03-31 00:00:00   2014-02-19 00:00:00   2013-03-31 00:00:00   2015-09-30 00:00:00   2018-03-31 00:00:00   2015-12-31 00:00:00   2016-03-31 00:00:00   2016-06-30 00:00:00   2016-09-30 00:00:00   1900-01-01 00:00:00   2016-12-29 00:00:00   2017-03-31 00:00:00   2016-12-31 00:00:00   1900-01-01 00:00:00   2017-06-30 00:00:00   2017-03-31 00:00:00   1900-01-01 00:00:00   2018-05-02 00:00:00   2017-09-30 00:00:00   2017-06-30 00:00:00   2017-12-31 00:00:00   2017-09-30 00:00:00
rpt_date   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
filing_type   22006   22006   22006   None   22006   None   22006   22006   22006   None   22006   None   None   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   22006   None   22006   22006   None   22006   22006   22006   22006   22006
Table: filer_interests
filer_id   1346831   1346831   1346831   1346831
session_id   2011   2013   2017   2015
interest_cd   40304   40304   40304   40304
effect_date   2012-03-28 00:00:00   2013-01-01 00:00:00   2017-01-01 00:00:00   2015-01-01 00:00:00
Table: filer_to_filer_type
filer_id   1346831   1346831   1346831   1346831   1346831
filer_type   2   2   2   2   2
active   Y   Y   T   Y   Y
race   0   None   None   None   None
session_id   2011   2013   2017   2015   2017
category   0   None   None   None   None
category_type   0   None   None   None   None
sub_category   0   None   None   None   None
effect_dt   2012-03-28 00:00:00   2013-01-01 00:00:00   2018-05-02 00:00:00   2015-01-01 00:00:00   2017-01-01 00:00:00
sub_category_type   0   None   None   None   None
election_type   0   None   None   None   None
sub_category_a   None   None   None   None   None
nyq_dt   None   None   None   None   None
party_cd   0   None   None   None   None
county_cd   0   None   None   None   None
district_cd   0   None   None   None   None
Table: filer_xref
filer_id   1346831
xref_id   1346831
effect_dt   2012-04-09 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831
filer_id   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831   1346831
filer_type   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER
status   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED
effect_dt   2018-05-02 00:00:00   2018-05-02 00:00:00   2018-05-02 00:00:00   2018-05-02 00:00:00   2018-05-02 00:00:00   2018-05-02 00:00:00   2018-05-02 00:00:00   2018-05-02 00:00:00   2018-05-02 00:00:00   2018-05-02 00:00:00   2018-05-02 00:00:00   2018-05-02 00:00:00   2018-05-02 00:00:00   2018-05-02 00:00:00   2018-05-02 00:00:00   2018-05-02 00:00:00
naml   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.
namf   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
nams   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
adr2   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
city   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK   NEW YORK
st   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY   NY
zip4   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019   10019
phon   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700   2128133700
fax   2122861133   2122861133   2122861133      2122861133   2122861133   2122861133      2122861133   2122861133   2122861133      2122861133   2122861133   2122861133   
email   None   None   [email protected]   None   None   None   [email protected]   None   None   None   [email protected]   None   None   None   [email protected]   None
Table: filers
filer_id   1346831
Table: lobbying_chg_log
filer_id   1346831   1346831   1346831   1346831
change_no   0   1   2   3
session_id   2011   2013   2015   2017
log_dt   2012-03-28 00:00:00   2014-02-21 00:00:00   2015-06-01 00:00:00   2018-05-31 00:00:00
filer_type   2   2   2   2
correction_flg   None   Y   Y   Y
action   ADDED   ADDED   ADDED   DELETED
attribute_changed   LOBBYIST   FIRM   FIRM   FIRM
ethics_dt   None   None   None   None
interests   None   None   None   None
filer_full_name   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.   PERSHING SQUARE CAPITAL MANAGEMENT, L.P.
filer_city   None   NEW YORK   NEW YORK   NEW YORK
filer_st   None   NY   NY   NY
filer_zip   None   10019   10019   10019
filer_phone   None   2128133700   2128133700   2128133700
entity_type   4   3   3   3
entity_name   STEPHEN SYMONDS   MERCURY PUBLIC AFFAIRS   MERCURY PUBLIC AFFAIRS   MERCURY PUBLIC AFFAIRS
entity_city   None   None   None   None
entity_st   None   None   None   None
entity_zip   None   None   None   None
entity_phone   None   None   None   None
entity_id   1346835   None   None   None
responsible_officer   None   None   None   None
effect_dt   2012-03-28 00:00:00   2014-02-18 00:00:00   2015-05-15 00:00:00   2018-03-31 00:00:00