Table: lpay
filing_id |
| 2746729 |
| 2746729 |
| 2746729 |
| 2746729 |
| 2746729 |
| 2746729 |
| 2746729 |
| 2746729 |
| 2746729 |
| 2746729 |
| 2746729 |
| 2746729 |
| 2746729 |
| 2746729 |
amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
rec_type |
| LPAY |
| LPAY |
| LPAY |
| LPAY |
| LPAY |
| LPAY |
| LPAY |
| LPAY |
| LPAY |
| LPAY |
| LPAY |
| LPAY |
| LPAY |
| LPAY |
form_type |
| F625P2 |
| F625P2 |
| F625P2 |
| F625P2 |
| F625P2 |
| F625P2 |
| F625P2 |
| F625P2 |
| F625P2 |
| F625P2 |
| F625P2 |
| F625P2 |
| F625P2 |
| F625P2 |
tran_id |
| 8197 |
| 8207 |
| 8198 |
| 8199 |
| 8196 |
| 8200 |
| 8201 |
| 8193 |
| 8195 |
| 8202 |
| 8206 |
| 8203 |
| 8204 |
| 8205 |
entity_cd |
| FRM |
| FRM |
| FRM |
| FRM |
| FRM |
| FRM |
| FRM |
| FRM |
| FRM |
| FRM |
| FRM |
| FRM |
| FRM |
| LEM |
emplr_naml |
| CLEAR ADVOCACY, LLC (ON BEHALF OF ASSOCIATED CA SELF INSURED BUSINESSES) |
| CLEAR ADVOCACY, LLC (ON BEHALF OF CALIFORNIA ASSOCIATION OF MEDICAL PRODUCT SUPPLIERS) |
| CLEAR ADVOCACY, LLC (ON BEHALF OF CALIFORNIA BROADCASTERS ASSOCIATION) |
| CLEAR ADVOCACY, LLC (ON BEHALF OF CALIFORNIA SOCIETY OF ALLERGY, ASTHMA AND IMMUNOLOGY (CSAII) ) |
| CLEAR ADVOCACY, LLC (ON BEHALF OF MAXIM HEALTHCARE SERVICES, INC) |
| CLEAR ADVOCACY, LLC (ON BEHALF OF MISSION HEALTHCARE) |
| CLEAR ADVOCACY, LLC (ON BEHALF OF NATIONAL CONFECTIONERS ASSOCIATION) |
| CLEAR ADVOCACY, LLC (ON BEHALF OF NATIONAL FEDERATION OF INDEPENDENT BUSINESS) |
| CLEAR ADVOCACY, LLC (ON BEHALF OF PEDIATRIC DAY HEALTH CARE COALITION) |
| CLEAR ADVOCACY, LLC (ON BEHALF OF PET INDUSTRY JOINT ADVISORY COUNCIL) |
| CLEAR ADVOCACY, LLC (ON BEHALF OF ALLEGIS, REDWOOD, MAXIM PUBLIC AFFAIRS, LLC) |
| CLEAR ADVOCACY, LLC (ON BEHALF OF SANOFI US SERVICES, INC) |
| CLEAR ADVOCACY, LLC (ON BEHALF OF U.S. RENAL CARE) |
| CVS HEALTH |
emplr_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
emplr_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
emplr_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
emplr_city |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
| WASHINGTON |
emplr_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| DC |
emplr_zip4 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 20004 |
emplr_phon |
| (916) 479-7400 |
| (916) 479-7400 |
| (916) 479-7400 |
| (916) 479-7400 |
| (916) 479-7400 |
| (916) 479-7400 |
| (916) 479-7400 |
| (916) 479-7400 |
| (916) 479-7400 |
| (916) 479-7400 |
| (916) 479-7400 |
| (916) 479-7400 |
| (916) 479-7400 |
| (202) 772-3500 |
lby_actvty |
| AB 1751; SB 1127 |
| NONE |
| NONE |
| AB 2098, 2236, 2640 |
| CA BUDGET RE: PRIVATE DUTY NURSING (PDN) RATE INCREASE 2023-2024 |
| AB 2673 |
| AB 2026; SB 54 |
| AB 257, 1041, 1601, 1632, 1751, 1949, 1951, 2164, 2183, 2188, 2777; SB 1044, 1127, 1149 |
| NONE |
| AB 2380; SB 1029 |
| SB 1349 |
| AB 1880, 1951, 2382; SB 912, 2380 |
| Legislature re: Dialysis wages, Ballot Measure-Prop 29 |
| AB 852, 1700, 1880, 2029, 2194, 2265, 2352; SB 250, 301, 473, 838, 853, 912, 1033, 1473 |
fees_amt |
| 15000 |
| 0 |
| 3000 |
| 1875 |
| 20000 |
| 11250 |
| 3750 |
| 18000 |
| 6500 |
| 16000 |
| 15000 |
| 13333 |
| 22500 |
| 31250 |
reimb_amt |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 688 |
advan_amt |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
advan_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
per_total |
| 15000 |
| 0 |
| 3000 |
| 1875 |
| 20000 |
| 11250 |
| 3750 |
| 18000 |
| 6500 |
| 16000 |
| 15000 |
| 13333 |
| 22500 |
| 31938 |
cum_total |
| 110000 |
| 10000 |
| 21000 |
| 11250 |
| 105000 |
| 57500 |
| 27083 |
| 126178 |
| 55250 |
| 84000 |
| 85000 |
| 133333 |
| 157500 |
| 242486 |
memo_code |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
memo_refno |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
bakref_tid |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
emplr_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|