filer_id | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | |||||
---|---|---|---|---|---|---|---|---|---|---|
adrid | 1110166 | 1109922 | 1108822 | 2314966 | 2341664 | |||||
effect_dt | 1994-12-01 00:00:00 | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 2014-04-24 00:00:00 | 2015-01-01 00:00:00 | |||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | |||||
session_id | 1995 | 1997 | 1999 | 2013 | 2015 |
filer_id | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 509410 | 505778 | 506001 | 507684 | 507415 | 508084 | 505415 | 508356 | 504992 | 505415 | 541900 | 509021 | 508753 | 508356 | 504422 | 504767 | 507006 | 508753 | 509021 | 509675 | 510044 | 541900 | 504992 | 506001 | 507415 | 504011 | 508753 | 506788 | 504011 | 541900 | 610633 | 628998 | 641243 | 656787 | 650676 | 714993 | 688494 | 776138 | 870212 | 1974932 | 1845067 | 1960170 | 1939050 | 1908635 | 1933105 | 1918252 | 1871288 | 1845067 | 1992654 | 2003475 | 2027219 | 2061505 | 2098464 | 2121192 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 155 | 158 | 143 | 145 | 152 | 153 | 150 | 146 | 142 | 150 | 151 | 147 | 154 | 146 | 149 | 157 | 144 | 154 | 147 | 148 | 156 | 151 | 142 | 143 | 152 | 141 | 154 | 159 | 141 | 151 | 160 | 161 | 162 | 155 | 155 | 164 | 163 | 149 | 157 | 222 | None | 221 | None | 219 | 220 | 220 | 218 | None | 223 | 224 | 225 | 226 | 227 | 228 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F690 | F690 | F690 | F690 | F690 | F690 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F690 | F690 | F690 | F690 | F625 | F625 | F690 | F625 | F625 | F625 | F690 | F690 | F625 | F625 | F666 | F666 | F625 | F601 | F625 | F601 | F625 | F625 | F601 | F625 | F601 | F625 | F625 | F625 | F625 | F625 | F625 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1998-10-14 00:00:00 | 1999-07-29 00:00:00 | 1995-10-30 00:00:00 | 1996-04-29 00:00:00 | 1998-01-29 00:00:00 | 1998-04-29 00:00:00 | 1997-07-29 00:00:00 | 1996-07-31 00:00:00 | 1995-12-18 00:00:00 | 1997-07-31 00:00:00 | 1998-01-29 00:00:00 | 1997-01-31 00:00:00 | 1998-10-07 00:00:00 | 1996-11-04 00:00:00 | 1997-04-30 00:00:00 | 1999-04-27 00:00:00 | 1996-01-31 00:00:00 | 1998-07-28 00:00:00 | 1996-10-31 00:00:00 | 1997-01-31 00:00:00 | 1999-01-28 00:00:00 | 1997-10-31 00:00:00 | 1995-07-28 00:00:00 | 1995-12-18 00:00:00 | 1998-05-19 00:00:00 | 1995-07-26 00:00:00 | 1998-10-13 00:00:00 | 1999-10-21 00:00:00 | 1995-04-27 00:00:00 | 1998-03-03 00:00:00 | 2000-01-25 00:00:00 | 2000-04-12 00:00:00 | 2000-07-19 00:00:00 | 2000-08-28 00:00:00 | 2000-08-08 00:00:00 | 2001-01-09 00:00:00 | 2000-10-11 00:00:00 | 2000-11-30 00:00:00 | 2002-10-01 00:00:00 | 2015-07-17 00:00:00 | 2014-04-25 00:00:00 | 2015-04-21 00:00:00 | 2014-12-23 00:00:00 | 2014-10-29 00:00:00 | 2015-01-29 00:00:00 | 2014-12-15 00:00:00 | 2014-07-31 00:00:00 | 2014-04-24 00:00:00 | 2015-10-20 00:00:00 | 2016-01-12 00:00:00 | 2016-04-11 00:00:00 | 2016-07-29 00:00:00 | 2016-10-27 00:00:00 | 2017-01-19 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10006 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1999 | 1995 | 1995 | 1997 | 1997 | 1997 | 1995 | 1995 | 1997 | 1997 | 1995 | 1997 | 1995 | 1997 | 1999 | 1995 | 1997 | 1995 | 1995 | 1997 | 1997 | 1995 | 1995 | 1997 | 1995 | 1997 | 1999 | 1995 | 1997 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1997 | 1999 | 2015 | 2013 | 2015 | 2015 | 2013 | 2013 | 2015 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | TTHAM | GGILMORE | JLEHMAN | KCHAN | JLEHMAN | MKIENG | MKIENG | PROBERTS | PROBERTS | AGLADNEY | YRODRIGU | AGLADNEY | GPEREZ | ASAETERN | AGLADNEY | YRODRIGU | ASAETERN | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1998-07-01 00:00:00 | 1999-04-01 00:00:00 | 1995-07-01 00:00:00 | 1996-01-01 00:00:00 | 1997-10-01 00:00:00 | 1998-01-01 00:00:00 | 1997-04-01 00:00:00 | 1996-04-01 00:00:00 | 1995-04-01 00:00:00 | 1997-04-01 00:00:00 | 1997-07-01 00:00:00 | 1996-07-01 00:00:00 | 1998-04-01 00:00:00 | 1996-04-01 00:00:00 | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 1995-10-01 00:00:00 | 1998-04-01 00:00:00 | 1996-07-01 00:00:00 | 1996-10-01 00:00:00 | 1998-10-01 00:00:00 | 1997-07-01 00:00:00 | 1995-04-01 00:00:00 | 1995-07-01 00:00:00 | 1997-10-01 00:00:00 | 1995-01-01 00:00:00 | 1998-04-01 00:00:00 | 1999-07-01 00:00:00 | 1995-01-01 00:00:00 | 1997-07-01 00:00:00 | 1999-10-01 00:00:00 | 2000-01-01 00:00:00 | 2000-04-01 00:00:00 | 1998-07-01 00:00:00 | 1998-07-01 00:00:00 | 2000-10-01 00:00:00 | 2000-07-01 00:00:00 | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 2015-04-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2014-10-01 00:00:00 | 2014-12-15 00:00:00 | 2014-04-01 00:00:00 | 1900-01-01 00:00:00 | 2015-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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1998-09-30 00:00:00 | 1999-06-30 00:00:00 | 1995-09-30 00:00:00 | 1996-03-31 00:00:00 | 1997-12-31 00:00:00 | 1998-03-31 00:00:00 | 1997-06-30 00:00:00 | 1996-06-30 00:00:00 | 1995-06-30 00:00:00 | 1997-06-30 00:00:00 | 1997-09-30 00:00:00 | 1996-09-30 00:00:00 | 1998-06-30 00:00:00 | 1996-06-30 00:00:00 | 1997-03-31 00:00:00 | 1999-03-31 00:00:00 | 1995-12-31 00:00:00 | 1998-06-30 00:00:00 | 1996-09-30 00:00:00 | 1996-12-31 00:00:00 | 1998-12-31 00:00:00 | 1997-09-30 00:00:00 | 1995-06-30 00:00:00 | 1995-09-30 00:00:00 | 1997-12-31 00:00:00 | 1995-03-31 00:00:00 | 1998-06-30 00:00:00 | 1999-09-30 00:00:00 | 1995-03-31 00:00:00 | 1997-09-30 00:00:00 | 1999-12-31 00:00:00 | 2000-03-31 00:00:00 | 2000-06-30 00:00:00 | 1998-09-30 00:00:00 | 1998-09-30 00:00:00 | 2000-12-31 00:00:00 | 2000-09-30 00:00:00 | 1998-12-31 00:00:00 | 2000-12-31 00:00:00 | 2015-06-30 00:00:00 | 1900-01-01 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2014-12-31 00:00:00 | 2014-12-15 00:00:00 | 2014-06-30 00:00:00 | 1900-01-01 00:00:00 | 2015-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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | |||||
---|---|---|---|---|---|---|---|---|---|---|
filer_type | 3 | 3 | 3 | 3 | 3 | |||||
active | Y | Y | Y | Y | Y | |||||
race | 0 | 0 | 0 | 0 | None | |||||
session_id | 1997 | 1995 | 1999 | 2013 | 2015 | |||||
category | 0 | 0 | 0 | 0 | None | |||||
category_type | 0 | 0 | 0 | 0 | None | |||||
sub_category | 0 | 0 | 0 | 0 | None | |||||
effect_dt | 1997-01-01 00:00:00 | 1994-12-01 00:00:00 | 1999-01-01 00:00:00 | 2014-04-24 00:00:00 | 2015-01-01 00:00:00 | |||||
sub_category_type | 0 | 0 | 0 | 0 | None | |||||
election_type | 0 | 0 | 0 | 0 | None | |||||
sub_category_a | None | None | None | None | None | |||||
nyq_dt | None | None | None | None | None | |||||
party_cd | None | None | None | None | None | |||||
county_cd | None | None | None | None | None | |||||
district_cd | None | None | None | None | None |
filer_id | 1147492 | |
---|---|---|
xref_id | F24598 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | F24598 | F24598 | F24598 | F24598 | F24598 | F24598 | F24598 | F24598 | F24598 | F24598 | F24598 | F24598 | F24598 | F24598 | F24598 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | |||||||||||||||
filer_type | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | |||||||||||||||
status | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | |||||||||||||||
effect_dt | 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 | 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 | 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 | |||||||||||||||
naml | GIBSON, DUNN & CRUTCHER LLP | GIBSON, DUNN & CRUTCHER LLP | GIBSON, DUNN & CRUTCHER LLP | GIBSON, DUNN & CRUTCHER LLP | GIBSON, DUNN & CRUTCHER LLP | GIBSON, DUNN & CRUTCHER LLP | GIBSON, DUNN & CRUTCHER LLP | GIBSON, DUNN & CRUTCHER LLP | GIBSON, DUNN & CRUTCHER LLP | GIBSON, DUNN & CRUTCHER LLP | GIBSON, DUNN & CRUTCHER LLP | GIBSON, DUNN & CRUTCHER LLP | GIBSON, DUNN & CRUTCHER LLP | GIBSON, DUNN & CRUTCHER LLP | GIBSON, DUNN & CRUTCHER LLP | |||||||||||||||
namf | 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 | |||||||||||||||
nams | 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 | |||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
city | LOS ANGELES | LOS ANGELES | LOS ANGELES | LOS ANGELES | LOS ANGELES | LOS ANGELES | LOS ANGELES | LOS ANGELES | LOS ANGELES | LOS ANGELES | LOS ANGELES | LOS ANGELES | LOS ANGELES | LOS ANGELES | LOS ANGELES | |||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||
zip4 | 90071 | 900713197 | 90071 | 90071 | 90071 | 90071 | 900713197 | 90071 | 90071 | 90071 | 90071 | 900713197 | 90071 | 90071 | 90071 | |||||||||||||||
phon | 2132297000 | 2132297000 | 2132297000 | 2132297260 | 2132297000 | 2132297000 | 2132297000 | 2132297000 | 2132297260 | 2132297000 | 2132297000 | 2132297000 | 2132297000 | 2132297260 | 2132297000 | |||||||||||||||
fax | None | None | None | 2132296260 | 2132297520 | None | None | None | 2132296260 | 2132297520 | None | None | None | 2132296260 | 2132297520 | |||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1147492 |
---|
filer_id | 1147492 | 1147492 | 1147492 | 1147492 | ||||
---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 0 | 3 | ||||
session_id | 1999 | 1999 | 2013 | 2013 | ||||
log_dt | 2000-05-24 00:00:00 | 2000-10-13 00:00:00 | 2014-04-25 00:00:00 | 2014-04-25 00:00:00 | ||||
filer_type | 3 | 3 | 3 | 3 | ||||
correction_flg | Y | Y | None | None | ||||
action | DELETED | DELETED | ADDED | ADDED | ||||
attribute_changed | LOBBYIST | DELETED CLIENT | LOBBYIST | CLIENT | ||||
ethics_dt | None | None | None | None | ||||
interests | None | None | None | None | ||||
filer_full_name | GIBSON, DUNN & CRUTCHER LLP | GIBSON, DUNN & CRUTCHER LLP | GIBSON, DUNN & CRUTCHER LLP | GIBSON, DUNN & CRUTCHER LLP | ||||
filer_city | None | None | None | None | ||||
filer_st | None | None | None | None | ||||
filer_zip | None | None | None | None | ||||
filer_phone | None | None | None | None | ||||
entity_type | 4 | 1 | 4 | 1 | ||||
entity_name | CHARLES C. IVIE | UNITED PARCEL SERVICE | MAURICE SUH | KING'S CASINO, LLC | ||||
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 | 1148693 | 1143678 | 1366997 | 1366998 | ||||
responsible_officer | None | None | None | None | ||||
effect_dt | None | None | 2014-04-24 00:00:00 | 2014-04-24 00:00:00 |
filer_id | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | 1147492 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 1918252_0.cal | 65242.cal | 65262.cal | 65064.cal | 65158.cal | 65306.cal | ||||||
received_date | 2014-12-15 00:00:00 | 2014-12-15 00:00:00 | 2014-12-15 00:00:00 | 2014-12-15 00:00:00 | 2014-12-15 00:00:00 | 2014-12-15 00:00:00 | ||||||
filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | ||||||
filing_id | 1918252 | None | None | None | None | None | ||||||
form_id | F601 | None | None | None | None | None | ||||||
receive_comment | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints |