PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2272562&amendid=1
amend_id | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
entity_cd | PTN | PTN | EMP | EMP | PTN | PTN | EMP | EMP | ||||||||
entity_id | 1231506 | L25725 | 1363438 | 1392971 | 1231506 | L25725 | 1363438 | 1392971 | ||||||||
enty_namf | William | Delaney L. | Matthew | Jacob | William | Delaney L. | Matthew | Jacob | ||||||||
enty_naml | Gonzalez | Hunter | Klopfenstein | Moss | Gonzalez | Hunter | Klopfenstein | Moss | ||||||||
enty_nams | None | None | None | None | None | None | None | None | ||||||||
enty_namt | Mr. | Ms. | None | None | Mr. | Ms. | None | None | ||||||||
enty_title | Partner | Managing Partner | Legislative and Legal Advisor | Lobbyist | Partner | Managing Partner | Legislative and Legal Advisor | Lobbyist | ||||||||
filing_id | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | ||||||||
form_type | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | ||||||||
line_item | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | ||||||||
rec_type | CVR2 | CVR2 | CVR2 | CVR2 | CVR2 | CVR2 | CVR2 | CVR2 | ||||||||
tran_id | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 |
filing_id | 2272562 | 2272562 | ||
---|---|---|---|---|
amend_id | 0 | 1 | ||
rec_type | CVR | CVR | ||
form_type | F625 | F625 | ||
sender_id | 1334301 | 1334301 | ||
filer_id | 1334301 | 1334301 | ||
entity_cd | FRM | FRM | ||
filer_naml | CALIFORNIA ADVISORS, LLC | CALIFORNIA ADVISORS, LLC | ||
filer_namf | None | None | ||
filer_namt | None | None | ||
filer_nams | None | None | ||
report_num | 000 | 001 | ||
rpt_date | 2018-07-30 00:00:00 | 2020-01-28 00:00:00 | ||
from_date | 2018-04-01 00:00:00 | 2018-04-01 00:00:00 | ||
thru_date | 2018-06-30 00:00:00 | 2018-06-30 00:00:00 | ||
cum_beg_dt | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | ||
firm_id | 1334301 | 1334301 | ||
firm_name | None | None | ||
firm_city | SACRAMENTO | SACRAMENTO | ||
firm_st | CA | CA | ||
firm_zip4 | 95814 | 95814 | ||
firm_phon | 9169300796 | 9169300796 | ||
mail_city | None | None | ||
mail_st | None | None | ||
mail_zip4 | None | None | ||
mail_phon | None | None | ||
sig_date | 2018-07-30 00:00:00 | 2020-01-28 00:00:00 | ||
sig_loc | Sacramento, CA | Sacramento, CA | ||
sig_naml | Hunter | Hunter | ||
sig_namf | Delaney | Delaney | ||
sig_namt | None | None | ||
sig_nams | None | None | ||
prn_naml | Hunter | Hunter | ||
prn_namf | Delaney | Delaney | ||
prn_namt | None | None | ||
prn_nams | None | None | ||
sig_title | Managing Partner | Managing Partner | ||
nopart1_cb | None | None | ||
nopart2_cb | None | None | ||
part1_1_cb | X | X | ||
part1_2_cb | None | None | ||
ctrib_n_cb | X | X | ||
ctrib_y_cb | None | None | ||
lby_actvty | None | None | ||
lobby_n_cb | X | X | ||
lobby_y_cb | None | None | ||
major_naml | None | None | ||
major_namf | None | None | ||
major_namt | None | None | ||
major_nams | None | None | ||
rcpcmte_nm | None | None | ||
rcpcmte_id | None | None |
filing_id | 2272562 | |
---|---|---|
amend_id | 1 | |
line_item | 1 | |
rec_type | F690 | |
form_type | F625 | |
exec_date | 2018-07-30 00:00:00 | |
from_date | 2018-04-01 00:00:00 | |
thru_date | 2018-06-30 00:00:00 | |
chg_parts | II | |
chg_sects | None | |
amend_txt1 | Previously reported receipt of stock units in client company not actually received |
filer_id | 1334301 | 1334301 | ||
---|---|---|---|---|
filing_id | 2272562 | 2272562 | ||
period_id | 234 | 234 | ||
form_id | F625 | F625 | ||
filing_sequence | 1 | 0 | ||
filing_date | 2020-01-28 00:00:00 | 2018-07-30 00:00:00 | ||
stmnt_type | 10002 | 10001 | ||
stmnt_status | 11003 | 11001 | ||
session_id | 2017 | 2017 | ||
user_id | CAFILER | AGLADNEY | ||
special_audit | 11003 | 11003 | ||
fine_audit | 11003 | 11001 | ||
rpt_start | 2018-04-01 00:00:00 | 2018-04-01 00:00:00 | ||
rpt_end | 2018-06-30 00:00:00 | 2018-06-30 00:00:00 | ||
rpt_date | None | None | ||
filing_type | 22006 | 22006 |
filing_id | 2272562 | |
---|---|---|
filing_type | 22001 |
filing_id | 2272562 | 2272562 | ||
---|---|---|---|---|
amend_id | 0 | 1 | ||
rec_type | HDR | HDR | ||
ef_type | CAL | CAL | ||
state_cd | CA | CA | ||
cal_ver | 2.01 | 2.01 | ||
soft_name | CAL-ACCESS OBJECT MODEL | CAL-ACCESS OBJECT MODEL | ||
soft_ver | 1.00 | 1.00 | ||
hdrcomment | None | None |
filing_id | 2272562 | 2272562 | ||
---|---|---|---|---|
amend_id | 0 | 1 | ||
line_item | 1 | 1 | ||
rec_type | LOTH | LOTH | ||
form_type | F625P3B | F625P3B | ||
tran_id | 112 | 112 | ||
firm_name | The Onate Group | The Onate Group | ||
firm_city | Sacramento | Sacramento | ||
firm_st | CA | CA | ||
firm_zip4 | 95814 | 95814 | ||
firm_phon | 9164987736 | 9164987736 | ||
subj_naml | McGregor & Associates | McGregor & Associates | ||
subj_namf | None | None | ||
subj_namt | None | None | ||
subj_nams | None | None | ||
pmt_date | None | None | ||
amount | 0 | 0 | ||
cum_amt | 42000 | 42000 | ||
memo_code | None | None | ||
memo_refno | None | 112 |
filing_id | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
line_item | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rec_type | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | LPAY | 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 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | F625P2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tran_id | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
entity_cd | LEM | None | None | None | None | None | None | None | None | None | None | None | LEM | None | None | None | None | None | None | None | None | None | LEM | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | LEM | None | None | LEM | LEM | None | None | None | None | None | None | None | None | None | None | None | LEM | None | None | None | LEM | None | None | None | None | None | None | None | LEM | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | LEM | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | LEM | None | None | None | None | None | None | None | LEM | None | None | None | None | None | None | None | None | None | None | None | LEM | None | None | None | None | None | None | None | None | None | LEM | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | LEM | None | None | LEM | LEM | None | None | None | None | None | None | None | None | None | None | None | LEM | None | None | None | LEM | None | None | None | None | None | None | None | LEM | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
emplr_naml | Sacramento Municipal Utility District | Sacramento Republic FC | San Bernardino County Transportation Authority | San Diego County Water Authority | San Jose, City of | San Luis Coastal Unified School District | San Mateo, County of | Santa Clara Valley Transportation Authority | Sierra Lakes County Water District | Sierra Wellness, Inc. | Sightglass Management | Solar Energy Industry Association | South Coast Air Quality Management District | Southern California Public Power Authority | Standard Lithium Ltd. and its affiliate, California Lithium Ltd. Subsidiary | Sunverge Energy Inc. | The Coalition to Abolish Slavery and Trafficking (CAST) | The Quintana Cruz Company | Uber Technologies Inc. | Union of Concerned Scientists | Ventura County Transportation Commission | Viad Corp | Viejas Band of Kumeyaay Indians | VYFO Enterprises DBA: Nor Cal Vape | Wheels Financial Group, LLC d/b/a LoanMart | Susquehanna International Group, LLP | Bay Area Air Quality Management District | Gap, Inc. | Zillow Group | 710 Combinator Co. | Advanced Microgrid Solutions, Inc. | Alta Vista Innovation High School | Alta Vista Public Charter, Inc. | Amazon.com, Inc. | American Express | American Federation of Musicians Local 47 | American Power Group | Animal Kingdom Pet Shop | Aquahydrex | Association of Environmental Professionals | Association of Independent California Colleges and Universities (AICCU) | Assurance Learning Academy | Beach Cities Health District | Beachbody, LLC | Bloom Energy | BRT Holdings | CA CMA, Inc. | California Bail Agents Association | California Black Media | California Building Industry Association | California Business Properties Association | California Cannabis Couriers Association | California Cannabis Operators League | California Solar Energy Industries Association | Californians For Tobacco Harm Reduction | Center for Public Interest Law/Children's Advocacy Institute/University of San Diego | Center for Sustainable Energy | Chukchansi Economic Development Authority | Citadel Alternative Care | County of Santa Clara | Crescent View South, Inc. | Democracy Collaborative | Desert Sands Public Charter, Inc. | DJI Technology, LLC | Downtown Center Business Improvement District | DraftKings, Inc. | Dropbox, Inc | East Valley Water District | ecoLegacy | EDF Renewable Energy | Election Systems & Software, LLC | Encore Capital Group, Inc. | EnergySource, LLC | Facebook, Inc. | FanDuel, Inc. | First Point Management | First Solar | Fontem U.S. Inc., dba blue eCigs | Glamsquad, Inc. | Green Light District Holdings, Inc. | Greka Asphalt Corporation | Habematolel Pomo of Upper Lake | Herbalcure Corp. | Herbalife, Ltd. | Iconic Legacy Development and Promotion, LLC | INDUS Holding Company | Katasi, Inc. | KindManage, LLC | Law Enforcement Managers Association | Library System & Services | Long Beach Collective | MBLC Productions | McCallum Group, Inc. | McGregor and Associates | Mission View Public Charter, Inc. | National City Puppy, Inc. | Native American Land Conservancy | NLine Energy, Inc. | Oak Park Unified School District | PacifiCorp | Platinum Advisors, LLC | Property Casualty Insurers Association of America | Public Health Advocates | Ramona Band of Cahuilla | Sacramento Applied Business Dynamics | Sacramento Cannabis Delivery Association | Sacramento County | Herbalife, Ltd. | Iconic Legacy Development and Promotion, LLC | INDUS Holding Company | Katasi, Inc. | KindManage, LLC | Law Enforcement Managers Association | Library System & Services | Long Beach Collective | MBLC Productions | McCallum Group, Inc. | McGregor and Associates | Mission View Public Charter, Inc. | National City Puppy, Inc. | Native American Land Conservancy | NLine Energy, Inc. | Oak Park Unified School District | PacifiCorp | Platinum Advisors, LLC | Property Casualty Insurers Association of America | Public Health Advocates | Ramona Band of Cahuilla | Sacramento Applied Business Dynamics | Sacramento Cannabis Delivery Association | Sacramento County | Sacramento Municipal Utility District | Sacramento Republic FC | San Bernardino County Transportation Authority | San Diego County Water Authority | San Jose, City of | San Luis Coastal Unified School District | San Mateo, County of | Santa Clara Valley Transportation Authority | Sierra Lakes County Water District | Sierra Wellness, Inc. | Sightglass Management | Solar Energy Industry Association | South Coast Air Quality Management District | Southern California Public Power Authority | Standard Lithium Ltd. and its affiliate, California Lithium Ltd. Subsidiary | Sunverge Energy Inc. | The Coalition to Abolish Slavery and Trafficking (CAST) | The Quintana Cruz Company | Uber Technologies Inc. | Union of Concerned Scientists | Ventura County Transportation Commission | Viad Corp | Viejas Band of Kumeyaay Indians | VYFO Enterprises DBA: Nor Cal Vape | Wheels Financial Group, LLC d/b/a LoanMart | Susquehanna International Group, LLP | Bay Area Air Quality Management District | Gap, Inc. | Zillow Group | 710 Combinator Co. | Advanced Microgrid Solutions, Inc. | Alta Vista Innovation High School | Alta Vista Public Charter, Inc. | Amazon.com, Inc. | American Express | American Federation of Musicians Local 47 | American Power Group | Animal Kingdom Pet Shop | Aquahydrex | Association of Environmental Professionals | Association of Independent California Colleges and Universities (AICCU) | Assurance Learning Academy | Beach Cities Health District | Beachbody, LLC | Bloom Energy | BRT Holdings | CA CMA, Inc. | California Bail Agents Association | California Black Media | California Building Industry Association | California Business Properties Association | California Cannabis Couriers Association | California Cannabis Operators League | California Solar Energy Industries Association | Californians For Tobacco Harm Reduction | Center for Public Interest Law/Children's Advocacy Institute/University of San Diego | Center for Sustainable Energy | Chukchansi Economic Development Authority | Citadel Alternative Care | County of Santa Clara | Crescent View South, Inc. | Democracy Collaborative | Desert Sands Public Charter, Inc. | DJI Technology, LLC | Downtown Center Business Improvement District | DraftKings, Inc. | Dropbox, Inc | East Valley Water District | ecoLegacy | EDF Renewable Energy | Election Systems & Software, LLC | Encore Capital Group, Inc. | EnergySource, LLC | Facebook, Inc. | FanDuel, Inc. | First Point Management | First Solar | Fontem U.S. Inc., dba blue eCigs | Glamsquad, Inc. | Green Light District Holdings, Inc. | Greka Asphalt Corporation | Habematolel Pomo of Upper Lake | Herbalcure Corp. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
emplr_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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
emplr_city | Sacramento | Sacramento | San Bernardino | San Diego | San Jose | San Luis Obispo | Redwood City | San Jose | Soda Springs | Stockton | San Leandro | Washington | Diamond Bar | Glendora | Vancouver | San Francisco | Los Angeles | Sacramento | San Francisco | Oakland | Ventura | Phoenix | Alpine | Redding | Encino | Bala Cynwyd | San Francisco | San Francisco | Seattle | Salinas | San Francisco | Lancaster | Lancaster | Washington | New York | Los Angeles | Algona | Grove Beach | Louisville | Palm Desert | Sacramento | Lancaster | Redondo Beach | Santa Monica | Sunnyvale | Sacramento | Salinas | Pomona | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Cerritos | San Diego | Oakland | Fresno | Ceres | San Jose | Lancaster | Washington | Lancaster | Carson | Los Angeles | Boston | San Francisco | Highland | Dublin, Ireland | Portland | Omaha | San Diego | San Diego | Menlo Park | New York | Marina del Rey | Tempe | Charlotte | New York | Irvine | Santa Maria | Upper Lake | Los Angeles | Los Angeles | Malibu | Salinas | Boulder | Los Angeles | Sacramento | Rockville | Long Beach | Burbank | Sacramento | San Diego | Lancaster | National City | Indio | El Dorado Hills | Oak Park | Portland | Sacramento | Sacramento | Davis | Anza | Sacramento | Sacramento | Sacramento | Los Angeles | Malibu | Salinas | Boulder | Los Angeles | Sacramento | Rockville | Long Beach | Burbank | Sacramento | San Diego | Lancaster | National City | Indio | El Dorado Hills | Oak Park | Portland | Sacramento | Sacramento | Davis | Anza | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | San Bernardino | San Diego | San Jose | San Luis Obispo | Redwood City | San Jose | Soda Springs | Stockton | San Leandro | Washington | Diamond Bar | Glendora | Vancouver | San Francisco | Los Angeles | Sacramento | San Francisco | Oakland | Ventura | Phoenix | Alpine | Redding | Encino | Bala Cynwyd | San Francisco | San Francisco | Seattle | Salinas | San Francisco | Lancaster | Lancaster | Washington | New York | Los Angeles | Algona | Grove Beach | Louisville | Palm Desert | Sacramento | Lancaster | Redondo Beach | Santa Monica | Sunnyvale | Sacramento | Salinas | Pomona | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Cerritos | San Diego | Oakland | Fresno | Ceres | San Jose | Lancaster | Washington | Lancaster | Carson | Los Angeles | Boston | San Francisco | Highland | Dublin, Ireland | Portland | Omaha | San Diego | San Diego | Menlo Park | New York | Marina del Rey | Tempe | Charlotte | New York | Irvine | Santa Maria | Upper Lake | Los Angeles | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
emplr_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | DC | CA | CA | BC | CA | CA | CA | CA | CA | CA | AZ | CA | CA | CA | PA | CA | CA | WA | CA | CA | CA | CA | DC | NY | CA | IA | CA | CO | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | DC | CA | CA | CA | MA | CA | CA | None | OR | NE | CA | CA | CA | NY | CA | AZ | NC | NY | CA | CA | CA | CA | CA | CA | CA | CO | CA | CA | MD | CA | CA | CA | CA | CA | CA | CA | CA | CA | OR | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CO | CA | CA | MD | CA | CA | CA | CA | CA | CA | CA | CA | CA | OR | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | DC | CA | CA | BC | CA | CA | CA | CA | CA | CA | AZ | CA | CA | CA | PA | CA | CA | WA | CA | CA | CA | CA | DC | NY | CA | IA | CA | CO | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | DC | CA | CA | CA | MA | CA | CA | None | OR | NE | CA | CA | CA | NY | CA | AZ | NC | NY | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
emplr_zip4 | 95817 | 95818 | 92410 | 92123 | 95113 | 93401 | 94063 | 95134 | 95728 | 95207 | 94578 | 20005 | 91765 | 91740 | None | 94103 | 90036 | 95814 | 94103 | 94607 | 93003 | 85004 | 91901 | 96001 | 91436 | 19004 | 94105 | 94105 | 98101 | 93901 | 94107 | 93535 | 93535 | 20001 | 10285 | 90038 | 50511 | 93433 | 80027 | 92260 | 95814 | 93535 | 90277 | 90404 | 94089 | 95821 | 93901 | 91766 | 95818 | 95814 | 95814 | 95826 | 95820 | 95814 | 90703 | 92110 | 94612 | 93711 | 95307 | 95110 | 93535 | 20036 | 93535 | 90745 | 90017 | 02110 | 94107 | 92346 | 00002 | 97205 | 68137 | 92108 | 92130 | 94025 | 10003 | 90292 | 85281 | 28203 | 10010 | 92612 | 93455 | 95485 | 90664 | 90015 | 90265 | 93907 | 80303 | 90028 | 95812 | 20852 | 90813 | 91505 | 95814 | 92108 | 93535 | 91950 | 92202 | 95762 | 91377 | 97232 | 95814 | 95814 | 95618 | 92539 | 95820 | 95826 | 95814 | 90015 | 90265 | 93907 | 80303 | 90028 | 95812 | 20852 | 90813 | 91505 | 95814 | 92108 | 93535 | 91950 | 92202 | 95762 | 91377 | 97232 | 95814 | 95814 | 95618 | 92539 | 95820 | 95826 | 95814 | 95817 | 95818 | 92410 | 92123 | 95113 | 93401 | 94063 | 95134 | 95728 | 95207 | 94578 | 20005 | 91765 | 91740 | None | 94103 | 90036 | 95814 | 94103 | 94607 | 93003 | 85004 | 91901 | 96001 | 91436 | 19004 | 94105 | 94105 | 98101 | 93901 | 94107 | 93535 | 93535 | 20001 | 10285 | 90038 | 50511 | 93433 | 80027 | 92260 | 95814 | 93535 | 90277 | 90404 | 94089 | 95821 | 93901 | 91766 | 95818 | 95814 | 95814 | 95826 | 95820 | 95814 | 90703 | 92110 | 94612 | 93711 | 95307 | 95110 | 93535 | 20036 | 93535 | 90745 | 90017 | 02110 | 94107 | 92346 | 00002 | 97205 | 68137 | 92108 | 92130 | 94025 | 10003 | 90292 | 85281 | 28203 | 10010 | 92612 | 93455 | 95485 | 90664 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
emplr_phon | 9167326860 | 9163076100 | 9098848276 | 8585226781 | 4085358270 | 8055491202 | 6503634123 | 4083215556 | 5304267800 | 2099816940 | 5104325833 | 2026820556 | 9093962530 | 6267939364 | 6044098154 | 4152908045 | 2133651906 | 9163077741 | 4158423500 | 5108091572 | 8056421591 | 6022071067 | 6196592369 | 5302247297 | 8005626627 | 6106172600 | 4157495109 | 4154270774 | 2064707000 | 8318182956 | 4156386146 | 6612721225 | 6612721225 | 2024422293 | 2126400745 | 9164622161 | 5153951360 | 8054741328 | 7205423945 | 7603404499 | 9164467626 | 6612721225 | 3103743426 | 3108839000 | 4085431547 | 9165210588 | 8312629134 | 8883910456 | 9518237659 | 9164437933 | 9164434676 | 9162409430 | 9164751857 | 9167476987 | 5302247297 | 6192604806 | 5107254768 | 5593704026 | 9166061968 | 4082995183 | 6612721225 | 2025591473 | 6612721225 | 9162664575 | 2136242146 | 3019802133 | 2026276883 | 9098854900 | 33768925166 | 5038893835 | 4025930101 | 8583099757 | 8585090150 | 9162014067 | 2024705143 | 3108681439 | 4159352550 | None | 6467956470 | 9494387116 | 8056215889 | 7072750737 | 3104982271 | 2137450505 | 5617891689 | 8319755439 | 7206382754 | 3238708300 | 9166061667 | 3015405100 | 5622705454 | 8189728329 | 9164465058 | 6192780021 | 6612721225 | 6195818377 | 7607752263 | 9162356852 | 8187353200 | 5038136019 | 9164438891 | 9164491370 | 5302976000 | 9517634105 | 9164751857 | 9162409430 | 9168744627 | 2137450505 | 5617891689 | 8319755439 | 7206382754 | 3238708300 | 9166061667 | 3015405100 | 5622705454 | 8189728329 | 9164465058 | 6192780021 | 6612721225 | 6195818377 | 7607752263 | 9162356852 | 8187353200 | 5038136019 | 9164438891 | 9164491370 | 5302976000 | 9517634105 | 9164751857 | 9162409430 | 9168744627 | 9167326860 | 9163076100 | 9098848276 | 8585226781 | 4085358270 | 8055491202 | 6503634123 | 4083215556 | 5304267800 | 2099816940 | 5104325833 | 2026820556 | 9093962530 | 6267939364 | 6044098154 | 4152908045 | 2133651906 | 9163077741 | 4158423500 | 5108091572 | 8056421591 | 6022071067 | 6196592369 | 5302247297 | 8005626627 | 6106172600 | 4157495109 | 4154270774 | 2064707000 | 8318182956 | 4156386146 | 6612721225 | 6612721225 | 2024422293 | 2126400745 | 9164622161 | 5153951360 | 8054741328 | 7205423945 | 7603404499 | 9164467626 | 6612721225 | 3103743426 | 3108839000 | 4085431547 | 9165210588 | 8312629134 | 8883910456 | 9518237659 | 9164437933 | 9164434676 | 9162409430 | 9164751857 | 9167476987 | 5302247297 | 6192604806 | 5107254768 | 5593704026 | 9166061968 | 4082995183 | 6612721225 | 2025591473 | 6612721225 | 9162664575 | 2136242146 | 3019802133 | 2026276883 | 9098854900 | 33768925166 | 5038893835 | 4025930101 | 8583099757 | 8585090150 | 9162014067 | 2024705143 | 3108681439 | 4159352550 | None | 6467956470 | 9494387116 | 8056215889 | 7072750737 | 3104982271 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
lby_actvty | SB 100; AB 2693; SB 1088; SB 901; AB 2911; AB 1743; SB 929; SB 1027; AB 1906; AB 3232, SB 782, SB 1440, SB 1339, SB 1477, SB 64, AB 893, AB 2127, SB 929 | None | AB 2417; SB 1328; AB 2535; AB 1969; AB 2851; AB 2919; AB 3015; AB 1905; AB 2062; AB 2712; AB 1759; AB 1901; SB 1119; SB 1262 | None | AB 2851; AB 2865; AB 2919; AB 2418; AB 2989; AB 2544 | SB 1090 | None | SB 1328; SB 1387; AB 3124; AB 2535; AB 1898; AB 3139; AB 1792; AB 1969; AB 2851; AB 2865; AB 2919; AB 3015; AB 2062; AB 2712 | None | None | None | SB 1399; SB 1339; AB 2208; AB 813; SB 100; SB 1088; AB 2693; AB 2627; AB 1789; AB 893; SB 1347; SB 700; AB 2809; AB 2278; AB 2695; SB 1477; AB 2077 | AB 617 Implementation; AB 1806; AB 2008; AB 2506; AB 2548; SB 49; SB 1502 | None | Go-Biz; CAETFA | None | None | AB 2851; AB 2865; AB 2919; AB 2418; AB 2989; AB 2544 | SB 1014; SB 1376; AB 2986; AB 2765; AB 3059; SB 1080; AB 2777; AB 87; employment issues | Adaption issues; SB 1434; AB 813; SB 100; AB 2693; AB 2208; AB 2195; SB 1013; SB 1014; SB 1136 | SB 1119; AB 1905; SB 1328; AB 2304; AB 3124; Prp 69; AB 1969; AB 2851; AB 2919; AB 3015; AB 2062; AB 2712, AB 3015; AB 1912 | None | None | None | None | AB 2731 | None | SB 1402; AB 2379 | Real Estate Issues | none | SB 700; AB 2695; SB 1088; CPUC General Matters | None | None | SB 1001; AB 1121; AB 2110; AB 375; CalRecycle issues; AB 2765; AB 1906, AB 2379, SB 1402 | None | None | None | None | None | OPR CEQA Issues; AB 1804; AB 3023; AB 2341, AB 2447 | None | None | None | None | SB 1339; BIOGAS | None | None | None | None | None | None | None | None | SB 700; SB 100; AB 2695; SB 1088; SB 1081; AB 2063; SB 1399; AB 2068 | None | None | AB 2695; SB 700; SB 100; AB 3001; AB 3232, SB 1477, SB 1339, SB 1088; SB 782 | None | None | AB 2278 | None | None | None | AB 3173; SB 347 | None | None | Data Privacy Issues, AB 375 | None | None | AB 813; SB 100; AB 1789 | None | None | CEC Geothermal issues; AB 2208; AB 893; CIIP Issues | AB 2511; AB 1950; SB 1001; SB 966; SB 1424; AB 375; AB 2188 | None | None | AB 813; SB 100; AB 1789 | None | SB 999; Cosmetology issues | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | AB 2208; SB 100; SB 901; AB 2431; AB 2068; SB 819; AB 813; SB 1088; AB 893 | None | AB 1772; AB 1797; AB 1799; AB 1800; AB 1875; AB 1919; AB 1923; AB 2229; AB 2594; AB 2611; SB 824; SB 894; SB 897; SB 917; SB 1263; AB 2091; AB 2518; AB 2551; AB 2585; Continued in memo | AB 1335; SB 872; AB 1838; SB 1192; AB 3; AB 931; AB 2161; SB 10; SB 1010; AB 1871; AB 2335; SB 900; SB 1294; SB 1793; SB 794; SB 998; SB 623; AB 1668; AB 3157; Continued in memo | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | AB 2208; SB 100; SB 901; AB 2431; AB 2068; SB 819; AB 813; SB 1088; AB 893 | None | AB 1772; AB 1797; AB 1799; AB 1800; AB 1875; AB 1919; AB 1923; AB 2229; AB 2594; AB 2611; SB 824; SB 894; SB 897; SB 917; SB 1263; AB 2091; AB 2518; AB 2551; AB 2585; Continued in memo | AB 1335; SB 872; AB 1838; SB 1192; AB 3; AB 931; AB 2161; SB 10; SB 1010; AB 1871; AB 2335; SB 900; SB 1294; SB 1793; SB 794; SB 998; SB 623; AB 1668; AB 3157; Continued in memo | None | None | None | None | SB 100; AB 2693; SB 1088; SB 901; AB 2911; AB 1743; SB 929; SB 1027; AB 1906; AB 3232, SB 782, SB 1440, SB 1339, SB 1477, SB 64, AB 893, AB 2127, SB 929 | None | AB 2417; SB 1328; AB 2535; AB 1969; AB 2851; AB 2919; AB 3015; AB 1905; AB 2062; AB 2712; AB 1759; AB 1901; SB 1119; SB 1262 | None | AB 2851; AB 2865; AB 2919; AB 2418; AB 2989; AB 2544 | SB 1090 | None | SB 1328; SB 1387; AB 3124; AB 2535; AB 1898; AB 3139; AB 1792; AB 1969; AB 2851; AB 2865; AB 2919; AB 3015; AB 2062; AB 2712 | None | None | None | SB 1399; SB 1339; AB 2208; AB 813; SB 100; SB 1088; AB 2693; AB 2627; AB 1789; AB 893; SB 1347; SB 700; AB 2809; AB 2278; AB 2695; SB 1477; AB 2077 | AB 617 Implementation; AB 1806; AB 2008; AB 2506; AB 2548; SB 49; SB 1502 | None | Go-Biz; CAETFA | None | None | AB 2851; AB 2865; AB 2919; AB 2418; AB 2989; AB 2544 | SB 1014; SB 1376; AB 2986; AB 2765; AB 3059; SB 1080; AB 2777; AB 87; employment issues | Adaption issues; SB 1434; AB 813; SB 100; AB 2693; AB 2208; AB 2195; SB 1013; SB 1014; SB 1136 | SB 1119; AB 1905; SB 1328; AB 2304; AB 3124; Prp 69; AB 1969; AB 2851; AB 2919; AB 3015; AB 2062; AB 2712, AB 3015; AB 1912 | None | None | None | None | AB 2731 | None | SB 1402; AB 2379 | Real Estate Issues | none | SB 700; AB 2695; SB 1088; CPUC General Matters | None | None | SB 1001; AB 1121; AB 2110; AB 375; CalRecycle issues; AB 2765; AB 1906, AB 2379, SB 1402 | None | None | None | None | None | OPR CEQA Issues; AB 1804; AB 3023; AB 2341, AB 2447 | None | None | None | None | SB 1339; BIOGAS | None | None | None | None | None | None | None | None | SB 700; SB 100; AB 2695; SB 1088; SB 1081; AB 2063; SB 1399; AB 2068 | None | None | AB 2695; SB 700; SB 100; AB 3001; AB 3232, SB 1477, SB 1339, SB 1088; SB 782 | None | None | AB 2278 | None | None | None | AB 3173; SB 347 | None | None | Data Privacy Issues, AB 375 | None | None | AB 813; SB 100; AB 1789 | None | None | CEC Geothermal issues; AB 2208; AB 893; CIIP Issues | AB 2511; AB 1950; SB 1001; SB 966; SB 1424; AB 375; AB 2188 | None | None | AB 813; SB 100; AB 1789 | None | SB 999; Cosmetology issues | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fees_amt | 55000 | 0 | 25000 | 0 | 10000 | 30000 | 0 | 24000 | 0 | 0 | 0 | 30000 | 25875 | 0 | 30000 | 0 | 0 | 6000 | 10000 | 10000 | 13500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18750 | 0 | 20000 | 0 | 0 | 60000 | 0 | 0 | 0 | 0 | 0 | 12000 | 0 | 0 | 0 | 0 | 21000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30000 | 0 | 0 | 25000 | 0 | 0 | 0 | 3375 | 0 | 0 | 0 | 0 | 0 | 48000 | 0 | 0 | 13500 | 0 | 0 | 12000 | 0 | 4167 | 0 | 22500 | 0 | 22500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17000 | 0 | 30000 | 15000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17000 | 0 | 30000 | 15000 | 0 | 0 | 0 | 0 | 55000 | 0 | 25000 | 0 | 10000 | 30000 | 0 | 24000 | 0 | 0 | 0 | 30000 | 25875 | 0 | 30000 | 0 | 0 | 6000 | 10000 | 10000 | 13500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18750 | 0 | 20000 | 0 | 0 | 60000 | 0 | 0 | 0 | 0 | 0 | 12000 | 0 | 0 | 0 | 0 | 21000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30000 | 0 | 0 | 25000 | 0 | 0 | 0 | 3375 | 0 | 0 | 0 | 0 | 0 | 48000 | 0 | 0 | 13500 | 0 | 0 | 12000 | 0 | 4167 | 0 | 22500 | 0 | 22500 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
reimb_amt | 0 | 0 | 714 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 303 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 96 | 0 | 0 | 0 | 0 | 788 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 85 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 104 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 622 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 714 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 303 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 96 | 0 | 0 | 0 | 0 | 788 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 85 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 104 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 622 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
advan_amt | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | None | None | None | None | Receipt of stock units in client company. | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
per_total | 55000 | 0 | 25714 | 0 | 10000 | 30000 | 0 | 24000 | 0 | 0 | 0 | 30000 | 25875 | 0 | 30000 | 0 | 0 | 6000 | 40000 | 10000 | 13500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18750 | 0 | 20303 | 0 | 0 | 60000 | 0 | 0 | 0 | 0 | 0 | 12096 | 0 | 0 | 0 | 0 | 21788 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30000 | 0 | 0 | 25085 | 0 | 0 | 0 | 3375 | 0 | 0 | 0 | 0 | 0 | 48104 | 0 | 0 | 13500 | 0 | 0 | 12000 | 0 | 4167 | 0 | 22500 | 0 | 23122 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17000 | 0 | 30000 | 15000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17000 | 0 | 30000 | 15000 | 0 | 0 | 0 | 0 | 55000 | 0 | 25714 | 0 | 10000 | 30000 | 0 | 24000 | 0 | 0 | 0 | 30000 | 25875 | 0 | 30000 | 0 | 0 | 6000 | 10000 | 10000 | 13500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18750 | 0 | 20303 | 0 | 0 | 60000 | 0 | 0 | 0 | 0 | 0 | 12096 | 0 | 0 | 0 | 0 | 21788 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30000 | 0 | 0 | 25085 | 0 | 0 | 0 | 3375 | 0 | 0 | 0 | 0 | 0 | 48104 | 0 | 0 | 13500 | 0 | 0 | 12000 | 0 | 4167 | 0 | 22500 | 0 | 23122 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cum_total | 197000 | 0 | 105904 | 168877 | 150000 | 60010 | 82400 | 111000 | 0 | 18000 | 54243 | 60000 | 267375 | 14000 | 85139 | 37594 | 0 | 8000 | 310060 | 75833 | 81576 | 40859 | 211114 | 4000 | 15000 | 0 | 0 | 0 | 18750 | 3000 | 105905 | 3375 | 23689 | 200256 | 82789 | 0 | 40000 | 10000 | 32500 | 75800 | 52500 | 43939 | 51500 | 7500 | 129405 | 62520 | 115591 | 60582 | 0 | 109152 | 0 | 36494 | 8500 | 177214 | 15000 | 26000 | 85085 | 96208 | 0 | 3500 | 43939 | 75000 | 13500 | 195637 | 31003 | 62500 | 228351 | 44000 | 0 | 81000 | 117464 | 103500 | 131000 | 134059 | 75000 | 2000 | 135000 | 96000 | 30622 | 0 | 110000 | 72227 | 4000 | 120486 | 30000 | 4105 | 29000 | 0 | 9000 | 39000 | 7500 | 0 | 0 | 97980 | 37189 | 15000 | 15000 | 6000 | 32613 | 146419 | 116667 | 50000 | 70000 | 0 | 54504 | 12600 | 169000 | 120486 | 30000 | 4105 | 29000 | 0 | 9000 | 39000 | 7500 | 0 | 0 | 97980 | 37189 | 15000 | 15000 | 6000 | 32613 | 146419 | 116667 | 50000 | 70000 | 0 | 54504 | 12600 | 169000 | 197000 | 0 | 105904 | 168877 | 150000 | 60010 | 82400 | 111000 | 0 | 18000 | 54243 | 60000 | 267375 | 14000 | 85139 | 37594 | 0 | 8000 | 160060 | 75833 | 81576 | 40859 | 211114 | 4000 | 15000 | 0 | 0 | 0 | 18750 | 3000 | 105905 | 3375 | 23689 | 200256 | 82789 | 0 | 40000 | 10000 | 32500 | 75800 | 52500 | 43939 | 51500 | 7500 | 129405 | 62520 | 115591 | 60582 | 0 | 109152 | 0 | 36494 | 8500 | 177214 | 15000 | 26000 | 85085 | 96208 | 0 | 3500 | 43939 | 75000 | 13500 | 195637 | 31003 | 62500 | 228351 | 44000 | 0 | 81000 | 117464 | 103500 | 131000 | 134059 | 75000 | 2000 | 135000 | 96000 | 30622 | 0 | 110000 | 72227 | 4000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
memo_code | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
memo_refno | None | None | None | None | 87 | None | None | None | None | None | None | None | None | None | None | None | None | 100 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 36 | None | None | None | None | None | None | None | None | None | None | None | 48 | None | 50 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 68 | None | None | None | None | None | None | None | 76 | 77 | 78 | None | None | None | None | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | None | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
bakref_tid | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | 2272562 | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||||||||||
line_item | A | B | C | D | 0 | 1 | 2 | 3 | 0 | A | B | C | D | 0 | 1 | 2 | 3 | 0 | ||||||||||||||||||
rec_type | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | ||||||||||||||||||
form_type | F625 | F625 | F625 | F625 | F625P2 | F625P3A | F625P3A | F625P3A | F625P3B | F625 | F625 | F625 | F625 | F625P2 | F625P3A | F625P3A | F625P3A | F625P3B | ||||||||||||||||||
amount_a | 676880 | 0 | 0 | 0 | 676880 | 0 | 0 | 0 | 0 | 646880 | 0 | 0 | 0 | 646880 | 0 | 0 | 0 | 0 | ||||||||||||||||||
amount_b | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||
amount_c | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||
elec_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |