Home

Filer ID: 1070360

Table: filer_address
filer_id   1070360   1070360   1070360   1070360   1070360   1070360   1070360
adrid   1081581   2106761   2399556   2399555   2437367   2437368   2377417
effect_dt   1997-04-11 00:00:00   2006-07-10 00:00:00   2016-05-23 00:00:00   2016-05-23 00:00:00   2017-07-05 00:00:00   2017-07-05 00:00:00   2015-12-14 00:00:00
add_type   7051   7051   7082   7051   7051   7082   7051
session_id   1997   2005   2015   2015   2017   2017   2015
Table: filer_filings
filer_id   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360
filing_id   444261   742253   810426   838059   1187447   2004729   2001509   2052533   2048057   2146457   2166440   2161658   2474341   2474353   2369548   2383056
period_id   150   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
form_id   F410   F410   F460   F460   F410   F410   F410   F410   F410   F410   F410   F410   F888   F410 AT   F410   F888
filing_sequence   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
filing_date   1997-04-08 00:00:00   2001-03-21 00:00:00   2002-01-24 00:00:00   2002-03-01 00:00:00   2006-07-10 00:00:00   2016-01-11 00:00:00   2015-12-14 00:00:00   2016-06-17 00:00:00   2016-05-23 00:00:00   2017-03-10 00:00:00   2017-07-05 00:00:00   2017-05-22 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2019-03-28 00:00:00   2019-03-28 00:00:00
stmnt_type   10001   10002   10005   10005   10006   10006   10006   10006   10006   10006   10006   10006   10005   10003   10003   10005
stmnt_status   11001   11001   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11002   11001
session_id   1997   2001   2001   2001   2005   2015   2015   2015   2015   2017   2017   2017   2019   2019   2019   2019
user_id   *   TTHAM   MKIENG   MKIENG   TTHAM   TRAMON   TRAMON   DHOANG   TRAMON   LPALMER   RSAGARIO   LPALMER   TRAMON   TRAMON   TRAMON   TRAMON
special_audit   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003
fine_audit   11001   11001   11003   11003   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003
rpt_start   None   1998-01-01 00:00:00   2001-07-01 00:00:00   2002-01-20 00:00:00   None   None   None   None   None   None   None   None   None   None   None   None
rpt_end   None   1998-01-01 00:00:00   2001-12-31 00:00:00   2002-02-16 00:00:00   None   None   None   None   None   None   None   None   None   None   None   None
rpt_date   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
Table: filer_to_filer_type
filer_id   1070360   1070360   1070360   1070360
filer_type   16   16   16   16
active   Y   Y   Y   T
race   30035   30035   30035   30035
session_id   1997   2017   2015   2019
category   40002   40002   40002   40002
category_type   40505   40505   40505   40505
sub_category   0   0   0   0
effect_dt   1997-04-11 00:00:00   2017-05-22 00:00:00   2016-01-11 00:00:00   2020-05-11 00:00:00
sub_category_type   0   0   0   0
election_type   0   0   0   0
sub_category_a   None   None   None   None
nyq_dt   1997-04-02 00:00:00   1997-04-02 00:00:00   1997-04-02 00:00:00   1997-04-02 00:00:00
party_cd   None   None   None   None
county_cd   18039   18039   18039   18039
district_cd   None   None   None   None
Table: filer_xref
filer_id   1070360
xref_id   970516
effect_dt   1999-12-07 00:00:00
migration_source   IDENTFIX
Table: filername
xref_filer_id   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516   970516
filer_id   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360   1070360
filer_type   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE
status   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED   TERMINATED
effect_dt   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00   2020-05-11 00:00:00
naml   PETTIS OFFICEHOLDER ACCOUNT, MAYOR PRO TEM GREG   PETTIS OFFICEHOLDER ACCOUNT, MAYOR PRO TEM GREG   PETTIS OFFICEHOLDER ACCOUNT, MAYOR PRO TEM GREG   PETTIS OFFICEHOLDER ACCOUNT, MAYOR PRO TEM GREG   PETTIS OFFICEHOLDER ACCOUNT, MAYOR PRO TEM GREG   PETTIS OFFICEHOLDER ACCOUNT, MAYOR PRO TEM GREG   PETTIS OFFICEHOLDER ACCOUNT, MAYOR PRO TEM GREG   PETTIS, FRIENDS OF GREG   PETTIS, FRIENDS OF GREG   PETTIS, FRIENDS OF GREG   PETTIS, FRIENDS OF GREG   PETTIS, FRIENDS OF GREG   PETTIS, FRIENDS OF GREG   PETTIS, FRIENDS OF GREG   PETTIS FOR CITY COUNCIL 2016, FRIENDS OF GREG   PETTIS FOR CITY COUNCIL 2016, FRIENDS OF GREG   PETTIS FOR CITY COUNCIL 2016, FRIENDS OF GREG   PETTIS FOR CITY COUNCIL 2016, FRIENDS OF GREG   PETTIS FOR CITY COUNCIL 2016, FRIENDS OF GREG   PETTIS FOR CITY COUNCIL 2016, FRIENDS OF GREG   PETTIS FOR CITY COUNCIL 2016, FRIENDS OF GREG   PETTIS FOR CITY COUNCIL 2016, GREG   PETTIS FOR CITY COUNCIL 2016, GREG   PETTIS FOR CITY COUNCIL 2016, GREG   PETTIS FOR CITY COUNCIL 2016, GREG   PETTIS FOR CITY COUNCIL 2016, GREG   PETTIS FOR CITY COUNCIL 2016, GREG   PETTIS FOR CITY COUNCIL 2016, GREG   PETTIS FOR CITY COUNCIL 2020, FRIENDS OF GREG   PETTIS FOR CITY COUNCIL 2020, FRIENDS OF GREG   PETTIS FOR CITY COUNCIL 2020, FRIENDS OF GREG   PETTIS FOR CITY COUNCIL 2020, FRIENDS OF GREG   PETTIS FOR CITY COUNCIL 2020, FRIENDS OF GREG   PETTIS FOR CITY COUNCIL 2020, FRIENDS OF GREG   PETTIS FOR CITY COUNCIL 2020, FRIENDS OF GREG
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
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
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
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
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
city   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY   CATHEDRAL CITY
st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
zip4   922340000   922340000   92234   92234   92235   92234   92235   922340000   922340000   92234   92234   92235   92234   92235   922340000   922340000   92234   92234   92235   92234   92235   922340000   922340000   92234   92234   92235   92234   92235   922340000   922340000   92234   92234   92235   92234   92235
phon   7603249482   7604088420   7604088420   7604088420      7604088420      7603249482   7604088420   7604088420   7604088420      7604088420      7603249482   7604088420   7604088420   7604088420      7604088420      7603249482   7604088420   7604088420   7604088420      7604088420      7603249482   7604088420   7604088420   7604088420      7604088420   
fax   None   None   None   7604066129      7604066129      None   None   None   7604066129      7604066129      None   None   None   7604066129      7604066129      None   None   None   7604066129      7604066129      None   None   None   7604066129      7604066129   
email   None   None   greg@gregpettis.com   greg@gregpettis.com   None   greg@gregpettis.com   None   None   None   greg@gregpettis.com   greg@gregpettis.com   None   greg@gregpettis.com   None   None   None   greg@gregpettis.com   greg@gregpettis.com   None   greg@gregpettis.com   None   None   None   greg@gregpettis.com   greg@gregpettis.com   None   greg@gregpettis.com   None   None   None   greg@gregpettis.com   greg@gregpettis.com   None   greg@gregpettis.com   None
Table: filers
filer_id   1070360