Home

Filer ID: 1337586

Table: cvr_lobby_disclosure
filing_id   1621968   1591627   1606277   1636216   1678889   1708726   1657208   1736160   1798873   1781573   1764536   1815665   1868850   1843620   1909511   1980852   1964373   1993709   1934640   2060404   2035567   2008614   2099955   2174671   2156525   2126738   2189687   2273241   2240587   2205918   2392419   2344255   2317797   2376523   2444198   2468509   2412948   2483227   2531159   2554436   2624731   2579618   2603715   2677951   2707367   2642167   2749215
amend_id   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
rec_type   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   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
sender_id   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586
filer_id   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586
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
filer_naml   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)
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
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
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
report_num   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000
rpt_date   2011-10-20 00:00:00   2011-04-29 00:00:00   2011-07-20 00:00:00   2012-01-30 00:00:00   2012-07-16 00:00:00   2012-10-11 00:00:00   2012-04-24 00:00:00   2013-01-24 00:00:00   2013-10-25 00:00:00   2013-07-15 00:00:00   2013-04-11 00:00:00   2014-01-21 00:00:00   2014-07-10 00:00:00   2014-04-22 00:00:00   2014-10-21 00:00:00   2015-07-15 00:00:00   2015-04-16 00:00:00   2015-10-12 00:00:00   2015-01-19 00:00:00   2016-07-16 00:00:00   2016-04-11 00:00:00   2016-01-15 00:00:00   2016-10-19 00:00:00   2017-07-26 00:00:00   2017-04-13 00:00:00   2017-01-13 00:00:00   2017-10-12 00:00:00   2018-07-31 00:00:00   2018-04-13 00:00:00   2018-01-19 00:00:00   2019-07-16 00:00:00   2019-01-24 00:00:00   2018-10-10 00:00:00   2019-04-30 00:00:00   2020-01-31 00:00:00   2020-04-24 00:00:00   2019-10-07 00:00:00   2020-04-24 00:00:00   2020-10-31 00:00:00   2021-01-31 00:00:00   2021-01-31 00:00:00   2021-01-31 00:00:00   2021-01-31 00:00:00   2022-04-30 00:00:00   2022-07-26 00:00:00   2022-01-27 00:00:00   2022-10-24 00:00:00
from_date   2011-07-01 00:00:00   2011-01-01 00:00:00   2011-04-01 00:00:00   2011-10-01 00:00:00   2012-04-01 00:00:00   2012-07-01 00:00:00   2012-01-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-01-01 00:00:00   2014-07-01 00:00:00   2015-04-01 00:00:00   2015-01-01 00:00:00   2015-07-01 00:00:00   2014-10-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   2017-07-01 00:00:00   2018-04-01 00:00:00   2018-01-01 00:00:00   2017-10-01 00:00:00   2019-04-01 00:00:00   2018-10-01 00:00:00   2018-07-01 00:00:00   2019-01-01 00:00:00   2019-10-01 00:00:00   2020-01-01 00:00:00   2019-07-01 00:00:00   2020-04-01 00:00:00   2020-07-01 00:00:00   2020-10-01 00:00:00   2021-07-01 00:00:00   2021-01-01 00:00:00   2021-04-01 00:00:00   2022-01-01 00:00:00   2022-04-01 00:00:00   2021-10-01 00:00:00   2022-07-01 00:00:00
thru_date   2011-09-30 00:00:00   2011-03-31 00:00:00   2011-06-30 00:00:00   2011-12-31 00:00:00   2012-06-30 00:00:00   2012-09-30 00:00:00   2012-03-31 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-03-31 00:00:00   2014-09-30 00:00:00   2015-06-30 00:00:00   2015-03-31 00:00:00   2015-09-30 00:00:00   2014-12-31 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   2018-06-30 00:00:00   2018-03-31 00:00:00   2017-12-31 00:00:00   2019-06-30 00:00:00   2018-12-31 00:00:00   2018-09-30 00:00:00   2019-03-31 00:00:00   2019-12-31 00:00:00   2020-03-31 00:00:00   2019-09-30 00:00:00   2020-06-30 00:00:00   2020-09-30 00:00:00   2020-12-31 00:00:00   2021-09-30 00:00:00   2021-03-31 00:00:00   2021-06-30 00:00:00   2022-03-31 00:00:00   2022-06-30 00:00:00   2021-12-31 00:00:00   2022-09-30 00:00:00
cum_beg_dt   2011-01-01 00:00:00   2011-01-01 00:00:00   2011-01-01 00:00:00   2011-01-01 00:00:00   2011-01-01 00:00:00   2011-01-01 00:00:00   2011-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   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   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   2019-01-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00
firm_id   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)
firm_city   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   WASHINGTON   ARLINGTON   ARLINGTON   ARLINGTON   WASHINGTON   WASHINGTON   WASHINGTON   WASHINGTON   WASHINGTON   WASHINGTON   WASHINGTON   WASHINGTON   WASHINGTON   WASHINGTON   WASHINGTON   WASHINGTON   WASHINGTON
firm_st   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   DC   VA   VA   VA   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC   DC
firm_zip4   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   22209   20003   22209   22209   22209   20003   20003   20003   20003   20003   20003   20003   20003   20003   20003   20003   20003   20003
firm_phon   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 600-2053   (703) 841-2300   (703) 600-2053   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (202) 869-0200   (202) 869-0200   (202) 869-0200   (202) 869-0200   (202) 869-0200   (202) 869-0200   (202) 869-0200
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   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   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   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
sig_date   2011-10-20 00:00:00   2011-04-29 00:00:00   2011-07-20 00:00:00   2012-01-30 00:00:00   2012-07-16 00:00:00   2012-10-11 00:00:00   2012-04-24 00:00:00   2013-01-24 00:00:00   2013-10-25 00:00:00   2013-07-15 00:00:00   2013-04-11 00:00:00   2014-01-21 00:00:00   2014-07-10 00:00:00   2014-04-22 00:00:00   2014-10-21 00:00:00   2015-07-15 00:00:00   2015-04-16 00:00:00   2015-10-12 00:00:00   2015-01-19 00:00:00   2016-07-16 00:00:00   2016-04-11 00:00:00   2016-01-15 00:00:00   2016-10-19 00:00:00   2017-07-26 00:00:00   2017-04-13 00:00:00   2017-01-13 00:00:00   2017-10-12 00:00:00   2018-07-14 00:00:00   2018-04-13 00:00:00   2018-01-19 00:00:00   2019-07-16 00:00:00   2019-01-24 00:00:00   2018-10-10 00:00:00   2019-04-14 00:00:00   2020-01-31 00:00:00   2020-04-24 00:00:00   2019-10-07 00:00:00   2020-07-20 00:00:00   2020-10-30 00:00:00   2021-01-21 00:00:00   2021-10-19 00:00:00   2021-04-26 00:00:00   2021-07-28 00:00:00   2022-05-02 00:00:00   2022-07-26 00:00:00   2022-01-27 00:00:00   2022-10-24 00:00:00
sig_loc   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   WASHINGTON, DC   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   WASHINGTON, DC   WASHINGTON, DC   WASHINGTON, DC   WASHINGTON, DC   WASHINGTON, DC   WASHINGTON, DC   WASHINGTON, DC   WASHINGTON, DC   WASHINGTON, DC   WASHINGTON, DC   WASHINGTON, DC   WASHINGTON, DC   WASHINGTON, DC
sig_naml   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   BREWER   BREWER   RINZEL   BREWER   ROSE   BREWER   BREWER   ROSE   ROSE   ROSE   ROSE   ROSE   ROSE   ROSE   ROSE   ROSE   ROSE   BREWER   BREWER   BREWER   BREWER   BREWER   BREWER   BREWER
sig_namf   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JASON   JASON   JOE   JASON   BRIAN   JASON   JASON   BRIAN   BRIAN   BRIAN   BRIAN   BRIAN   BRIAN   BRIAN   BRIAN   BRIAN   BRIAN   JASON   JASON   JASON   JASON   JASON   JASON   JASON
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
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
prn_naml   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   BREWER   BREWER   RINZEL   BREWER   ROSE   BREWER   BREWER   ROSE   ROSE   ROSE   ROSE   ROSE   ROSE   ROSE   ROSE   ROSE   ROSE   BREWER   BREWER   BREWER   BREWER   BREWER   BREWER   BREWER
prn_namf   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JASON   JASON   JOE   JASON   BRIAN   JASON   JASON   BRIAN   BRIAN   BRIAN   BRIAN   BRIAN   BRIAN   BRIAN   BRIAN   BRIAN   BRIAN   JASON   JASON   JASON   JASON   JASON   JASON   JASON
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
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
sig_title   VP, STATE GOVERNMENT AFFAIRS 4525KAH   VP, STATE GOVERNMENT AFFAIRS 4525KAH   VP, STATE GOVERNMENT AFFAIRS 4525KAH   VP, STATE GOVERNMENT AFFAIRS 4525KAH   VP, STATE GOVERNMENT AFFAIRS 4525KAU   VP, STATE GOVERNMENT AFFAIRS 4525KAU   VP, STATE GOVERNMENT AFFAIRS 4525KAU   VP, STATE GOVERNMENT AFFAIRS 4525KAU   VP, STATE GOVERNMENT AFFAIRS 4525KAU   VP, STATE GOVERNMENT AFFAIRS 4525KAU   VP, STATE GOVERNMENT AFFAIRS 4525KAU   VP, STATE GOVERNMENT AFFAIRS 4525KAU   VP, STATE GOVERNMENT AFFAIRS 4525KAU   VP, STATE GOVERNMENT AFFAIRS 4525KAU   VP, STATE GOVERNMENT AFFAIRS 4525KAU   SVP, GOVERNMENT AFFAIRS 4525KAU   SVP, GOVERNMENT AFFAIRS 4525KAU   SVP, GOVERNMENT AFFAIRS 4525KAU   VP, STATE GOVERNMENT AFFAIRS 4525KAU   SVP, GOVERNMENT AFFAIRS 4525KAU   SVP, GOVERNMENT AFFAIRS 4525KAU   SVP, GOVERNMENT AFFAIRS 4525KAU   SVP, GOVERNMENT AFFAIRS 4525KAU   SVP, GOVERNMENT AFFAIRS 4525KAU   SVP, GOVERNMENT AFFAIRS 4525KAU   SVP, GOVERNMENT AFFAIRS 4525KAU   SVP, GOVERNMENT AFFAIRS 4525KAU   DIRECTOR OF STATE AFFAIRS & ADVOCACY   EVP   EVP   DIRECTOR OF STATE AFFAIRS & ADVOCACY   DIRECTOR OF STATE AFFAIRS & ADVOCACY   DIRECTOR OF STATE AFFAIRS & ADVOCACY   DIRECTOR OF STATE AFFAIRS & ADVOCACY   DIRECTOR OF STATE AFFAIRS & ADVOCACY   DIRECTOR OF STATE AFFAIRS & ADVOCACY   DIRECTOR OF STATE AFFAIRS & ADVOCACY   DIRECTOR OF STATE AFFAIRS & ADVOCACY   DIRECTOR OF STATE AFFAIRS & ADVOCACY   DIRECTOR OF STATE AFFAIRS & ADVOCACY   EXECUTIVE VICE PRESIDENT   EXECUTIVE VICE PRESIDENT   EXECUTIVE VICE PRESIDENT   EXECUTIVE VICE PRESIDENT   EXECUTIVE VICE PRESIDENT   EXECUTIVE VICE PRESIDENT   EXECUTIVE VICE PRESIDENT
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
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
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
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
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   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
lby_actvty   NONE   AB 153, 155; SB 862   AB 950; SB 862   NONE   NONE   NONE   NONE   NONE   AB 880   AB 880   NONE   NONE   CA Air Resources Board: Re: Sustainable Freight Strategy; Attorney General's Office Re: Retail Transactions, Privacy   CA Air Resources Board: Re: Sustainable Freight Strategy/ CA Department of Food and Agriculture Re: Alternative Fuel Measurement Standards   SB 1138, 1204; CA Air Resources Board: Re: Sustainable Freight Strategy; Attorney General's Office, Legislature, Governor's Office Re: Retail Transactions, Privacy   AB 259, 357, 820; OFFICE OF ENVIRONMENTAL HEALTH HAZARD ASSESSMENT RE: PROP 65   AB 259; OFFICE OF ENVIRONMENTAL HEALTH HAZARD ASSESSMENT RE: PROP 65; AIR RESOURCES BOARD RE: SUSTAINABLE FRIEGHT PLAN   AB 259, 357, 820; OFFICE OF ENVIRONMENTAL HEALTH HAZARD ASSESSMENT RE: PROP 65; GOVERNOR'S OFFICE, AIR RESOURCES BOARD, DEPT OF TRANSPORTATION RE: SUSTAINABLE FREIGHT INITIATIVE   NONE   SB 878; GOVERNORS OFFICE, LEGISLATURE RE: SUSTAINABLE FREIGHT PLAN; LEGISLATURE, GOVERNOR OFFICE, CA TRANSPORTATION AUTHORITY, AIR RESOURCES BOARD, DEPT OF TRANSPORTATION RE: FRIEGHT & SUPPLY CHAIN   SB 878; GOVERNOR'S OFFICE, CA AIR RESOURCES BOARD, CALTRANS, LEGISLATURE RE: SUSTAINABLE FREIGHT; LEGISLATURE RE: SUPPLY CHAIN & CHIP & PIN ISSUES   AB 259, 357, 820; OFFICE OF ENVIRONMENTAL HEALTH HAZARD ASSESSMENT RE: PROP 65; GOVERNOR'S OFFICE, AIR RESOURCES BOARD, DEPT OF TRANSPORTATION RE: SUSTAINABLE FREIGHT STRATEGY   SB 423, 878; GOVERNORS OFFICE, LEGISLATURE RE: CA SUSTAINABLE FREIGHT ACTION PLAN; LEGISLATURE, GOVERNOR OFFICE, CA TRANSPORTATION AUTHORITY, AIR RESOURCES BOARD, DEPT OF TRANSPORTATION RE: FRIEGHT & SUPPLY CHAIN   AB 5, 241; SB 327; GOVERNOR'S OFFICE, LEGISLATURE, CA AIR RESOURCES BOARD RE: INDIRECT SOURCE; LEGISLATURE, GOVERNOR'S OFFICE, CA TRANSPORTATION AUTHORITY, AIR RESOURCES BOARD, DEPARTMENT OF TRANSPORTATION RE: FREIGHT & SUPPLY CHAIN ISSUES, CAP & TRADE ISSUES   AB 5, 241; LEGISLATURE, GOVERNOR OFFICE, CA TRANSPORTATION AUTHORITY, AIR RESOURCES BOARD, DEPT OF TRANSPORTATION RE: FRIEGHT & SUPPLY CHAIN; GOVERNORS OFFICE, LEGISLATURE RE: STATE FREIGHT PLAN, CA AIR RESOURCES BOARD STATE IMPLEMENTATION PLAN, CONTAINER FEES   CA AIR RESOURCES BOARD, CAL TRANS RE: CA SUSTAINABLE FREIGHT ACTION PLAN; LEGISLATURE, GOVERNOR OFFICE, CA TRANSPORTATION AUTHORITY, AIR RESOURCES BOARD, DEPT OF TRANSPORTATION RE: FRIEGHT & SUPPLY CHAIN   AB 375, 398, 617, 1724; SB 327; GOVERNOR'S OFFICE, LEGISLATURE, CA AIR RESOURCES BOARD RE: FREIGHT EMISSIONS; LEGISLATURE, GOVERNOR'S OFFICE, CA TRANSPORTATION AUTHORITY, AIR RESOURCES BOARD, DEPARTMENT OF TRANSPORTATION RE: FREIGHT & SUPPLY CHAIN ISSUES, CAP & TRADE ISSUES   AB 281, 375, 2016, 2069, 2379, 2841, 2998, 3080; SB 327, 993, 1121, 1284, 1398, 1402; LEGISLATURE, GOVERNOR'S OFFICE, AIR RESOURCES BOARD, DEPT OF TRANSPORTATION RE: FREIGHT AND SUPPLY CHAIN ISSUES   AB 5, 281, 375, 2016; SB 327, 1398; LEGISLATURE, GOVERNOR'S OFFICE, AIR RESOURCES BOARD, DEPARTMENT OF TRANSPORTATION RE: FREIGHT & SUPPLY CHAIN ISSUES   LEGISLATURE, CA AIR RESOURCES BOARD RE: FREIGHT EMISSIONS; LEGISLATURE, GOVERNOR'S OFFICE, CA TRANSPORTATION AUTHORITY, AIR RESOURCES BOARD, DEPARTMENT OF TRANSPORTATION RE: FREIGHT & SUPPLY CHAIN ISSUES, CAP & TRADE ISSUES   NONE   NONE   AB 281, 375, 1065, 2016, 2069, 2841, 2998, 3080; SB 327, 993, 1121, 1284, 1398, 1402; LEGISLATURE, GOVERNOR'S OFFICE, AIR RESOURCES BOARD, DEPT OF TRANSPORTATION RE: FREIGHT AND SUPPLY CHAIN ISSUES   NONE   NONE   NONE   NONE   NONE   NONE   NONE   NONE   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   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
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
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
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
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
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
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
Table: cvr_registration
filing_id   1598220   1598234   1726167   1769529   1918109   1923037   2113624   2116665   2331216   2539046
amend_id   0   0   0   0   0   0   0   0   0   0
rec_type   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR
form_type   F602   F602   F602   F602   F602   F602   F602   F602   F602   F602
sender_id   1318975   1339224   1339224   1261533   1339224   1261533   1261533   1339224   1261533   1261533
filer_id   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586
entity_cd   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM
filer_naml   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)
filer_namf   None   None   None   None   None   None   None   None   None   None
filer_namt   None   None   None   None   None   None   None   None   None   None
filer_nams   None   None   None   None   None   None   None   None   None   None
report_num   000   000   000   000   000   000   000   000   000   000
rpt_date   2011-03-15 00:00:00   2011-06-01 00:00:00   2012-12-18 00:00:00   2013-05-23 00:00:00   2014-11-10 00:00:00   2014-11-13 00:00:00   2016-11-16 00:00:00   2016-11-10 00:00:00   2018-12-30 00:00:00   2020-12-31 00:00:00
ls_beg_yr   2011   2011   2013   2013   2015   2015   2017   2017   2019   2021
ls_end_yr   2012   2012   2014   2014   2016   2016   2018   2018   2020   2022
qual_date   None   None   None   None   None   None   None   None   None   None
eff_date   2011-03-15 00:00:00   2011-06-01 00:00:00   2012-01-01 00:00:00   2013-05-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   2019-01-01 00:00:00   2021-01-01 00:00:00
bus_city   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   WASHINGTON
bus_st   VA   VA   VA   VA   VA   VA   VA   VA   VA   DC
bus_zip4   22209   22209   22209   22209   22209   22209   22209   22209   22209   20003
bus_phon   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   (703) 841-2300   202-869-0200
bus_fax   (703) 841-1184   (703) 841-1184   (703) 841-1184   (703) 841-1184   (703) 841-1184   (703) 841-1184   (703) 841-1184   (703) 841-1184   (703) 841-1184   None
bus_email   None   None   None   None   None   None   None   None   None   None
mail_city   None   None   None   None   None   None   None   None   None   None
mail_st   None   None   None   None   None   None   None   None   None   None
mail_zip4   None   None   None   None   None   None   None   None   None   None
mail_phon   None   None   None   None   None   None   None   None   None   None
sig_date   2011-03-15 00:00:00   2011-05-17 00:00:00   2012-12-18 00:00:00   2013-05-23 00:00:00   2014-11-10 00:00:00   2014-11-13 00:00:00   2016-11-16 00:00:00   2016-11-10 00:00:00   2018-12-15 00:00:00   2020-12-08 00:00:00
sig_loc   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA   ARLINGTON, VA
sig_naml   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   ROSE   BREWER
sig_namf   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   BRIAN   JASON
sig_namt   None   None   None   None   None   None   None   None   None   None
sig_nams   None   None   None   None   None   None   None   None   None   None
prn_naml   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   RINZEL   ROSE   BREWER
prn_namf   JOE   JOE   JOE   JOE   JOE   JOE   JOE   JOE   BRIAN   JASON
prn_namt   None   None   None   None   None   None   None   None   None   None
prn_nams   None   None   None   None   None   None   None   None   None   None
sig_title   VP, STATE GOVERNMENT AFFAIRS 4525KAH   VP, STATE GOVERNMENT AFFAIRS 4525KAH   VP, STATE GOVERNMENT AFFAIRS 4525KAU   VP, STATE GOVERNMENT AFFAIRS (44420-MM)   SVP, GOVERNMENT AFFAIRS 4525KAU   SENIOR VP, GOVERNMENT AFFAIRS (44420-MM)   SENIOR VP, GOVERNMENT AFFAIRS (44420-slm)   SVP, GOVERNMENT AFFAIRS 4525KAU   DIRECTOR OF STATE AFFAIRS & ADVOCACY   EXECUTIVE VP, COMMUNICATIONS & STATE AFFAIRS
stmt_firm   None   None   None   None   None   None   None   None   None   None
ind_cb   None   None   None   None   None   None   None   None   None   None
bus_cb   None   None   None   None   None   None   None   None   None   None
trade_cb   X   X   X   X   X   X   X   X   X   X
oth_cb   None   None   None   None   None   None   None   None   None   None
a_b_name   None   None   None   None   None   None   None   None   None   None
a_b_city   None   None   None   None   None   None   None   None   None   None
a_b_st   None   None   None   None   None   None   None   None   None   None
a_b_zip4   None   None   None   None   None   None   None   None   None   None
descrip_1   THE RETAIL INDUSRTY LEADERS ASSOCIATION (RILA) IS A NATIONAL TRADE ASSOCIATION OF RETAIL COMPANIES.   THE RETAIL INDUSRTY LEADERS ASSOCIATION (RILA) IS A NATIONAL TRADE ASSOCIATION OF RETAIL COMPANIES.   THE RETAIL INDUSRTY LEADERS ASSOCIATION (RILA) IS A NATIONAL TRADE ASSOCIATION OF RETAIL COMPANIES.   RETAIL TRADE ASSOCIATION   THE RETAIL INDUSRTY LEADERS ASSOCIATION (RILA) IS A NATIONAL TRADE ASSOCIATION OF RETAIL COMPANIES.   RETAIL TRADE ASSOCIATION   RETAIL TRADE ASSOCIATION   THE RETAIL INDUSRTY LEADERS ASSOCIATION (RILA) IS A NATIONAL TRADE ASSOCIATION OF RETAIL COMPANIES.   RETAIL TRADE ASSOCIATION   RETAIL TRADE ASSOCIATION
descrip_2   None   None   None   GENERAL MERCHANDISE, SPECIALTY MERCHANDISE, HOME IMPROVEMENT   None   GENERAL MERCHANDISE, SPECIALTY MERCHANDISE, HOME IMPROVEMENT   GENERAL MERCHANDISE, SPECIALTY MERCHANDISE, HOME IMPROVEMENT   None   GENERAL MERCHANDISE, SPECIALTY MERCHANDISE, HOME IMPROVEMENT   GENERAL MERCHANDISE, SPECIALTY MERCHANDISE, HOME IMPROVEMENT
c_less50   None   None   None   None   None   None   None   None   None   None
c_more50   X   X   X   X   X   X   X   X   X   X
ind_class   None   None   None   OTH   None   OTH   OTH   None   None   None
ind_descr   None   None   None   RETAIL   None   RETAIL   RETAIL   None   None   None
bus_class   MER   MER   MER   MER   MER   MER   MER   MER   MER   MER
bus_descr   None   None   None   None   None   None   None   None   None   None
auth_name   JACK ADVOCACY GROUP   CAPITOL STRATEGIC ADVISORS, LLC   CAPITOL STRATEGIC ADVISORS, LLC   POLITICAL SOLUTIONS, LLC   CAPITOL STRATEGIC ADVISORS, LLC   POLITICAL SOLUTIONS, LLC   POLITICAL SOLUTIONS, LLC   CAPITOL STRATEGIC ADVISORS, LLC   POLITICAL SOLUTIONS, LLC   POLITICAL SOLUTIONS, LLC
auth_city   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO
auth_st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
auth_zip4   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814
lobby_int   None   None   None   None   None   None   None   None   None   None
influen_yn   None   None   None   None   None   None   None   None   None   None
firm_name   None   None   None   None   None   None   None   None   None   None
newcert_cb   None   None   None   None   None   None   None   None   None   None
rencert_cb   None   None   None   None   None   None   None   None   None   None
complet_dt   None   None   None   None   None   None   None   None   None   None
lby_reg_cb   None   None   None   None   None   None   None   None   None   None
lby_604_cb   None   None   None   None   None   None   None   None   None   None
st_leg_yn   None   None   None   None   None   None   None   None   None   None
st_agency   None   None   None   None   None   None   None   None   None   None
lobby_cb   None   None   None   None   None   None   None   None   None   None
l_firm_cb   None   None   None   None   None   None   None   None   None   None
Table: filer_acronyms
acronym   RILA
filer_id   1337586
Table: filer_address
filer_id   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586
adrid   2213815   2418262   2550064   2509075   2277780   2482556   2468898   2339573
effect_dt   2011-02-17 00:00:00   2017-01-01 00:00:00   2023-01-01 00:00:00   2021-01-01 00:00:00   2013-01-01 00:00:00   2019-06-10 00:00:00   2019-01-01 00:00:00   2015-01-01 00:00:00
add_type   7051   7051   7051   7051   7051   7051   7051   7051
session_id   2011   2017   2023   2021   2013   2019   2019   2015
Table: filer_filings
filer_id   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586
filing_id   1770951   1769529   1781573   1943700   1964373   1868850   1798873   1948821   1909511   1591627   1584323   1596784   1598234   1598220   1606277   1621968   1587321   1636216   1657208   1678889   1815665   1934640   1918109   1923037   1708726   1726167   1736160   1843620   1743502   1764536   1993709   1980852   2273241   2344255   2189687   2240587   2205918   2392419   2376523   2531159   2008614   2035567   2060404   2099955   2126738   2113624   2116665   2156525   2142357   2143204   2174671   2412948   2317797   2351611   2468509   2331216   2539046   2554436   2483227   2444198   2603715   2579618   2707367   2624731   2677951   2569201   2642167   2749215
period_id   None   214   214   None   221   218   215   None   219   205   None   None   206   205   206   207   None   208   209   210   216   220   220   220   211   212   212   217   None   213   223   222   234   236   231   233   232   238   237   243   224   225   226   227   228   228   228   229   None   None   230   239   235   None   241   236   244   244   242   240   246   245   250   247   249   None   248   251
form_id   F602   F602   F635   F602   F635   F635   F635   F602   F635   F635   F602   F602   F602   F602   F635   F635   F602   F635   F635   F635   F635   F635   F602   F602   F635   F602   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F602   F635   F602   F602   F635   F635   F635   F602   F635   F602   F602   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635
filing_sequence   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
filing_date   2013-05-30 00:00:00   2013-05-29 00:00:00   2013-07-31 00:00:00   2015-01-05 00:00:00   2015-04-29 00:00:00   2014-07-29 00:00:00   2013-10-29 00:00:00   2014-12-15 00:00:00   2014-10-30 00:00:00   2011-05-02 00:00:00   2011-02-22 00:00:00   2011-06-01 00:00:00   2011-06-27 00:00:00   2011-06-27 00:00:00   2011-07-29 00:00:00   2011-10-31 00:00:00   2011-03-29 00:00:00   2012-01-31 00:00:00   2012-04-30 00:00:00   2012-07-31 00:00:00   2014-01-29 00:00:00   2015-01-30 00:00:00   2014-12-12 00:00:00   2015-01-05 00:00:00   2012-10-31 00:00:00   2013-01-15 00:00:00   2013-01-30 00:00:00   2014-04-29 00:00:00   2013-01-15 00:00:00   2013-04-30 00:00:00   2015-10-23 00:00:00   2015-07-30 00:00:00   2018-07-30 00:00:00   2019-01-29 00:00:00   2017-10-23 00:00:00   2018-04-30 00:00:00   2018-01-26 00:00:00   2019-07-23 00:00:00   2019-04-23 00:00:00   2020-11-02 00:00:00   2016-01-28 00:00:00   2016-04-29 00:00:00   2016-07-28 00:00:00   2016-10-29 00:00:00   2017-01-30 00:00:00   2016-12-22 00:00:00   2017-01-03 00:00:00   2017-04-29 00:00:00   2017-01-03 00:00:00   2016-12-22 00:00:00   2017-07-30 00:00:00   2019-10-14 00:00:00   2018-10-30 00:00:00   2018-12-31 00:00:00   2020-04-28 00:00:00   2018-12-31 00:00:00   2020-12-29 00:00:00   2021-02-01 00:00:00   2020-07-29 00:00:00   2020-01-31 00:00:00   2021-08-02 00:00:00   2021-04-29 00:00:00   2022-08-01 00:00:00   2021-11-01 00:00:00   2022-05-02 00:00:00   2020-12-30 00:00:00   2022-01-29 00:00:00   2022-10-31 00:00:00
stmnt_type   10005   10001   10001   10005   10001   10001   10001   10005   10001   10001   10005   10005   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001
stmnt_status   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003   11003   11001   11001   11003   11001   11001   11001   11001   11001   11003   11003   11001   11003   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   11003   11001   11003   11001   11001   11003
session_id   2013   2013   2013   2015   2015   2013   2013   2015   2013   2011   2011   2011   2011   2011   2011   2011   2011   2011   2011   2011   2013   2013   2015   2015   2011   2013   2011   2013   2013   2013   2015   2015   2017   2017   2017   2017   2017   2019   2019   2019   2015   2015   2015   2015   2015   2017   2017   2017   2017   2017   2017   2019   2017   2019   2019   2019   2021   2019   2019   2019   2021   2021   2021   2021   2021   2021   2021   2021
user_id   PBANFORD   PBANFORD   AGLADNEY   GKURIMOT   AGLADNEY   ASAETERN   ASAETERN   GPEREZ   AGLADNEY   AGLADNEY   ASAETERN   ASAETERN   *   *   AGLADNEY   AGLADNEY   ASAETERN   AGLADNEY   ASAETERN   AGLADNEY   ASAETERN   AGLADNEY   CAFILER   CAFILER   AGLADNEY   CAFILER   AGLADNEY   ASAETERN   GPEREZ   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   SUSHAKOV   VUKSTINA   GTAYLOR   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   CAFILER   YRODRIGU   AGLADNEY   YRODRIGU   GPEREZ   AGLADNEY   GTAYLOR   AGLADNEY   PBANFORD   GTAYLOR   PBANFORD   MMERCHANT   GTAYLOR   GTAYLOR   GTAYLOR   MKIRKHAM   GTAYLOR   CAFILER   GTAYLOR   CAFILER   MMERCHANT   CHATRIDGE   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   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   11003   11001   11001   11003   11003   11003   11003   11001   11001   11003   11001   11001   11001   11001   11001   11003   11003   11001   11003   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11003   11001   11003   11003   11001   11003
rpt_start   1900-01-01 00:00:00   2013-05-23 00:00:00   2013-04-01 00:00:00   1900-01-01 00:00:00   2015-01-01 00:00:00   2014-04-01 00:00:00   2013-07-01 00:00:00   1900-01-01 00:00:00   2014-07-01 00:00:00   2011-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2011-06-01 00:00:00   2011-03-15 00:00:00   2011-04-01 00:00:00   2011-07-01 00:00:00   1900-01-01 00:00:00   2011-10-01 00:00:00   2012-01-01 00:00:00   2012-04-01 00:00:00   2013-10-01 00:00:00   2014-10-01 00:00:00   2014-11-10 00:00:00   2014-11-13 00:00:00   2012-07-01 00:00:00   2012-12-18 00:00:00   2012-10-01 00:00:00   2014-01-01 00:00:00   1900-01-01 00:00:00   2013-01-01 00:00:00   2015-07-01 00:00:00   2015-04-01 00:00:00   2018-04-01 00:00:00   2018-10-01 00:00:00   2017-07-01 00:00:00   2018-01-01 00:00:00   2017-10-01 00:00:00   2019-04-01 00:00:00   2019-01-01 00:00:00   2020-07-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   2016-10-01 00:00:00   2016-11-16 00:00:00   2016-11-10 00:00:00   2017-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2017-04-01 00:00:00   2019-07-01 00:00:00   2018-07-01 00:00:00   1900-01-01 00:00:00   2020-01-01 00:00:00   2018-12-30 00:00:00   2020-12-31 00:00:00   2020-10-01 00:00:00   2020-04-01 00:00:00   2019-10-01 00:00:00   2021-04-01 00:00:00   2021-01-01 00:00:00   2022-04-01 00:00:00   2021-07-01 00:00:00   2022-01-01 00:00:00   1900-01-01 00:00:00   2021-10-01 00:00:00   2022-07-01 00:00:00
rpt_end   1900-01-01 00:00:00   2013-05-23 00:00:00   2013-06-30 00:00:00   1900-01-01 00:00:00   2015-03-31 00:00:00   2014-06-30 00:00:00   2013-09-30 00:00:00   1900-01-01 00:00:00   2014-09-30 00:00:00   2011-03-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2011-06-01 00:00:00   2011-03-15 00:00:00   2011-06-30 00:00:00   2011-09-30 00:00:00   1900-01-01 00:00:00   2011-12-31 00:00:00   2012-03-31 00:00:00   2012-06-30 00:00:00   2013-12-31 00:00:00   2014-12-31 00:00:00   2014-11-10 00:00:00   2014-11-13 00:00:00   2012-09-30 00:00:00   2012-12-18 00:00:00   2012-12-31 00:00:00   2014-03-31 00:00:00   1900-01-01 00:00:00   2013-03-31 00:00:00   2015-09-30 00:00:00   2015-06-30 00:00:00   2018-06-30 00:00:00   2018-12-31 00:00:00   2017-09-30 00:00:00   2018-03-31 00:00:00   2017-12-31 00:00:00   2019-06-30 00:00:00   2019-03-31 00:00:00   2020-09-30 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   2016-12-31 00:00:00   2016-11-16 00:00:00   2016-11-10 00:00:00   2017-03-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2017-06-30 00:00:00   2019-09-30 00:00:00   2018-09-30 00:00:00   1900-01-01 00:00:00   2020-03-31 00:00:00   2018-12-30 00:00:00   2020-12-31 00:00:00   2020-12-31 00:00:00   2020-06-30 00:00:00   2019-12-31 00:00:00   2021-06-30 00:00:00   2021-03-31 00:00:00   2022-06-30 00:00:00   2021-09-30 00:00:00   2022-03-31 00:00:00   1900-01-01 00:00:00   2021-12-31 00:00:00   2022-09-30 00:00:00
rpt_date   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   22001   22001   None   22001   22001   22001   None   22001   22001   None   None   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   None   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001
Table: filer_interests
filer_id   1337586   1337586   1337586   1337586   1337586   1337586   1337586
session_id   2013   2017   2011   2019   2021   2015   2023
interest_cd   40311   40311   40311   40311   40311   40311   40311
effect_date   2013-01-01 00:00:00   2017-01-01 00:00:00   2011-02-17 00:00:00   2019-01-01 00:00:00   2021-01-01 00:00:00   2015-01-01 00:00:00   2023-01-01 00:00:00
Table: filer_to_filer_type
filer_id   1337586   1337586   1337586   1337586   1337586   1337586   1337586
filer_type   1   1   1   1   1   1   1
active   Y   Y   Y   Y   Y   Y   N
race   None   0   None   None   None   None   None
session_id   2013   2011   2017   2019   2015   2021   2023
category   None   0   None   None   None   None   None
category_type   None   0   None   None   None   None   None
sub_category   None   0   None   None   None   None   None
effect_dt   2013-01-01 00:00:00   2011-02-17 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
sub_category_type   None   0   None   None   None   None   None
election_type   None   0   None   None   None   None   None
sub_category_a   None   None   None   None   None   None   None
nyq_dt   None   None   None   None   None   None   None
party_cd   None   0   None   None   None   None   None
county_cd   None   0   None   None   None   None   None
district_cd   None   0   None   None   None   None   None
Table: filer_xref
filer_id   1337586
xref_id   1337586
effect_dt   2011-03-29 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586
filer_id   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586   1337586
filer_type   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT
status   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   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
naml   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION   RETAIL INDUSTRY LEADERS ASSOCIATION   RETAIL INDUSTRY LEADERS ASSOCIATION   RETAIL INDUSTRY LEADERS ASSOCIATION   RETAIL INDUSTRY LEADERS ASSOCIATION   RETAIL INDUSTRY LEADERS ASSOCIATION   RETAIL INDUSTRY LEADERS ASSOCIATION   RETAIL INDUSTRY LEADERS ASSOCIATION
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
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
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
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
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
city   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   WASHINGTON   WASHINGTON   WASHINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   WASHINGTON   WASHINGTON   WASHINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   WASHINGTON   WASHINGTON   WASHINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   WASHINGTON   WASHINGTON   WASHINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   WASHINGTON   WASHINGTON   WASHINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   WASHINGTON   WASHINGTON   WASHINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   ARLINGTON   WASHINGTON   WASHINGTON   WASHINGTON
st   VA   VA   VA   VA   VA   DC   DC   DC   VA   VA   VA   VA   VA   DC   DC   DC   VA   VA   VA   VA   VA   DC   DC   DC   VA   VA   VA   VA   VA   DC   DC   DC   VA   VA   VA   VA   VA   DC   DC   DC   VA   VA   VA   VA   VA   DC   DC   DC   VA   VA   VA   VA   VA   DC   DC   DC
zip4   22209   22209   22209   22209   22209   20003   20003   20003   22209   22209   22209   22209   22209   20003   20003   20003   22209   22209   22209   22209   22209   20003   20003   20003   22209   22209   22209   22209   22209   20003   20003   20003   22209   22209   22209   22209   22209   20003   20003   20003   22209   22209   22209   22209   22209   20003   20003   20003   22209   22209   22209   22209   22209   20003   20003   20003
phon   7036002053   7038412300   7038412300   7038412300   7038412300   7038412300   2028690200   2028690200   7036002053   7038412300   7038412300   7038412300   7038412300   7038412300   2028690200   2028690200   7036002053   7038412300   7038412300   7038412300   7038412300   7038412300   2028690200   2028690200   7036002053   7038412300   7038412300   7038412300   7038412300   7038412300   2028690200   2028690200   7036002053   7038412300   7038412300   7038412300   7038412300   7038412300   2028690200   2028690200   7036002053   7038412300   7038412300   7038412300   7038412300   7038412300   2028690200   2028690200   7036002053   7038412300   7038412300   7038412300   7038412300   7038412300   2028690200   2028690200
fax   None   7038411184   7038411184   7038411184   7038411184   7038411184         None   7038411184   7038411184   7038411184   7038411184   7038411184         None   7038411184   7038411184   7038411184   7038411184   7038411184         None   7038411184   7038411184   7038411184   7038411184   7038411184         None   7038411184   7038411184   7038411184   7038411184   7038411184         None   7038411184   7038411184   7038411184   7038411184   7038411184         None   7038411184   7038411184   7038411184   7038411184   7038411184      
email   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: filers
filer_id   1337586
Table: lobbying_chg_log
filer_id   1337586   1337586   1337586   1337586   1337586
change_no   1   0   2   3   4
session_id   2011   2011   2011   2017   2021
log_dt   2011-06-01 00:00:00   2011-03-22 00:00:00   2011-03-29 00:00:00   2018-01-26 00:00:00   2020-12-30 00:00:00
filer_type   1   1   2   2   1
correction_flg   None   None   Y   Y   None
action   DELETED   ADDED   ADDED   DELETED   CHANGED
attribute_changed   FIRM   FIRM   FIRM   FIRM   RESPONSIBLE OFFICER
ethics_dt   None   None   None   None   None
interests   None   None   None   None   None
filer_full_name   RETAIL INDUSTRY LEADERS ASSOCIATION   RETAIL INDUSTRY LEADERS ASSOCIATION   RETAIL INDUSTRY LEADERS ASSOCIATION   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)   RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)
filer_city   None   None   ARLINGTON   None   None
filer_st   None   None   VA   None   None
filer_zip   None   None   22209   None   None
filer_phone   None   None   7036002053   None   None
entity_type   3   3   3   3   20
entity_name   JACK ADVOCACY GROUP   MERCURY PUBLIC AFFAIRS   JACK ADVOCACY GROUP   CAPITOL STRATEGIC ADVISORS, LLC   EXECUTIVE VICE PRESIDENT, COMMUNICATION & STATE AFFAIRS JASON BREWER
entity_city   None   None   None   None   None
entity_st   None   None   None   None   None
entity_zip   None   None   None   None   None
entity_phone   None   None   None   None   None
entity_id   1318975   1325943   None   1339224   1437193
responsible_officer   None   None   None   None   None
effect_dt   2011-05-31 00:00:00   2011-02-17 00:00:00   2011-03-15 00:00:00   2018-01-31 00:00:00   2021-01-01 00:00:00
Table: received_filings
filer_id   1337586   1337586   1337586   1337586
filing_file_name   1769529_0.cal   2113624_0.cal   1923037_0.cal   119627.cal
received_date   2013-05-29 00:00:00   2016-12-22 00:00:00   2015-01-05 00:00:00   2019-07-23 00:00:00
filing_directory   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp
filing_id   1769529   2113624   1923037   None
form_id   F602   F602   F602   None
receive_comment   Filing accepted   Filing accepted   Filing accepted   Filing passed validation, but failed DB constraints