| filing_id | 2426978 | 2471333 | 2442991 | 2440779 | 2463826 | 2471333 | 2440779 | 2457829 | 2449443 | 2487604 | 2471333 | 2449443 | 2482852 | 2502868 | 2512728 | 2555576 | 2531530 | 2531530 | 2580987 | 2553907 | 2531530 | 2535519 | 2630717 | 2644410 | 2607154 | 2629534 | 2608395 | 2592239 | 2618705 | 2603137 | 2644410 | 2644410 | 2594327 | 2662400 | 2609328 | 2603137 | 2648949 | 2656075 | 2624611 | 2656075 | 2653789 | 2632377 | 2634509 | 2662400 | 2677560 | 2708353 | 2696255 | 2677560 | ||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | CVR | ||||||||||||||||||||||||||||||||||||||||||||||||
| form_type | F497 | F460 | F460 | F497 | F497 | F460 | F497 | F497 | F497 | F460 | F460 | F497 | F497 | F497 | F497 | F497 | F460 | F460 | F460 | F460 | F460 | F497 | F497 | F460 | F497 | F497 | F497 | F497 | F497 | F460 | F460 | F460 | F497 | F497 | F497 | F460 | F497 | F497 | F460 | F497 | F497 | F497 | F497 | F497 | F460 | F460 | F497 | F460 | ||||||||||||||||||||||||||||||||||||||||||||||||
| filer_id | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | ||||||||||||||||||||||||||||||||||||||||||||||||
| entity_cd | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | None | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | BMC | ||||||||||||||||||||||||||||||||||||||||||||||||
| filer_naml | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | ||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | 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 | 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 | None | ||||||||||||||||||||||||||||||||||||||||||||||||
| report_num | 000 | 001 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 002 | 001 | 000 | 000 | 000 | 000 | 002 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 001 | 002 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 001 | ||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_date | 2019-12-27 00:00:00 | 2020-05-05 00:00:00 | 2020-01-14 00:00:00 | 2020-02-04 00:00:00 | 2020-03-20 00:00:00 | 2020-04-28 00:00:00 | 2020-01-30 00:00:00 | 2020-02-25 00:00:00 | 2020-02-10 00:00:00 | 2020-07-31 00:00:00 | 2020-07-30 00:00:00 | 2020-05-05 00:00:00 | 2020-07-29 00:00:00 | 2020-09-18 00:00:00 | 2020-10-09 00:00:00 | 2021-02-03 00:00:00 | 2021-01-31 00:00:00 | 2020-11-30 00:00:00 | 2021-04-30 00:00:00 | 2021-01-31 00:00:00 | 2020-10-27 00:00:00 | 2020-11-20 00:00:00 | 2021-12-10 00:00:00 | 2022-01-31 00:00:00 | 2021-08-17 00:00:00 | 2021-11-24 00:00:00 | 2021-08-24 00:00:00 | 2021-07-09 00:00:00 | 2021-10-24 00:00:00 | 2021-11-01 00:00:00 | 2022-02-24 00:00:00 | 2022-03-15 00:00:00 | 2021-07-19 00:00:00 | 2022-04-01 00:00:00 | 2021-08-29 00:00:00 | 2021-07-31 00:00:00 | 2022-02-10 00:00:00 | 2022-03-09 00:00:00 | 2021-11-01 00:00:00 | 2022-04-13 00:00:00 | 2022-02-28 00:00:00 | 2021-12-29 00:00:00 | 2022-01-13 00:00:00 | 2022-05-11 00:00:00 | 2022-05-02 00:00:00 | 2022-08-01 00:00:00 | 2022-07-01 00:00:00 | 2022-06-10 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| stmt_type | None | QT | SA | None | None | QT | None | None | None | SA | QT | None | None | None | None | None | SA | QT | QT | SA | QT | None | None | SA | None | None | None | None | None | SA | SA | SA | None | None | None | SA | None | None | QT | None | None | None | None | None | QT | TS | None | QT | ||||||||||||||||||||||||||||||||||||||||||||||||
| late_rptno | LCR # 1432 | None | None | LCR #1538A | LCR # 1679 | None | LCR # 1538 | LCR # 1625 | LCR # 1571 | None | None | LCR #1571A | LCR # 1717 | LCR # 1923 | LCR # 2049 | 5 | None | None | None | None | None | LCR # 2329 | 88 | None | 56 | 84 | 60 | 37 | 80 | None | None | None | 40 | 187 | 65 | None | 118 | 133 | None | 133A | 126 | 99 | 107 | 187A | None | None | 456 | None | ||||||||||||||||||||||||||||||||||||||||||||||||
| from_date | None | 2020-01-01 00:00:00 | 2019-01-01 00:00:00 | None | None | 2020-01-01 00:00:00 | None | None | None | 2020-04-01 00:00:00 | 2020-01-01 00:00:00 | None | None | None | None | None | 2020-07-01 00:00:00 | 2020-07-01 00:00:00 | 2021-01-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | None | None | 2021-10-01 00:00:00 | None | None | None | None | None | 2021-04-01 00:00:00 | 2021-10-01 00:00:00 | 2021-10-01 00:00:00 | None | None | None | 2021-04-01 00:00:00 | None | None | 2021-07-01 00:00:00 | None | None | None | None | None | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | None | 2022-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| thru_date | None | 2020-03-31 00:00:00 | 2019-12-31 00:00:00 | None | None | 2020-03-31 00:00:00 | None | None | None | 2020-06-30 00:00:00 | 2020-03-31 00:00:00 | None | None | None | None | None | 2020-09-30 00:00:00 | 2020-09-30 00:00:00 | 2021-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | None | None | 2021-12-31 00:00:00 | None | None | None | None | None | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | None | None | None | 2021-06-30 00:00:00 | None | None | 2021-09-30 00:00:00 | None | None | None | None | None | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | None | 2022-03-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| elect_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 | 2022-11-08 00:00:00 | None | None | None | None | None | 2022-11-08 00:00:00 | None | None | None | 2022-11-08 00:00:00 | None | None | 2022-11-08 00:00:00 | None | ||||||||||||||||||||||||||||||||||||||||||||||||
| filer_city | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | ||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||
| filer_zip4 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | ||||||||||||||||||||||||||||||||||||||||||||||||
| filer_phon | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | ||||||||||||||||||||||||||||||||||||||||||||||||
| filer_fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||
| file_email | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [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 | None | 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 | 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 | None | ||||||||||||||||||||||||||||||||||||||||||||||||
| tres_naml | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | None | LUCAS | LUCAS | LUCAS | LUCAS | LUCAS | None | LUCAS | LUCAS | LUCAS | None | LUCAS | LUCAS | None | LUCAS | ||||||||||||||||||||||||||||||||||||||||||||||||
| tres_namf | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | None | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | None | STEVEN S. | STEVEN S. | STEVEN S. | None | STEVEN S. | STEVEN S. | None | STEVEN S. | ||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | None | None | 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 | None | None | 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 | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | None | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | None | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | None | SAN RAFAEL | SAN RAFAEL | None | SAN RAFAEL | ||||||||||||||||||||||||||||||||||||||||||||||||
| tres_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 | None | CA | CA | CA | CA | CA | None | CA | CA | CA | None | CA | CA | None | CA | ||||||||||||||||||||||||||||||||||||||||||||||||
| tres_zip4 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | 94901 | None | 94901 | 94901 | 94901 | 94901 | 94901 | None | 94901 | 94901 | 94901 | None | 94901 | 94901 | None | 94901 | ||||||||||||||||||||||||||||||||||||||||||||||||
| tres_phon | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | None | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | None | 415-389-6800 | 415-389-6800 | 415-389-6800 | None | 415-389-6800 | 415-389-6800 | None | 415-389-6800 | ||||||||||||||||||||||||||||||||||||||||||||||||
| tres_fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | None | None | 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 | B | None | None | B | None | None | None | B | B | None | None | None | None | None | B | B | B | B | B | None | None | B | None | None | None | None | None | B | B | B | None | None | None | B | None | None | B | None | None | None | None | None | B | B | None | B | ||||||||||||||||||||||||||||||||||||||||||||||||
| control_yn | None | Y | Y | None | None | Y | None | None | None | Y | Y | None | None | None | None | None | Y | Y | Y | Y | Y | None | None | Y | None | None | None | None | None | Y | Y | Y | None | None | None | Y | None | None | Y | None | None | None | None | None | Y | Y | None | Y | ||||||||||||||||||||||||||||||||||||||||||||||||
| sponsor_yn | None | N | N | None | None | N | None | None | None | N | N | None | None | None | None | None | N | N | N | N | N | None | None | N | None | None | None | None | None | N | N | N | None | None | None | N | None | None | N | None | None | None | None | None | N | N | None | N | ||||||||||||||||||||||||||||||||||||||||||||||||
| primfrm_yn | None | Y | Y | None | None | Y | None | None | None | Y | Y | None | None | None | None | None | Y | Y | Y | Y | Y | None | None | Y | None | None | None | None | None | Y | Y | Y | None | None | None | Y | None | None | Y | None | None | None | None | None | Y | Y | None | 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 | None | None | 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 | AMEND TO REVISE AMOUNT OF NON-MONETARY CONTRIBUTION | None | AMEND TO PROPERLY DISCLOSE SOURCE OF CONTRIBUTION | None | None | None | None | None | None | AMEND TO INCLUDE ADDITIONAL SUBVENDORS | AMEND TO DISCLOSURE ACTUAL AMOUNT OF INKIND CONTRIBUTION | None | None | None | None | AMEND TO INCLUDE PRIMARILY FORMED SECTION - PAPER VERSION ONLY | AMEND TO REVISE DUE DATES ON LOANS RECIEVED | None | None | None | None | None | None | None | None | None | None | None | AMEND TO ADD PREVIOUSLY UNDISCLOSED ACCRUED EXPENSE | AMEND TO DISCLOSE ADDITIONAL SUBVENDORS & ACCRUED EXPENSE | AMEND TO DISCLOSE ADDITIONAL ACCRUED EXPENSE | None | None | None | None | None | None | None | AMEND TO REVISE AMOUNT OF NON-MONETARY CONTRIBUTION | None | None | None | AMEND TO REVISE AMOUNT OF INKIND CONTRIBUTION | None | None | None | AMEND TO INCLUDE ADDITIONAL ACCURED EXPESNE AND SUBVENDOR INFORMATION | ||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | None | None | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | None | None | None | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | None | None | None | None | None | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | None | None | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | None | None | None | None | None | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | None | None | None | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | None | None | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | None | None | None | None | None | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | None | (19-0018A1) ADJUSTS LIMITATIONS IN MEDICAL NEGLIGENCE CASES. INITIATIVE STATUTE. | ||||||||||||||||||||||||||||||||||||||||||||||||
| bal_num | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||
| bal_juris | None | STATEWIDE - NOVEMBER 2020 | STATEWIDE - NOVEMBER 2020 | None | None | STATEWIDE - NOVEMBER 2020 | None | None | None | STATEWIDE - NOVEMBER 2022 | STATEWIDE - NOVEMBER 2022 | None | None | None | None | None | STATEWIDE - NOVEMBER 2022 | STATEWIDE - NOVEMBER 2022 | STATEWIDE - NOVEMBER 2022 | STATEWIDE - NOVEMBER 2022 | STATEWIDE - NOVEMBER 2022 | None | None | STATEWIDE - NOVEMBER 2022 | None | None | None | None | None | STATEWIDE - NOVEMBER 2022 | STATEWIDE - NOVEMBER 2022 | STATEWIDE - NOVEMBER 2022 | None | None | None | STATEWIDE - NOVEMBER 2022 | None | None | STATEWIDE - NOVEMBER 2022 | None | None | None | None | None | STATEWIDE - NOVEMBER 2022 | STATEWIDE - NOVEMBER 2022 | None | STATEWIDE - NOVEMBER 2022 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | O | O | None | None | O | None | None | None | O | O | None | None | None | None | None | O | O | O | O | O | None | None | O | None | None | None | None | None | O | O | O | None | None | None | O | None | None | O | None | None | None | None | None | O | O | None | O | ||||||||||||||||||||||||||||||||||||||||||||||||
| employer | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | 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 | None | None | 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 | None | None | 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 | None | 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_id | 2425961 | 2425961 | 2425961 | 2425961 | ||||
|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 2 | 1 | 3 | ||||
| rec_type | CVR | CVR | CVR | CVR | ||||
| form_type | F410 | F410 | F410 | F410 | ||||
| filer_id | 1423480 | 1423480 | 1423480 | 1423480 | ||||
| entity_cd | RCP | RCP | RCP | RCP | ||||
| filer_naml | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | ||||
| filer_namf | None | None | None | None | ||||
| filer_namt | None | None | None | None | ||||
| filer_nams | None | None | None | None | ||||
| report_num | 000 | 002 | 001 | 003 | ||||
| rpt_date | 2019-12-20 00:00:00 | 2020-07-06 00:00:00 | 2020-03-17 00:00:00 | 2022-08-01 00:00:00 | ||||
| qual_cb | X | X | X | X | ||||
| qualfy_dt | 2019-12-18 00:00:00 | 2019-12-18 00:00:00 | 2019-12-18 00:00:00 | 2019-12-18 00:00:00 | ||||
| term_date | None | None | None | 2022-06-30 00:00:00 | ||||
| city | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | ||||
| st | CA | CA | CA | CA | ||||
| zip4 | 94901 | 94901 | 94901 | 94901 | ||||
| phone | 415 389-6800 | 415 389-6800 | 415 389-6800 | 415 389-6800 | ||||
| county_res | MARIN | MARIN | MARIN | MARIN | ||||
| county_act | STATEWIDE | STATEWIDE | STATEWIDE | STATEWIDE | ||||
| mail_city | None | None | None | None | ||||
| mail_st | None | None | None | None | ||||
| mail_zip4 | None | None | None | None | ||||
| cmte_fax | None | None | None | None | ||||
| cmte_email | [email protected] | [email protected] | [email protected] | [email protected] | ||||
| tres_naml | LUCAS | LUCAS | LUCAS | LUCAS | ||||
| tres_namf | STEVEN S. | STEVEN S. | STEVEN S. | STEVEN S. | ||||
| tres_namt | None | None | None | None | ||||
| tres_nams | None | None | None | None | ||||
| tres_city | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | SAN RAFAEL | ||||
| tres_st | CA | CA | CA | CA | ||||
| tres_zip4 | 94901 | 94901 | 94901 | 94901 | ||||
| tres_phon | 415-389-6800 | 415-389-6800 | 415-389-6800 | 415-389-6800 | ||||
| actvty_lvl | None | None | None | None | ||||
| com82013yn | None | None | None | None | ||||
| com82013nm | None | None | None | None | ||||
| com82013id | None | None | None | None | ||||
| control_cb | None | None | None | None | ||||
| bank_nam | BANK OF MARIN | BANK OF MARIN | BANK OF MARIN | BANK OF MARIN | ||||
| bank_adr1 | 504 TAMALPAIS DRIVE | 504 TAMALPAIS DRIVE | 504 TAMALPAIS DRIVE | 504 TAMALPAIS DRIVE | ||||
| bank_adr2 | None | None | None | None | ||||
| bank_city | CORTE MADERA | CORTE MADERA | CORTE MADERA | CORTE MADERA | ||||
| bank_st | CA | CA | CA | CA | ||||
| bank_zip4 | 94925 | 94925 | 94925 | 94925 | ||||
| bank_phon | 415-927-8905 | 415-927-8905 | 415-927-8905 | 415-927-8905 | ||||
| acct_opendt | None | None | None | None | ||||
| surplusdsp | None | None | None | None | ||||
| primfc_cb | X | X | X | X | ||||
| genpurp_cb | None | None | None | None | ||||
| gpc_descr | None | None | None | None | ||||
| sponsor_cb | X | X | X | X | ||||
| brdbase_cb | None | None | None | None | ||||
| smcont_qualdt | None | None | None | None |
| filer_id | 1423480 | |
|---|---|---|
| adrid | 2488375 | |
| effect_dt | 2019-12-19 00:00:00 | |
| add_type | 7051 | |
| session_id | 2019 |
| filer_id | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 2492447 | 2531530 | 2425961 | 2555576 | 2457829 | 2553907 | 2532675 | 2448943 | 2531530 | 2440779 | 2535519 | 2472298 | 2425961 | 2425961 | 2442991 | 2582368 | 2580987 | 2425655 | 2471333 | 2502868 | 2609328 | 2449443 | 2472298 | 2449443 | 2463826 | 2426978 | 2512728 | 2471333 | 2440779 | 2473648 | 2623921 | 2472298 | 2572811 | 2677560 | 2644410 | 2662400 | 2532675 | 2478074 | 2603137 | 2677560 | 2594327 | 2696255 | 2482852 | 2487604 | 2471333 | 2624611 | 2634509 | 2656075 | 2632377 | 2708353 | 2425961 | 2627693 | 2630717 | 2531530 | 2686533 | 2662400 | 2592239 | 2644410 | 2629534 | 2603137 | 2652163 | 2623921 | 2709583 | 2644410 | 2618705 | 2686533 | 2652163 | 2532675 | 2653789 | 2652163 | 2608395 | 2607154 | 2648949 | 2656075 | 2733552 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| period_id | None | 243 | 240 | 245 | 241 | 244 | None | None | 243 | 241 | 244 | None | 243 | 241 | 237 | None | 245 | None | 241 | 243 | 247 | 241 | None | 242 | 241 | 240 | 244 | 241 | 241 | None | None | None | None | 249 | 248 | 250 | None | None | 246 | 249 | 247 | 251 | 243 | 242 | 241 | 247 | 249 | 250 | 248 | 250 | 251 | None | 248 | 243 | None | 250 | 247 | 248 | 248 | 246 | None | None | None | 248 | 248 | None | None | None | 249 | None | 247 | 247 | 249 | 249 | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| form_id | F460 | F460 | F410 | F497 | F497 | F460 | F460 | F460 | F460 | F497 | F497 | F460 | F410 | F410 | F460 | F460 | F460 | F410 | F460 | F497 | F497 | F497 | F460 | F497 | F497 | F497 | F497 | F460 | F497 | F410 | F460 | F460 | F460 | F460 | F460 | F497 | F460 | F410 | F460 | F460 | F497 | F497 | F497 | F460 | F460 | F460 | F497 | F497 | F497 | F460 | F410 | F460 | F497 | F460 | F460 | F497 | F497 | F460 | F497 | F460 | F460 | F460 | F410 | F460 | F497 | F460 | F460 | F460 | F497 | F460 | F497 | F497 | F497 | F497 | F460 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_sequence | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 2 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_date | 2020-07-31 00:00:00 | 2021-02-01 00:00:00 | 2019-12-20 00:00:00 | 2021-02-03 00:00:00 | 2020-02-25 00:00:00 | 2021-02-01 00:00:00 | 2020-11-02 00:00:00 | 2020-01-31 00:00:00 | 2020-11-02 00:00:00 | 2020-02-04 00:00:00 | 2020-11-20 00:00:00 | 2020-05-01 00:00:00 | 2020-07-06 00:00:00 | 2020-03-18 00:00:00 | 2020-01-31 00:00:00 | 2021-04-30 00:00:00 | 2021-04-30 00:00:00 | 2019-12-19 00:00:00 | 2020-04-30 00:00:00 | 2020-09-18 00:00:00 | 2021-08-30 00:00:00 | 2020-02-10 00:00:00 | 2020-05-07 00:00:00 | 2020-05-05 00:00:00 | 2020-03-20 00:00:00 | 2019-12-27 00:00:00 | 2020-10-09 00:00:00 | 2020-05-06 00:00:00 | 2020-01-30 00:00:00 | 2020-03-18 00:00:00 | 2021-08-02 00:00:00 | 2020-08-03 00:00:00 | 2021-02-01 00:00:00 | 2022-05-02 00:00:00 | 2022-03-17 00:00:00 | 2022-04-01 00:00:00 | 2021-02-02 00:00:00 | 2020-07-07 00:00:00 | 2021-08-02 00:00:00 | 2022-06-10 00:00:00 | 2021-07-19 00:00:00 | 2022-07-01 00:00:00 | 2020-07-29 00:00:00 | 2020-07-31 00:00:00 | 2020-07-31 00:00:00 | 2021-11-01 00:00:00 | 2022-01-13 00:00:00 | 2022-04-13 00:00:00 | 2021-12-30 00:00:00 | 2022-08-01 00:00:00 | 2022-08-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-10 00:00:00 | 2020-11-30 00:00:00 | 2022-05-02 00:00:00 | 2022-05-11 00:00:00 | 2021-07-09 00:00:00 | 2022-01-31 00:00:00 | 2021-11-24 00:00:00 | 2021-11-01 00:00:00 | 2022-01-31 00:00:00 | 2021-11-02 00:00:00 | 2022-08-02 00:00:00 | 2022-02-28 00:00:00 | 2021-10-25 00:00:00 | 2022-06-13 00:00:00 | 2022-03-01 00:00:00 | 2020-12-01 00:00:00 | 2022-02-28 00:00:00 | 2022-03-18 00:00:00 | 2021-08-24 00:00:00 | 2021-08-17 00:00:00 | 2022-02-10 00:00:00 | 2022-03-09 00:00:00 | 2022-08-02 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_type | 10005 | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10002 | 10001 | 10005 | 10002 | 10002 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10006 | 10002 | 10001 | 10001 | 10001 | 10002 | 10001 | 10006 | 10005 | 10006 | 10005 | 10001 | 10002 | 10001 | 10006 | 10006 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10002 | 10001 | 10001 | 10003 | 10005 | 10001 | 10002 | 10005 | 10002 | 10001 | 10001 | 10001 | 10002 | 10005 | 10006 | 10003 | 10002 | 10001 | 10006 | 10006 | 10006 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10005 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_status | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| session_id | 2019 | 2019 | 2019 | 2021 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2019 | 2019 | 2019 | 2021 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| user_id | KRUSSELL | CAFILER | CAFILER | CAFILER | RGEREMIA | CREYNOLDS | CPON | BCOLON | CPON | CAFILER | CAFILER | SUSHAKOV | TRAMON | CAFILER | BCOLON | BCOLON | BCOLON | JBEAUDOIN | SUSHAKOV | CAFILER | CAFILER | RGEREMIA | SUSHAKOV | CAFILER | RGEREMIA | RGEREMIA | RGEREMIA | CAFILER | CAFILER | BCOLON | LPHEAV | LFEDOROV | CREYNOLDS | SARRIAGA | CAFILER | CAFILER | JRAMOS | TRAMON | KRUSSELL | CAFILER | CAFILER | RGEREMIA | CAFILER | KRUSSELL | CAFILER | IMEDINA | CAFILER | CAFILER | RGEREMIA | CAFILER | JMENDOZA | IMEDINA | RGEREMIA | CAFILER | SARRIAGA | CAFILER | CAFILER | KRUSSELL | RGEREMIA | LPHEAV | KRUSSELL | JMAVES | JMENDOZA | CAFILER | RGEREMIA | JMAVES | JMAVES | JRAMOS | RGEREMIA | JMAVES | CAFILER | CAFILER | RGEREMIA | RGEREMIA | RGEREMIA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| fine_audit | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_start | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2019-12-20 00:00:00 | 2021-02-03 00:00:00 | 2020-02-25 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 2019-01-01 00:00:00 | 2020-07-01 00:00:00 | 2020-02-04 00:00:00 | 2020-11-20 00:00:00 | 2020-01-01 00:00:00 | 2020-07-06 00:00:00 | 2020-03-17 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | None | 2020-01-01 00:00:00 | 2020-09-18 00:00:00 | 2021-08-29 00:00:00 | 2020-02-10 00:00:00 | 2020-01-01 00:00:00 | 2020-05-05 00:00:00 | 2020-03-20 00:00:00 | 2019-12-27 00:00:00 | 2020-10-09 00:00:00 | 2020-01-01 00:00:00 | 2020-01-30 00:00:00 | None | 2021-04-01 00:00:00 | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00 | 2020-07-01 00:00:00 | None | 2021-04-01 00:00:00 | 2022-01-01 00:00:00 | 2021-07-19 00:00:00 | 2022-07-01 00:00:00 | 2020-07-29 00:00:00 | 2020-04-01 00:00:00 | 2020-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-01-13 00:00:00 | 2022-04-13 00:00:00 | 2021-12-29 00:00:00 | 2022-04-01 00:00:00 | 2022-08-01 00:00:00 | 2021-07-01 00:00:00 | 2021-12-10 00:00:00 | 2020-07-01 00:00:00 | 2022-01-01 00:00:00 | 2022-05-11 00:00:00 | 2021-07-09 00:00:00 | 2021-10-01 00:00:00 | 2021-11-24 00:00:00 | 2021-04-01 00:00:00 | 2021-10-01 00:00:00 | 2021-04-01 00:00:00 | None | 2021-10-01 00:00:00 | 2021-10-24 00:00:00 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 2020-07-01 00:00:00 | 2022-02-28 00:00:00 | 2021-10-01 00:00:00 | 2021-08-24 00:00:00 | 2021-08-17 00:00:00 | 2022-02-10 00:00:00 | 2022-03-09 00:00:00 | 2022-04-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_end | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2019-12-20 00:00:00 | 2021-02-03 00:00:00 | 2020-02-25 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-09-30 00:00:00 | 2020-02-04 00:00:00 | 2020-11-20 00:00:00 | 2020-03-31 00:00:00 | 2020-07-06 00:00:00 | 2020-03-17 00:00:00 | 2019-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-03-31 00:00:00 | None | 2020-03-31 00:00:00 | 2020-09-18 00:00:00 | 2021-08-29 00:00:00 | 2020-02-10 00:00:00 | 2020-03-31 00:00:00 | 2020-05-05 00:00:00 | 2020-03-20 00:00:00 | 2019-12-27 00:00:00 | 2020-10-09 00:00:00 | 2020-03-31 00:00:00 | 2020-01-30 00:00:00 | None | 2021-06-30 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2022-03-31 00:00:00 | 2021-12-31 00:00:00 | 2022-04-01 00:00:00 | 2020-09-30 00:00:00 | None | 2021-06-30 00:00:00 | 2022-03-31 00:00:00 | 2021-07-19 00:00:00 | 2022-07-01 00:00:00 | 2020-07-29 00:00:00 | 2020-06-30 00:00:00 | 2020-03-31 00:00:00 | 2021-09-30 00:00:00 | 2022-01-13 00:00:00 | 2022-04-13 00:00:00 | 2021-12-29 00:00:00 | 2022-06-30 00:00:00 | 2022-08-01 00:00:00 | 2021-09-30 00:00:00 | 2021-12-10 00:00:00 | 2020-09-30 00:00:00 | 2022-03-31 00:00:00 | 2022-05-11 00:00:00 | 2021-07-09 00:00:00 | 2021-12-31 00:00:00 | 2021-11-24 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | None | 2021-12-31 00:00:00 | 2021-10-24 00:00:00 | 2022-03-31 00:00:00 | 2021-12-31 00:00:00 | 2020-09-30 00:00:00 | 2022-02-28 00:00:00 | 2021-12-31 00:00:00 | 2021-08-24 00:00:00 | 2021-08-17 00:00:00 | 2022-02-10 00:00:00 | 2022-03-09 00:00:00 | 2022-06-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_date | None | 2021-01-31 00:00:00 | None | 2021-02-03 00:00:00 | 2020-02-25 00:00:00 | 2021-01-31 00:00:00 | None | None | 2020-10-27 00:00:00 | 2020-02-04 00:00:00 | 2020-11-20 00:00:00 | None | None | None | 2020-01-14 00:00:00 | None | 2021-04-30 00:00:00 | None | 2020-04-28 00:00:00 | 2020-09-18 00:00:00 | 2021-08-29 00:00:00 | 2020-02-10 00:00:00 | None | 2020-05-05 00:00:00 | 2020-03-20 00:00:00 | 2019-12-27 00:00:00 | 2020-10-09 00:00:00 | 2020-05-05 00:00:00 | 2020-01-30 00:00:00 | None | None | None | None | 2022-05-02 00:00:00 | 2022-03-15 00:00:00 | 2022-04-01 00:00:00 | None | None | 2021-07-31 00:00:00 | 2022-06-10 00:00:00 | 2021-07-19 00:00:00 | 2022-07-01 00:00:00 | 2020-07-29 00:00:00 | 2020-07-31 00:00:00 | 2020-07-30 00:00:00 | 2021-11-01 00:00:00 | 2022-01-13 00:00:00 | 2022-04-13 00:00:00 | 2021-12-29 00:00:00 | 2022-08-01 00:00:00 | None | None | 2021-12-10 00:00:00 | 2020-11-30 00:00:00 | None | 2022-05-11 00:00:00 | 2021-07-09 00:00:00 | 2022-01-31 00:00:00 | 2021-11-24 00:00:00 | 2021-11-01 00:00:00 | None | None | None | 2022-02-24 00:00:00 | 2021-10-24 00:00:00 | None | None | None | 2022-02-28 00:00:00 | None | 2021-08-24 00:00:00 | 2021-08-17 00:00:00 | 2022-02-10 00:00:00 | 2022-03-09 00:00:00 | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_type | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | 22001 | 22001 | None | None | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | None |
| filer_id | 1423480 | 1423480 | ||
|---|---|---|---|---|
| filer_type | 16 | 16 | ||
| active | Y | T | ||
| race | 0 | 0 | ||
| session_id | 2019 | 2021 | ||
| category | 0 | 0 | ||
| category_type | 40502 | 40502 | ||
| sub_category | 40101 | 40101 | ||
| effect_dt | 2019-12-19 00:00:00 | 2022-06-30 00:00:00 | ||
| sub_category_type | 0 | 0 | ||
| election_type | 0 | 0 | ||
| sub_category_a | S | S | ||
| nyq_dt | 2019-12-18 00:00:00 | 2019-12-18 00:00:00 | ||
| party_cd | 0 | 0 | ||
| county_cd | 18028 | 18028 | ||
| district_cd | 0 | 0 |
| filer_id | 1423480 | |
|---|---|---|
| xref_id | 1423480 | |
| effect_dt | 2019-12-19 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1423480 | 1423480 | ||
|---|---|---|---|---|
| filer_id | 1423480 | 1423480 | ||
| filer_type | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | ||
| status | TERMINATED | TERMINATED | ||
| effect_dt | 2022-06-30 00:00:00 | 2022-06-30 00:00:00 | ||
| naml | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE INSURERS AND PROVIDERS | CALIFORNIANS TO PROTECT PATIENTS AND CONTAIN HEALTH CARE COSTS, A COALITION OF PHYSICIANS, DENTISTS AND HEALTH CARE PROVIDERS | ||
| namf | None | None | ||
| namt | None | None | ||
| nams | None | None | ||
| adr1 | None | None | ||
| adr2 | None | None | ||
| city | SAN RAFAEL | SAN RAFAEL | ||
| st | CA | CA | ||
| zip4 | 94901 | 94901 | ||
| phon | 4153896800 | 4153896800 | ||
| fax | None | None | ||
| [email protected] | [email protected] |
| filer_id | 1423480 |
|---|
| filer_id | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | 1423480 | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_file_name | 2482852_0.cal | 2426978_0.cal | 2463826_0.cal | 2449443_0.cal | 2440779_0.cal | 2440779_1.cal | 2457829_0.cal | 2449443_1.cal | 447534.cal | 2656075_1.cal | 2535519_0.cal | 2634509_0.cal | 2629534_0.cal | 2618705_0.cal | 2608395_0.cal | 2648949_0.cal | 2653789_0.cal | 2502868_0.cal | 2592239_0.cal | 448468.cal | 2555576_0.cal | 2609328_0.cal | 2662400_0.cal | 2632377_0.cal | 2696255_0.cal | 2630717_0.cal | 2512728_0.cal | 2662400_1.cal | 2607154_0.cal | 381360.cal | 2594327_0.cal | 2656075_0.cal | ||||||||||||||||||||||||||||||||
| received_date | 2020-07-29 00:00:00 | 2019-12-27 00:00:00 | 2020-03-20 00:00:00 | 2020-02-10 00:00:00 | 2020-01-30 00:00:00 | 2020-02-04 00:00:00 | 2020-02-25 00:00:00 | 2020-05-05 00:00:00 | 2022-08-01 00:00:00 | 2022-04-13 00:00:00 | 2020-11-20 00:00:00 | 2022-01-13 00:00:00 | 2021-11-24 00:00:00 | 2021-10-25 00:00:00 | 2021-08-24 00:00:00 | 2022-02-10 00:00:00 | 2022-02-28 00:00:00 | 2020-09-18 00:00:00 | 2021-07-09 00:00:00 | 2022-08-01 00:00:00 | 2021-02-03 00:00:00 | 2021-08-30 00:00:00 | 2022-04-01 00:00:00 | 2021-12-30 00:00:00 | 2022-07-01 00:00:00 | 2021-12-10 00:00:00 | 2020-10-09 00:00:00 | 2022-05-11 00:00:00 | 2021-08-17 00:00:00 | 2022-03-09 00:00:00 | 2021-07-19 00:00:00 | 2022-03-09 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/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 | /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 | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||||||||||||||||||||||
| filing_id | 2482852 | 2426978 | 2463826 | 2449443 | 2440779 | 2440779 | 2457829 | 2449443 | None | 2656075 | 2535519 | 2634509 | 2629534 | 2618705 | 2608395 | 2648949 | 2653789 | 2502868 | 2592239 | None | 2555576 | 2609328 | 2662400 | 2632377 | 2696255 | 2630717 | 2512728 | 2662400 | 2607154 | None | 2594327 | 2656075 | ||||||||||||||||||||||||||||||||
| form_id | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | None | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | None | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | None | F497 | F497 | ||||||||||||||||||||||||||||||||
| receive_comment | Filing accepted | 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 | 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 | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted |