Home

Filer ID: 1381488

Table: cvr_campaign_disclosure
filing_id   2032879   2038328   2041476   2012153   2021128   2024352   2027796   2001676   2045709   2083140   2061429   2084579   2050730   2051041   2053707   2053708   2053709   2052300   2061429   2052300   2065223   2118320   2097974
amend_id   0   0   0   0   0   0   0   0   0   0   1   0   0   0   0   0   0   0   0   1   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
form_type   F497   F460   F497   F460   F497   F497   F497   F497   F497   F460   F460   F497   F497   F497   F497   F497   F497   F497   F460   F497   F497   F460   F460
filer_id   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488
entity_cd   BMC   BMC   BMC   BMC   BMC   BMC   BMC   CTL   BMC   BMC   BMC   BMC   BMC   BMC   BMC   BMC   BMC   BMC   BMC   BMC   BMC   BMC   BMC
filer_naml   Californians for Hospital Accountability and Quality Care, Sponsored by Service Employees International Union - United Healthcare Workers West   Californians for Hospital Accountability and Quality Care, Sponsored by Service Employees International Union - United Healthcare Workers West   Californians for Hospital Accountability and Quality Care, Sponsored by Service Employees International Union - United Healthcare Workers West   Californians for Hospital Accountability and Quality Care, Sponsored by Service Employees International Union - United Healthcare Workers West   Californians for Hospital Accountability and Quality Care, Sponsored by Service Employees International Union - United Healthcare Workers West   Californians for Hospital Accountability and Quality Care, Sponsored by Service Employees International Union - United Healthcare Workers West   Californians for Hospital Accountability and Quality Care, Sponsored by Service Employees International Union - United Healthcare Workers West   Californians for Hospital Accountability and Quality Care, Sponsored by Service Employees International Union - United Healthcare Workers West   Californians for Hospital Accountability and Quality Care, Sponsored by Service Employees International Union - United Healthcare Workers West   Californians for Hospital Accountability and Quality Care ? No on 52, Sponsored by Service Employees International Union ? United Healthcare Workers West   Californians for Hospital Accountability and Quality Care ? No on 52, Sponsored by Service Employees International Union ? United Healthcare Workers West   Californians for Hospital Accountability and Quality Care - No on 52, Sponsored by Service Employees International Union - United Healthcare Workers West   Californians for Hospital Accountability and Quality Care, Sponsored by Service Employees International Union - United Healthcare Workers West   Californians for Hospital Accountability and Quality Care, Sponsored by Service Employees International Union - United Healthcare Workers West   Californians for Hospital Accountability and Quality Care, Sponsored by Service Employees International Union - United Healthcare Workers West   Californians for Hospital Accountability and Quality Care, Sponsored by Service Employees International Union - United Healthcare Workers West   Californians for Hospital Accountability and Quality Care, Sponsored by Service Employees International Union - United Healthcare Workers West   Californians for Hospital Accountability and Quality Care, Sponsored by Service Employees International Union - United Healthcare Workers West   Californians for Hospital Accountability and Quality Care - No on 52, Sponsored by Service Employees International Union - United Healthcare Workers West   Californians for Hospital Accountability and Quality Care ? No on 52, Sponsored by Service Employees International Union ? United Healthcare Workers West   Californians for Hospital Accountability and Quality Care ? No on 52, Sponsored by Service Employees International Union ? United Healthcare Workers West   Californians for Hospital Accountability and Quality Care ? No on 52, Sponsored by Service Employees International Union ? United Healthcare Workers West   Californians for Hospital Accountability and Quality Care ? No on 52, Sponsored by Service Employees International Union ? United Healthcare Workers West
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
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
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
report_num   000   000   000   000   000   000   000   000   000   000   1   000   000   000   000   000   000   000   000   1   000   000   000
rpt_date   2016-04-26 00:00:00   2016-05-02 00:00:00   2016-05-10 00:00:00   2016-02-01 00:00:00   2016-03-16 00:00:00   2016-03-29 00:00:00   2016-04-12 00:00:00   2015-12-22 00:00:00   2016-05-24 00:00:00   2016-09-29 00:00:00   2016-09-29 00:00:00   2016-10-03 00:00:00   2016-06-08 00:00:00   2016-06-10 00:00:00   2016-07-06 00:00:00   2016-07-06 00:00:00   2016-07-06 00:00:00   2016-06-22 00:00:00   2016-08-01 00:00:00   2016-08-02 00:00:00   2016-08-02 00:00:00   2017-01-10 00:00:00   2016-10-27 00:00:00
stmt_type   None   QT   None   SA   None   None   None   None   None   PE   QT   None   None   None   None   None   None   None   QT   None   None   TS   PE
late_rptno   042616A   None   051016A   None   031616A   032916A   041216A   122215A   052416A   None   None   100316A   060816A   061016A   070616A   070616B   070616C   062216A   None   062216A   080216A   None   None
from_date   None   2016-01-01 00:00:00   None   2015-01-01 00:00:00   None   None   None   None   None   2016-07-01 00:00:00   2016-04-01 00:00:00   None   None   None   None   None   None   None   2016-04-01 00:00:00   None   None   2016-10-23 00:00:00   2016-09-25 00:00:00
thru_date   None   2016-03-31 00:00:00   None   2015-12-31 00:00:00   None   None   None   None   None   2016-09-24 00:00:00   2016-06-30 00:00:00   None   None   None   None   None   None   None   2016-06-30 00:00:00   None   None   2016-12-31 00:00:00   2016-10-22 00:00:00
elect_date   None   None   None   None   None   None   None   None   None   2016-11-08 00:00:00   None   None   None   None   None   None   None   None   None   None   None   None   2016-11-08 00:00:00
filer_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   Los Angeles   Los Angeles   Los Angeles   Los Angeles   Los Angeles   Los Angeles   Los Angeles   Los Angeles
filer_st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
filer_zip4   90017   90017   90017   90017   90017   90017   90017   90017   90017   90017   90017   90017   90017   90017   90017   90017   90017   90017   90017   90017   90017   90017   90017
filer_phon   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565   (213) 452-6565
filer_fax   None   (213) 452-6575   None   (213) 452-6575   None   None   None   None   None   (213) 452-6575   (213) 452-6575   None   None   None   None   None   None   None   (213) 452-6575   None   None   (213) 452-6575   (213) 452-6575
file_email   None   [email protected]   None   [email protected]   None   None   None   None   None   [email protected]   [email protected]   None   None   None   None   None   None   None   [email protected]   None   None   [email protected]   [email protected]
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
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
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
tres_naml   None   Jimenez   None   Jimenez   None   None   None   None   None   Jimenez   Jimenez   None   None   None   None   None   None   None   Jimenez   None   None   Jimenez   Jimenez
tres_namf   None   Arianna   None   Arianna   None   None   None   None   None   Arianna   Arianna   None   None   None   None   None   None   None   Arianna   None   None   Arianna   Arianna
tres_namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
tres_nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
tres_city   None   Los Angeles   None   Los Angeles   None   None   None   None   None   Los Angeles   Los Angeles   None   None   None   None   None   None   None   Los Angeles   None   None   Los Angeles   Los Angeles
tres_st   None   CA   None   CA   None   None   None   None   None   CA   CA   None   None   None   None   None   None   None   CA   None   None   CA   CA
tres_zip4   None   90017   None   90017   None   None   None   None   None   90017   90017   None   None   None   None   None   None   None   90017   None   None   90017   90017
tres_phon   None   (213) 452-6565   None   (213) 452-6565   None   None   None   None   None   (213) 452-6565   (213) 452-6565   None   None   None   None   None   None   None   (213) 452-6565   None   None   (213) 452-6565   (213) 452-6565
tres_fax   None   (213) 452-6575   None   (213) 452-6575   None   None   None   None   None   (213) 452-6575   (213) 452-6575   None   None   None   None   None   None   None   (213) 452-6575   None   None   (213) 452-6575   (213) 452-6575
tres_email   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cmtte_type   None   B   None   B   None   None   None   None   None   B   B   None   None   None   None   None   None   None   B   None   None   B   B
control_yn   None   N   None   N   None   None   None   None   None   N   N   None   None   None   None   None   None   None   N   None   None   N   N
sponsor_yn   None   N   None   N   None   None   None   None   None   N   N   None   None   None   None   None   None   None   N   None   None   N   N
primfrm_yn   None   Y   None   Y   None   None   None   None   None   Y   Y   None   None   None   None   None   None   None   Y   None   None   Y   Y
brdbase_yn   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
amendexp_1   None   None   None   None   None   None   None   None   None   None   Summary Page, Schedule A, Schedule B Amended   None   None   None   None   None   None   None   None   Contributions Received Amended   None   None   None
amendexp_2   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
amendexp_3   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
rpt_att_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cmtte_id   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
reportname   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
rptfromdt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
rptthrudt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
emplbus_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_name   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_city   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_st   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_zip4   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_inter   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
busact_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
busactvity   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
assoc_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
assoc_int   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
other_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
other_int   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_naml   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_namf   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_city   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_st   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_zip4   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_phon   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_fax   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_email   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bal_name   None   Hospital Executive Compensation Act of 2016 (15-0111)   None   Hospital Executive Compensation Act of 2016 (15-0111)   None   None   None   None   None   Hospital Executive Compensation Act of 2016 (15-0111)   Hospital Executive Compensation Act of 2016 (15-0111)   None   None   None   None   None   None   None   Hospital Executive Compensation Act of 2016 (15-0111)   None   None   Hospital Executive Compensation Act of 2016 (15-0111)   Hospital Executive Compensation Act of 2016 (15-0111)
bal_num   None   N/A   None   N/A   None   None   None   None   None   N/A   N/A   None   None   None   None   None   None   None   N/A   None   None   N/A   N/A
bal_juris   None   Statewide   None   Statewide   None   None   None   None   None   Statewide   Statewide   None   None   None   None   None   None   None   Statewide   None   None   Statewide   Statewide
office_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
offic_dscr   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
juris_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
juris_dscr   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
dist_no   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
off_s_h_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
sup_opp_cd   None   S   None   S   None   None   None   None   None   S   S   None   None   None   None   None   None   None   S   None   None   O   S
employer   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
occupation   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
selfemp_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bal_id   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_id   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: filer_address
filer_id   1381488
adrid   2376570
effect_dt   2015-12-07 00:00:00
add_type   7051
session_id   2015
Table: filer_filings
filer_id   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488
filing_id   2000837   2001917   2001676   2021128   2012153   2024990   2024352   2038328   2027796   2041476   2044476   2061429   2051041   2052300   2032879   2050730   2053707   2053708   2053709   2061762   2052300   2065223   2045709   2083140   2061429   2084579   2097974   2106194   2076888   2118320   2120908   2125244   2076888   2112365   2403501
period_id   None   None   224   225   221   None   225   225   226   226   None   226   226   226   226   226   227   227   227   None   227   227   226   227   226   228   227   None   None   228   None   None   None   None   None
form_id   F410   F410   F497   F497   F460   F460   F497   F460   F497   F497   F460   F460   F497   F497   F497   F497   F497   F497   F497   F410   F497   F497   F497   F460   F460   F497   F460   F460   F460   F460   F410   F460   F460   F460   F666
filing_sequence   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   0   1   0   0   0   0   0   0   0   1   0   0
filing_date   2015-12-07 00:00:00   2015-12-24 00:00:00   2015-12-22 00:00:00   2016-03-16 00:00:00   2016-02-01 00:00:00   2016-02-01 00:00:00   2016-03-29 00:00:00   2016-05-02 00:00:00   2016-04-12 00:00:00   2016-05-10 00:00:00   2016-05-02 00:00:00   2016-07-29 00:00:00   2016-06-10 00:00:00   2016-06-22 00:00:00   2016-04-26 00:00:00   2016-06-08 00:00:00   2016-07-06 00:00:00   2016-07-06 00:00:00   2016-07-06 00:00:00   2016-07-22 00:00:00   2016-08-02 00:00:00   2016-08-02 00:00:00   2016-05-24 00:00:00   2016-09-29 00:00:00   2016-09-29 00:00:00   2016-10-03 00:00:00   2016-10-27 00:00:00   2016-09-29 00:00:00   2016-08-01 00:00:00   2017-01-10 00:00:00   2017-01-11 00:00:00   2017-01-11 00:00:00   2016-09-30 00:00:00   2016-10-27 00:00:00   2019-07-31 00:00:00
stmnt_type   10005   10006   10001   10001   10001   10005   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10006   10002   10001   10001   10001   10002   10001   10001   10005   10005   10001   10003   10003   10006   10005   10005
stmnt_status   11003   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   11003   11001   11003
session_id   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2015   2017   2015   2015   2015   2015
user_id   CPON   LPALMER   CREYNOLDS   DWALKER   MDIGRAZIA   MDIGRAZIA   CREYNOLDS   MDIGRAZIA   CREYNOLDS   CREYNOLDS   MDIGRAZIA   SMCCONNAN   KBANH   RGEREMIA   CREYNOLDS   RGEREMIA   RGEREMIA   RGEREMIA   RGEREMIA   TRAMON   RGEREMIA   RGEREMIA   RGEREMIA   SARRIAGA   CAFILER   KBANH   HSTOVALL   SARRIAGA   SMCCONNAN   CPON   TRAMON   CPON   MPACHECO   HSTOVALL   AROBERTS
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
fine_audit   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11003   11003   11001   11003   11003   11001   11003   11003   11003   11003   11003   11003
rpt_start   None   None   2015-12-22 00:00:00   2016-03-16 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2016-03-29 00:00:00   2016-01-01 00:00:00   2016-04-12 00:00:00   2016-05-10 00:00:00   2016-01-01 00:00:00   2016-04-01 00:00:00   2016-06-10 00:00:00   2016-06-22 00:00:00   2016-04-26 00:00:00   2016-06-08 00:00:00   2016-07-06 00:00:00   2016-07-06 00:00:00   2016-07-06 00:00:00   None   2016-08-02 00:00:00   2016-08-02 00:00:00   2016-05-24 00:00:00   2016-07-01 00:00:00   2016-04-01 00:00:00   2016-10-03 00:00:00   2016-09-25 00:00:00   2016-07-01 00:00:00   2016-04-01 00:00:00   2016-10-23 00:00:00   None   2016-10-23 00:00:00   2016-04-01 00:00:00   2016-09-25 00:00:00   2015-01-01 00:00:00
rpt_end   None   None   2015-12-22 00:00:00   2016-03-16 00:00:00   2015-12-31 00:00:00   2015-12-31 00:00:00   2016-03-29 00:00:00   2016-03-31 00:00:00   2016-04-12 00:00:00   2016-05-10 00:00:00   2016-03-31 00:00:00   2016-06-30 00:00:00   2016-06-10 00:00:00   2016-06-22 00:00:00   2016-04-26 00:00:00   2016-06-08 00:00:00   2016-07-06 00:00:00   2016-07-06 00:00:00   2016-07-06 00:00:00   None   2016-08-02 00:00:00   2016-08-02 00:00:00   2016-05-24 00:00:00   2016-09-24 00:00:00   2016-06-30 00:00:00   2016-10-03 00:00:00   2016-10-22 00:00:00   2016-09-24 00:00:00   2016-06-30 00:00:00   2016-12-31 00:00:00   None   2016-12-31 00:00:00   2016-06-30 00:00:00   2016-10-22 00:00:00   2016-12-31 00:00:00
rpt_date   None   None   2015-12-22 00:00:00   2016-03-16 00:00:00   2016-02-01 00:00:00   None   2016-03-29 00:00:00   2016-05-02 00:00:00   2016-04-12 00:00:00   2016-05-10 00:00:00   None   2016-08-01 00:00:00   2016-06-10 00:00:00   2016-06-22 00:00:00   2016-04-26 00:00:00   2016-06-08 00:00:00   2016-07-06 00:00:00   2016-07-06 00:00:00   2016-07-06 00:00:00   None   2016-08-02 00:00:00   2016-08-02 00:00:00   2016-05-24 00:00:00   2016-09-29 00:00:00   2016-09-29 00:00:00   2016-10-03 00:00:00   2016-10-27 00:00:00   None   None   2017-01-10 00:00:00   None   None   None   None   None
filing_type   None   None   22001   22001   22001   None   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   None   None   22001   None   None   None   None   None
Table: filer_to_filer_type
filer_id   1381488   1381488   1381488
filer_type   16   16   16
active   T   Y   Y
race   0   0   0
session_id   2015   2015   2015
category   0   0   0
category_type   40502   40502   40502
sub_category   40101   40101   40101
effect_dt   2016-12-31 00:00:00   2015-12-24 00:00:00   2015-12-07 00:00:00
sub_category_type   0   0   0
election_type   0   0   0
sub_category_a   S   S   S
nyq_dt   2015-12-16 00:00:00   2015-12-16 00:00:00   None
party_cd   0   0   0
county_cd   18026   18026   18026
district_cd   0   0   0
Table: filer_xref
filer_id   1381488
xref_id   1381488
effect_dt   2015-12-08 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1381488   1381488
filer_id   1381488   1381488
filer_type   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE
status   TERMINATED   TERMINATED
effect_dt   2016-12-31 00:00:00   2016-12-31 00:00:00
naml   CALIFORNIANS FOR HOSPITAL ACCOUNTABILITY AND QUALITY CARE - NO ON 52, SPONSORED BY SERVICE EMPLOYEES INTERNATIONAL UNION - UNITED HEALTHCARE WORKERS WEST   CALIFORNIANS FOR HOSPITAL ACCOUNTABILITY AND QUALITY CARE, SPONSORED BY SERVICE EMPLOYEES INTERNATIONAL UNION - UNITED HEALTHCARE WORKERS WEST
namf   None   None
namt   None   None
nams   None   None
adr1   None   None
adr2   None   None
city   LOS ANGELES   LOS ANGELES
st   CA   CA
zip4   90017   90017
phon   2134526565   2134526565
fax   2134526575   2134526575
email   [email protected]   [email protected]
Table: filers
filer_id   1381488
Table: received_filings
filer_id   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488   1381488
filing_file_name   2045709_0.cal   2050730_0.cal   2053707_0.cal   2053708_0.cal   2053709_0.cal   2051041_0.cal   2001676_0.cal   99191.cal   2084579_0.cal   2024352_0.cal   2027796_0.cal   2021128_0.cal   2065223_0.cal   2052300_1.cal   2041476_0.cal   2032879_0.cal   2052300_0.cal
received_date   2016-05-24 00:00:00   2016-06-08 00:00:00   2016-07-06 00:00:00   2016-07-06 00:00:00   2016-07-06 00:00:00   2016-06-10 00:00:00   2015-12-22 00:00:00   2016-02-01 00:00:00   2016-10-03 00:00:00   2016-03-29 00:00:00   2016-04-12 00:00:00   2016-03-16 00:00:00   2016-08-02 00:00:00   2016-08-02 00:00:00   2016-05-10 00:00:00   2016-04-26 00:00:00   2016-06-22 00:00:00
filing_directory   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal
filing_id   2045709   2050730   2053707   2053708   2053709   2051041   2001676   None   2084579   2024352   2027796   2021128   2065223   2052300   2041476   2032879   2052300
form_id   F497   F497   F497   F497   F497   F497   F497   None   F497   F497   F497   F497   F497   F497   F497   F497   F497
receive_comment   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing passed validation, but failed DB constraints   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted