Home

Filing ID: 2102963

PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2102963&amendid=1

Table: cvr2_lobby_disclosure
amend_id   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
entity_cd   PTN   PTN   EMP   PTN   EMP   PTN   PTN   PTN   PTN   PTN   PTN   EMP   PTN   PTN   PTN   PTN   EMP   EMP   PTN   EMP   EMP   EMP   PTN   PTN   EMP   PTN   EMP   PTN   PTN   PTN   PTN   PTN   PTN   EMP   PTN   PTN   PTN   PTN   EMP   EMP   PTN   EMP   EMP   EMP
entity_id   1273641   1273640   1283112   None   1339214   1347952   None   None   1357079   1360393   1360391   1342956   None   1362014   1366131   1342710   1362308   1303784   1321943   1382186   1382188   1382189   1273641   1273640   1283112   None   1339214   1347952   None   None   1357079   1360393   1360391   1342956   None   1362014   1366131   1342710   1362308   1303784   1321943   1382186   1382188   1382189
enty_namf   Camden   Jared   Theodore   John   W. Chris   Victoria L.   B. B.   Anthony   Leslie   Jason   Winston   Claire   Rusty   Stephen   Joanne   James   Sarah   Devon   Cynthia   Kathrina   Monique   Kevin   Camden   Jared   Theodore   John   W. Chris   Victoria L.   B. B.   Anthony   Leslie   Jason   Winston   Claire   Rusty   Stephen   Joanne   James   Sarah   Devon   Cynthia   Kathrina   Monique   Kevin
enty_naml   McEfee   Ficker   Harris   Benton   Mowrer   Bradshaw   Blevins   Brunello   Rodriguez   Kinney   Hickox   van Zuiden   Areias   Larson   Kozberg   Lites, Jr.   Johnson   Ford   Guerrero   Gregana   Ramos   Schmidt   McEfee   Ficker   Harris   Benton   Mowrer   Bradshaw   Blevins   Brunello   Rodriguez   Kinney   Hickox   van Zuiden   Areias   Larson   Kozberg   Lites, Jr.   Johnson   Ford   Guerrero   Gregana   Ramos   Schmidt
enty_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
enty_namt   Mr.   Mr.   Mr.   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   Mr.   Mr.   Mr.   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
enty_title   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963
form_type   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625   F625
line_item   1   2   3   4   5   6   7   8   9   10   11   12   13   14   15   16   17   18   19   20   21   22   1   2   3   4   5   6   7   8   9   10   11   12   13   14   15   16   17   18   19   20   21   22
rec_type   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2   CVR2
tran_id   1   2   3   4   5   6   7   8   9   10   11   12   13   14   15   16   17   18   19   20   21   22   1   2   3   4   5   6   7   8   9   10   11   12   13   14   15   16   17   18   19   20   21   22
Table: cvr_lobby_disclosure
filing_id   2102963   2102963
amend_id   0   1
rec_type   CVR   CVR
form_type   F625   F625
sender_id   1273600   1273600
filer_id   1273600   1273600
entity_cd   FRM   FRM
filer_naml   CALIFORNIA STRATEGIES & ADVOCACY, LLC   CALIFORNIA STRATEGIES & ADVOCACY, LLC
filer_namf   None   None
filer_namt   None   None
filer_nams   None   None
report_num   000   001
rpt_date   2016-11-01 00:00:00   2017-02-02 00:00:00
from_date   2016-07-01 00:00:00   2016-07-01 00:00:00
thru_date   2016-09-30 00:00:00   2016-09-30 00:00:00
cum_beg_dt   2015-01-01 00:00:00   2015-01-01 00:00:00
firm_id   1273600   1273600
firm_name   None   None
firm_city   SACRAMENTO   SACRAMENTO
firm_st   CA   CA
firm_zip4   95814   95814
firm_phon   9162664575   9162664575
mail_city   None   None
mail_st   None   None
mail_zip4   None   None
mail_phon   None   None
sig_date   2016-10-27 00:00:00   2017-02-02 00:00:00
sig_loc   SACRAMENTO, CA   SACRAMENTO, CA
sig_naml   BURTON   BURTON
sig_namf   JAMES E.   JAMES E.
sig_namt   None   None
sig_nams   None   None
prn_naml   BURTON   BURTON
prn_namf   JAMES E.   JAMES E.
prn_namt   None   None
prn_nams   None   None
sig_title   MANAGING PRINCIPAL   MANAGING PRINCIPAL
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
Table: f690p2
filing_id   2102963
amend_id   1
line_item   1
rec_type   F690
form_type   F625
exec_date   2016-10-27 00:00:00
from_date   2016-07-01 00:00:00
thru_date   2016-09-30 00:00:00
chg_parts   II
chg_sects   None
amend_txt1   Corrected issues lobbied
Table: filer_filings
filer_id   1273600   1273600
filing_id   2102963   2102963
period_id   227   227
form_id   F625   F625
filing_sequence   0   1
filing_date   2016-11-01 00:00:00   2017-02-02 00:00:00
stmnt_type   10001   10002
stmnt_status   11001   11001
session_id   2015   2015
user_id   AGLADNEY   AGLADNEY
special_audit   11003   11003
fine_audit   11001   11001
rpt_start   2016-07-01 00:00:00   2016-07-01 00:00:00
rpt_end   2016-09-30 00:00:00   2016-09-30 00:00:00
rpt_date   None   None
filing_type   22006   22006
Table: filings
filing_id   2102963
filing_type   22001
Table: hdr
filing_id   2102963   2102963
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
Table: loth
filing_id   2102963   2102963   2102963   2102963   2102963   2102963
amend_id   0   0   0   1   1   1
line_item   1   2   3   1   2   3
rec_type   LOTH   LOTH   LOTH   LOTH   LOTH   LOTH
form_type   F625P3B   F625P3B   F625P3B   F625P3B   F625P3B   F625P3B
tran_id   96   97   98   96   97   98
firm_name   Governmental Advocates   John L. Pfeifer   Lang, Hansen O'Malley & Miller Government Relations   Governmental Advocates   John L. Pfeifer   Lang, Hansen O'Malley & Miller Government Relations
firm_city   Sacramento   Redding   Sacramento   Sacramento   Redding   Sacramento
firm_st   CA   CA   CA   CA   CA   CA
firm_zip4   95814   95602   95814   95814   95602   95814
firm_phon   9164488240   5302265117   None   9164488240   5302265117   None
subj_naml   Pointstreak Sports Technologies, Inc.   California Airports Council   Weedmaps   Pointstreak Sports Technologies, Inc.   California Airports Council   Weedmaps
subj_namf   None   None   None   None   None   None
subj_namt   None   None   None   None   None   None
subj_nams   None   None   None   None   None   None
pmt_date   None   None   None   None   None   None
amount   3750   1765   24000   3750   1765   24000
cum_amt   90350   9765   32000   90350   9765   32000
memo_code   None   None   None   None   None   None
memo_refno   None   None   None   96   97   98
Table: lpay
filing_id   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963
amend_id   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   0   0   0   0   0   0   0   0   0   0   0   0   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   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
line_item   21   22   23   24   25   26   27   28   29   30   31   32   33   34   35   36   37   38   39   40   41   42   43   44   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   1   2   3   4   5   6   7   8   9   10   11   12   13   14   15   16   17   18   19   45   46   1   9   10   11   12   13   19   20   24   25   26   27   37   39   40   42   43   47   48   49   50   57   58   59   60   61   62   63   64   65   66   67   68   71   72   73   20   28   29   30   34   36   2   3   4   5   6   7   8   14   23   31   32   33   35   38   41   44   45   46   51   52   53   54   55   56   69   70   15   16   17   18   21   22
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
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
tran_id   43   44   45   46   47   48   49   50   51   52   53   54   55   56   57   58   59   60   61   62   63   64   65   66   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   23   24   25   26   27   28   29   30   31   32   33   34   35   36   37   38   39   40   41   67   68   23   31   32   33   34   35   41   42   46   47   48   49   59   61   62   64   65   69   70   71   72   79   80   81   82   83   84   85   86   87   88   89   90   93   94   95   42   50   51   52   56   58   24   25   26   27   28   29   30   36   45   53   54   55   57   60   63   66   67   68   73   74   75   76   77   78   91   92   37   38   39   40   43   44
entity_cd   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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_naml   Conestoga Energy, LLC   CTIA- The Wireless Association   DentaQuest, LLC   DOWNTOWN RAILYARD VENTURE, INC.   Everyday Energy   First Priority Global, LTD   FLRish, Inc.   Forest Carbon Partners L.P.   Green Charge Networks, LLC   Green Dot Public Schools National   Hack Reactor, LLC   Honeywell International   Inland Valley Development Agency   Inmar, Inc   Jacobs Engineering Group, Inc.   Joseph Gallo Farms   Junior Blind of America   Lennar Homes of California and its affiliates   Lunera Lighting, Inc.   MJ FREEWAY, LLC   National Elevator Industry, Inc.   Newhall Holding Company, LLC   Pearson Education Inc.. etal   Peloton Technology Inc.   Proterra   Ralphs Grocery Company   ReviverMX   SA Recycling LLC   Schindler Elevator Corporation   Schott & Lites Advocates on behalf of Bay Area Rapid Transportation (BART)   Stack Labs Inc.   Trical, Inc.   Upwork, Inc.   The Blackstone Group, L.P.   The Health Trust   Utiliquest, LLC   Weedmaps   White Energy Holding Company, LLC   World Oil Corporation its subsidiaries and affiliates   Southern California Grantmakers   OhmConnect, Inc.   Heron Pacific, LLC (d/b/a Wildlands)   Green Commuter   Frost/Chaddock Developers LLC   Booster Fuels   Salinas Basin Agriculture Stewardship Group   Neste US, Inc.   Magna Legal Services   Esquire Depositions Soutions, LLC   Veritext Corporation   US Legal Support, Inc.   California Professional Association of Specialty Contractors (CALPASC)   City of Canyon Lake   Medolac Laboratories, a public benefit corporation   Accenture, LLP   ACCL, Inc.   AMEC Foster Wheeler Environment& Infrastructure, Inc.   Amerisource Bergen Corporation   AT&T Inc. and its Affiliates   Blue Source, LLC   California Airports Council   California School Board Association   CalMat DBA Vulcan Materials Company, West Region   CE2 Carbon Capital, LLC   Chris Kelly   CHUBB - North America   City of Malibu   Clean Harbors Environmental Services, Inc.   Climatec LLC   Conaway Preservation Group, LLC   Pointstreak Sports Technologies, Inc.   Propel Fuels, Inc.   California Professional Association of Specialty Contractors (CALPASC)   Blue Source, LLC   California Airports Council   California School Board Association   CalMat DBA Vulcan Materials Company, West Region   CE2 Carbon Capital, LLC   Conaway Preservation Group, LLC   Children and Families Commission of Los Angeles County   DOWNTOWN RAILYARD VENTURE, INC.   Everyday Energy   First Priority Global, LTD   FLRish, Inc.   Junior Blind of America   Lunera Lighting, Inc.   MJ FREEWAY, LLC   Newhall Holding Company, LLC   Pearson Education Inc.. etal   Proterra   Ralphs Grocery Company   ReviverMX   SA Recycling LLC   The Health Trust   Utiliquest, LLC   Weedmaps   White Energy Holding Company, LLC   World Oil Corporation its subsidiaries and affiliates   Southern California Grantmakers   OhmConnect, Inc.   Heron Pacific, LLC (d/b/a Wildlands)   Green Commuter   Frost/Chaddock Developers LLC   Booster Fuels   Salinas Basin Agriculture Stewardship Group   Esquire Depositions Soutions, LLC   Veritext Corporation   US Legal Support, Inc.   Children and Families Commission of Los Angeles County   Forest Carbon Partners L.P.   Green Charge Networks, LLC   Green Dot Public Schools National   Inmar, Inc   Joseph Gallo Farms   City of Canyon Lake   Medolac Laboratories, a public benefit corporation   Accenture, LLP   ACCL, Inc.   AMEC Foster Wheeler Environment& Infrastructure, Inc.   Amerisource Bergen Corporation   AT&T Inc. and its Affiliates   Chris Kelly   DentaQuest, LLC   Hack Reactor, LLC   Honeywell International   Inland Valley Development Agency   Jacobs Engineering Group, Inc.   Lennar Homes of California and its affiliates   National Elevator Industry, Inc.   Peloton Technology Inc.   Pointstreak Sports Technologies, Inc.   Propel Fuels, Inc.   Schindler Elevator Corporation   Schott & Lites Advocates on behalf of Bay Area Rapid Transportation (BART)   Stack Labs Inc.   Trical, Inc.   Upwork, Inc.   The Blackstone Group, L.P.   Neste US, Inc.   Magna Legal Services   CHUBB - North America   City of Malibu   Clean Harbors Environmental Services, Inc.   Climatec LLC   Conestoga Energy, LLC   CTIA- The Wireless Association
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
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
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
emplr_city   Liberal   Washington   Boston   MCCELLAN   Carlsbad   Flanders   Carmel   San Francisco   Santa Clara   Los Angeles   San Francisco   Washington   San Bernardino   Winston-Salem   Pasadena   Atwater   Los Angeles   San Francisco   Santa Clara   DENVER   Salem   Valencia   New York   Mountain View   Greenville   Los Angeles   San Francisco   Orange   Morristown   Sacramento   Cupertino   hol   Mountain View   New York   San Jose   Alpharetta   Irvine   Plano   South Gate   Los Angeles   San Francisco   Rocklin   Los Angeles   Los Angeles   Seattle   Salinas   Houston   Philadelphia   Atlanta   Livingston   Baltimore   Sacramento   Canyon Lake   Lake Oswego   Washington   Oakland   San Diego   Chesterbrook   Sacramento   Murray   Sacramento   West Sacramento   GLENDALE   Solana Beach   ATHERTON   Philadelphia   Malibu   Norwell   Phoenix   Woodland   Thornhill, Ontario   Redwood City   Sacramento   Murray   Sacramento   West Sacramento   GLENDALE   Solana Beach   Woodland   Los Angeles   MCCELLAN   Carlsbad   Flanders   Carmel   Los Angeles   Santa Clara   DENVER   Valencia   New York   Greenville   Los Angeles   San Francisco   Orange   San Jose   Alpharetta   Irvine   Plano   South Gate   Los Angeles   San Francisco   Rocklin   Los Angeles   Los Angeles   Seattle   Salinas   Atlanta   Livingston   Baltimore   Los Angeles   San Francisco   Santa Clara   Los Angeles   Winston-Salem   Atwater   Canyon Lake   Lake Oswego   Washington   Oakland   San Diego   Chesterbrook   Sacramento   ATHERTON   Boston   San Francisco   Washington   San Bernardino   Pasadena   San Francisco   Salem   Mountain View   Thornhill, Ontario   Redwood City   Morristown   Sacramento   Cupertino   hol   Mountain View   New York   Houston   Philadelphia   Philadelphia   Malibu   Norwell   Phoenix   Liberal   Washington
emplr_st   KS   DC   MA   CA   CA   NJ   CA   CA   CA   CA   CA   DC   CA   NC   CA   CA   CA   CA   CA   CO   NY   CA   NY   CA   SC   CA   CA   CA   NJ   CA   CA   CA   CA   NY   CA   GA   CA   TX   CA   CA   CA   CA   CA   CA   WA   CA   TX   PA   GA   NJ   MD   CA   CA   OR   DC   CA   CA   PA   CA   UT   CA   CA   CA   CA   CA   PA   CA   MA   AZ   CA   CN   CA   CA   UT   CA   CA   CA   CA   CA   CA   CA   CA   NJ   CA   CA   CA   CO   CA   NY   SC   CA   CA   CA   CA   GA   CA   TX   CA   CA   CA   CA   CA   CA   WA   CA   GA   NJ   MD   CA   CA   CA   CA   NC   CA   CA   OR   DC   CA   CA   PA   CA   CA   MA   CA   DC   CA   CA   CA   NY   CA   CN   CA   NJ   CA   CA   CA   CA   NY   TX   PA   PA   CA   MA   AZ   KS   DC
emplr_zip4   67901   20036   02129   95652   92008   07836   93922   94111   95054   90015   94102   20001   92408   27101   91101   95301   90043   94111   95054   80202   12865   91354   10013   94043   29607   90054   94103   92865   07960   95814   95014   95024   94043   10154   95118   30004   92618   75093   90280   90012   94107   95765   90013   90013   98122   93901   77027   19103   30303   07039   21201   95814   92587   97035   20006   94621   92130   19087   95814   84092   95814   95691   91203   92075   94027   19106   90245   02061   85053   95776   99999   94063   95814   84092   95814   95691   91203   92075   95776   90012   95652   92008   07836   93922   90043   95054   80202   91354   10013   29607   90054   94103   92865   95118   30004   92618   75093   90280   90012   94107   95765   90013   90013   98122   93901   30303   07039   21201   90012   94111   95054   90015   27101   95301   92587   97035   20006   94621   92130   19087   95814   94027   02129   94102   20001   92408   91101   94111   12865   94043   99999   94063   07960   95814   95014   95024   94043   10154   77027   19103   19106   90245   02061   85053   67901   20036
emplr_phon   6206262021   2027850081   6178861458   9169657100   7605332470   9733474033   8312775333   4153213300   4086380072   3235651600   9257273863   6023652641   9093824100   3367703556   6265687043   2093947984   3232954555   4159954802   6502413875   8889326537   7852867599   6612554259   2024712169   6503957356   6507148532   3108844141   4155050566   7146322000   9733976510   None   4085644938   9517376960   6503167500   6464828953   None   6784613900   8449333627   9727156490   5629280100   2136808866   8446462664   9164353555   8185359391   3238831800   9252091847   8317542444   7134074400   8666246221   4044950777   9734104040   6092521300   9167042638   9512442955   8665997740   2025331140   5105456984   8585146426   6107277361   9163413400   8013224750   9165534999   None   8185538800   8584810024   9162664575   2156405291   3104562489   None   6029061713   None   9057319867   2069795294   9167042638   8013224750   9165534999   None   8185538800   8584810024   None   2134825902   9169657100   7605332470   9733474033   8312775333   3232954555   6502413875   8889326537   6612554259   2024712169   6507148532   3108844141   4155050566   7146322000   None   6784613900   8449333627   9727156490   5629280100   2136808866   8446462664   9164353555   8185359391   3238831800   9252091847   8317542444   4044950777   9734104040   6092521300   2134825902   4153213300   4086380072   3235651600   3367703556   2093947984   9512442955   8665997740   2025331140   5105456984   8585146426   6107277361   9163413400   9162664575   6178861458   9257273863   6023652641   9093824100   6265687043   4159954802   7852867599   6503957356   9057319867   2069795294   9733976510   None   4085644938   9517376960   6503167500   6464828953   7134074400   8666246221   2156405291   3104562489   None   6029061713   6206262021   2027850081
lby_actvty   Air Resources Board, CalEpa, re: Implementation of AB 32 and establishment of new offset protocols.   Legislature re: Long range policy issues; California Energy Commission re: Clarification of battery charger regulations; Administration, CalEpa re: BPA Prop 65 Listing   Legislature, Dept. of Finance, Governor's Ofc, Dept Health Care Services, State Auditor, Dept. of Public Health re: AB 1051, 1568, 1890,   Legislature, Administration, Department of Finance, Natural Resources Agency, Department of Parks and Recreation, Dept. General Services, CA Govt Ops Agency re: State Infrastructure and Budget Issues   California Public Utilities Commission re: Implementation of the Multifamily Affordable Solar Homes Program   Administration re: ZEV credits for medium and heavy duty vehicles   Legislature, Administration, Department of Consumer Affairs, Department of Food & Agriculture, California Bureau of Medical Marijuana Regulation re: AB 1575 and Budget Issues   Legislature re: Implementation of Senate Bill 32; Air Resources Board, CalEpa re: Implementation of AB 32 and establishment of forestry offset protocol.   California Public Utilities Commission re: Approval for self generation incentive program; Legislature re: Implementation of AB 1637, AB 2868   Superintendent of Public Instruction re: School Expansion; Legislature, Administration, Dept. of Finance, Dept. of Education, State Board of Education, Legislative Analyst Office   Legislature, Private Post Secondary Education, Department of Consumer Affairs, Business, Consumer Services & Housing Agency re: SB 1192High Technology Career School Licensing and Task Force   Department of Toxic Substance Control re: Mercury Thermostat Regulations   Legislature, Governor's Office, Dept of Finance: AB 2514   Legislature, Governor's Office, Department of Toxic Substance Control re: SB 423, retail waste working group   Legislature, Governor's Office, Contractors State License Board, Dept. of Consumer Affairs re: AB 1793   Air Resources Board re: Carbon Protocols, short-lived climate pollutants, Cap and Trade Programs   Legislature, Administration, Health & Human Services, Healthcare Services re: Programs & services provided by Jr. Blind to disabled children & adults; workforce development issues, 1115B   Legislature, Governor?s office, Department of Finance re:AB 723, 806, 1886, 1934, 2031, 2180, 2208, 2442, 2492, 2501, 2514, 2556, 2697, 2734, 2797 SB 122, 1000 , Budget Issues, Affordable Housing,   California Energy Commission, California Public Utilities Commission, Dept. of General Services, Government Operations Agency, Go-Biz re: Expanding energy efficiency for existing and new buildings   Legislature, Administration, Department of Consumer Affairs, Department of Food & Ag, California Bureau of Medical Marijuana Regulation re: AB 1576 and Budget Issues   Labor & Workforce Agency, Legislature, Dept. of Finance, Dept of Industrial Relations, CalOsha, Office of Statewide Health Planning & Development, Go-Biz,   Air Resources Board, California Energy Commission, Administration re CEQA, Zero Net Energy Policy   Legislature, Administration, Department of Finance, State Board of Education, Department of Education, California State Teacher Credentialing re: State Budget,   Legislature, Administration, Caltrans, CA Highway Patrol, CA Transportation Agency, Air Resources Board re: SB 431   Legislature, Gov's Office, CA Air Resources Board, Transportation Agency, Caltrans re: AB 2334, 2415, SB 824, Budget Issues,   Legislature, Governor's Office, Department of Toxic Substance Control re: SB 423, retail waste working group   Legislature, Administration and Department of Motor Vehicles re: SB 1399   Legislature, Governor?s Office, CalRecycle, Dept. of Toxic Substance Control re: Implementation of SB 1249; Bureau of Automotive Repair re: Retired Vehicle Program   Department of Industrial Relations, Cal-Osha, Occupational Health & Safety Standards Board re: Elevator Issues   Legislature re: AB 528, AB 1640   No longer a client payment made for prior quarter   Department of Pesticide Regulation re: Fumigant Policy   Legislature, Department of Industrial Relations and Employment Development Department re: AB 1727 related issues   Legislature, Office of Business Oversight re: AB 2281,2282, 2283, 2863   Legislature re: Fluoridation for East San Jose   Legislature re: SB 661   Legislature, Administration, Department of Consumer Affairs, Department of Food & Ag, California Medical Marijuana Regulation re: AB 1575 and Budget Issues and medical cannabis   Air Resources Board regarding Implementation of the Low Carbon Fuel Standard   No lobbying   None   California Public Utilities Commission re: Access to Meter Data and Expanding the Future of Demand Response   Legislature, Dept. of Fish & Wildlife, Natural Resources Agency re: AB 2087   Air Resources Board re: Low Carbon Transportation Funding Plan   Legislature, Administration re: AB 1619, SB 847   State Fire Marshal, California Air Resources Board, Dept. of Food & Ag, CA Highway Patrol, Dept. of Water Resources, Dept. Fish & Wildlife, Board of Equalization re: Proposed changes to the Fire Code   Legislature, Administration, State Water Resources Control Board re: Water quality   Legislature, Administration, Air Resources Board re: Budget, SB 32, Low Carbon Fuels Standard   Legislature, Administration re: SB 270   Legislature, Administration re: SB 270   Legislature, Administration re: SB 270   Legislature, Administration re: SB 270   Legislature re: AB 1793   Legislature, Governor's Office re: Water Policy   Legislature re: SB 1316   Health & Human Services Agency, Dept of Finance re: Funding for automation of public assistance programs; Health Benefits Exchange re: CalHEERS; High Speed Rail re: Business Development Opportunities   Legislature, Administration, Department of Consumer Affairs, Department of Food & Ag, California Medical Marijuana Regulation re: AB 1575 and Budget Issues   Legislature, California Department of Transportation, State Transportation Agency re: Transportation Project Delivery; High Speed Rail Authority re: Inspection Audit Program;   Board of Pharmacy re: Pharmacutical Product Stewardship, Electronic Pedigree; CURES System, compounding; Attorney General's Office, Legislature re: CURES System   None   CalEpa, Air Resources Board re: implementation of AB 32 and seeking approval of early action offset program   Legislature, Gov's Ofc, Dept. of Finance re: AB 626, AB 650, Aviation Fuel Taxes; Air Resources Board re: Proposed air emissions regulations.   Legislature, Governor's Office, Department of Finance, Department of Education, Commission on Teacher Credentialing re: SB 799   Air Resources Board re: Coordinated draft laboratory guidance   Air Resources Board, CalEpa re: Implementation of AB 32 and establishment of new offset protocols   Legislature, Governor's Office, Attorney General's Office re: SB 448   : Legislature, Administration, Dept. of Industrial Relations, Dept. of Insurance re: Financial solvency regulations, large risk collateral agreements, Implementation of SB 863, Insurer Investments,   Legislature, Administration, Dept of Health & Human Services and it's agencies re: Sober Living Homes & Drug Rehabilitation Facilities and related policy issues, monitor AB 2403;   Legislature, Administration, Dept of Toxic Substance Control, Cal-Recycle, Independent Review Panel, Dept. of Forestry and Fire Protection, State Fire Marshall re: AB 1102. 1205, 1400, 2794, SB 839,   Strategic Growth Council, Government Operations Agency re: Affordable and Sustainable Housing Communities; CA Public Utilities Commission re: Utility Energy Efficiency Programs;   Legislature, Administration, Natural Resources Agency, Dept. of Fish & Wildlife, Sacramento-San Joaquin Delta Conservancy re: Proposition 1 Funding   No longer a Client payment for prior quarter.   Legislature, Administration, Dept. of Finance, CA Energy Commission, Air Resources Board re: AB 2127, AB 1550, SB 32, Budget, Low Carbon Fuel Standard   Legislature re: AB 1793   CalEpa, Air Resources Board re: implementation of AB 32 and seeking approval of early action offset program   Legislature, Gov's Ofc, Dept. of Finance re: AB 626, AB 650, Aviation Fuel Taxes; Air Resources Board re: Proposed air emissions regulations.   Legislature, Governor's Office, Department of Finance, Department of Education, Commission on Teacher Credentialing re: SB 799   Air Resources Board re: Coordinated draft laboratory guidance   Air Resources Board, CalEpa re: Implementation of AB 32 and establishment of new offset protocols   Legislature, Administration, Natural Resources Agency, Dept. of Fish & Wildlife, Sacramento-San Joaquin Delta Conservancy re: Proposition 1 Funding   CA Dept of Education, Dept of Healthcare Services, Dept of Public Health, Health & Human Services and its agencies, Legislature, Administration, Dept Finance, Legislative Analyst Office,   Legislature, Administration, Department of Finance, Natural Resources Agency, Department of Parks and Recreation, Dept. General Services, CA Govt Ops Agency re: State Infrastructure and Budget Issues   California Public Utilities Commission re: Implementation of the Multifamily Affordable Solar Homes Program   Administration re: ZEV credits for medium and heavy duty vehicles   Legislature, Administration, Department of Consumer Affairs, Department of Food & Agriculture, California Bureau of Medical Marijuana Regulation re: AB 1575 and Budget Issues   Legislature, Administration, Health & Human Services, Healthcare Services re: Programs & services provided by Jr. Blind to disabled children & adults; workforce development issues, 1115B   California Energy Commission, California Public Utilities Commission, Dept. of General Services, Government Operations Agency, Go-Biz re: Expanding energy efficiency for existing and new buildings   Legislature, Administration, Department of Consumer Affairs, Department of Food & Ag, California Bureau of Medical Marijuana Regulation re: AB 1576 and Budget Issues   Air Resources Board, California Energy Commission, Administration re CEQA, Zero Net Energy Policy   Legislature, Administration, Department of Finance, State Board of Education, Department of Education, California State Teacher Credentialing re: State Budget,   Legislature, Gov's Office, CA Air Resources Board, Transportation Agency, Caltrans re: AB 2334, 2415, SB 824, Budget Issues,   Legislature, Governor's Office, Department of Toxic Substance Control re: SB 423   Legislature, Administration and Department of Motor Vehicles re: SB 1399   Legislature, Governor?s Office, CalRecycle, Dept. of Toxic Substance Control re: Implementation of SB 1249; Bureau of Automotive Repair re: Retired Vehicle Program   Legislature re: Fluoridation for East San Jose   Legislature re: SB 661   Legislature, Administration, Department of Consumer Affairs, Department of Food & Ag, California Medical Marijuana Regulation re: AB 1575 and Budget Issues and medical cannabis   Air Resources Board regarding Implementation of the Low Carbon Fuel Standard   No lobbying   None   California Public Utilities Commission re: Access to Meter Data and Expanding the Future of Demand Response   Legislature, Dept. of Fish & Wildlife, Natural Resources Agency re: AB 2087   Air Resources Board re: Low Carbon Transportation Funding Plan   Legislature, Administration re: AB 1619, SB 847   State Fire Marshal, California Air Resources Board, Dept. of Food & Ag, CA Highway Patrol, Dept. of Water Resources, Dept. Fish & Wildlife, Board of Equalization re: Proposed changes to the Fire Code   Legislature, Administration, State Water Resources Control Board re: Water quality   Legislature, Administration re: SB 270   Legislature, Administration re: SB 270   Legislature, Administration re: SB 270   CA Dept of Education, Dept of Healthcare Services, Dept of Public Health, Health & Human Services and its agencies, Legislature, Administration, Dept Finance, Legislative Analyst Office,   Legislature re: Implementation of Senate Bill 32; Air Resources Board, CalEpa re: Implementation of AB 32 and establishment of forestry offset protocol.   California Public Utilities Commission re: Approval for self generation incentive program; Legislature re: Implementation of AB 1637, AB 2868   Superintendent of Public Instruction re: School Expansion; Legislature, Administration, Dept. of Finance, Dept. of Education, State Board of Education, Legislative Analyst Office   Legislature, Governor's Office, Department of Toxic Substance Control re: SB 423, retail waste working group   Air Resources Board re: Carbon Protocols, short-lived climate pollutants, Cap and Trade Programs   Legislature, Governor's Office re: Water Policy   Legislature re: SB 1316   Health & Human Services Agency, Dept of Finance re: Funding for automation of public assistance programs; Health Benefits Exchange re: CalHEERS; High Speed Rail re: Business Development Opportunities   Legislature, Administration, Department of Consumer Affairs, Department of Food & Ag, California Medical Marijuana Regulation re: AB 1575 and Budget Issues   Legislature, California Department of Transportation, State Transportation Agency re: Transportation Project Delivery; High Speed Rail Authority re: Inspection Audit Program;   Board of Pharmacy re: Pharmacutical Product Stewardship, Electronic Pedigree; CURES System, compounding; Attorney General's Office, Legislature re: CURES System   None   Legislature, Governor's Office, Attorney General's Office re: SB 448   Legislature, Dept. of Finance, Governor's Ofc, Dept Health Care Services, State Auditor, Dept. of Public Health re: AB 1051, 1568, 1890,   Legislature, Private Post Secondary Education, Department of Consumer Affairs, Business, Consumer Services & Housing Agency re: SB 1192High Technology Career School Licensing and Task Force   Department of Toxic Substance Control re: Mercury Thermostat Regulations   Legislature, Governor's Office, Dept of Finance: AB 2514   Legislature, Governor's Office, Contractors State License Board, Dept. of Consumer Affairs re: AB 1793   Legislature, Governor?s office, Department of Finance re:AB 723, 806, 1886, 1934, 2031, 2180, 2208, 2442, 2492, 2501, 2514, 2556, 2697, 2734, 2797 SB 122, 1000 , Budget Issues, Affordable Housing,   Labor & Workforce Agency, Legislature, Dept. of Finance, Dept of Industrial Relations, CalOsha, Office of Statewide Health Planning & Development, Go-Biz,   Legislature, Administration, Caltrans, CA Highway Patrol, CA Transportation Agency, Air Resources Board re: SB 431   No longer a Client payment for prior quarter.   Legislature, Administration, Dept. of Finance, CA Energy Commission, Air Resources Board re: AB 2127, AB 1550, SB 32, Budget, Low Carbon Fuel Standard   Department of Industrial Relations, Cal-Osha, Occupational Health & Safety Standards Board re: Elevator Issues   Legislature re: AB 528, AB 1640   No longer a client payment made for prior quarter   Department of Pesticide Regulation re: Fumigant Policy   Legislature, Department of Industrial Relations and Employment Development Department re: AB 1727 related issues   Legislature, Office of Business Oversight re: AB 2281,2282, 2283, 2863   Legislature, Administration, Air Resources Board re: Budget, SB 32, Low Carbon Fuels Standard   Legislature, Administration re: SB 270   : Legislature, Administration, Dept. of Industrial Relations, Dept. of Insurance re: Financial solvency regulations, large risk collateral agreements, Implementation of SB 863, Insurer Investments,   Legislature, Administration, Dept of Health & Human Services and it's agencies re: Sober Living Homes & Drug Rehabilitation Facilities and related policy issues, monitor AB 2403;   Legislature, Administration, Dept of Toxic Substance Control, Cal-Recycle, Independent Review Panel, Dept. of Forestry and Fire Protection, State Fire Marshall re: AB 1102. 1205, 1400, 2794, SB 839,   Strategic Growth Council, Government Operations Agency re: Affordable and Sustainable Housing Communities; CA Public Utilities Commission re: Utility Energy Efficiency Programs;   Air Resources Board, CalEpa, re: Implementation of AB 32 and establishment of new offset protocols.   Legislature re: Long range policy issues; California Energy Commission re: Clarification of battery charger regulations; Administration, CalEpa re: BPA Prop 65 Listing
fees_amt   30000   37500   20000   45000   27000   20000   35000   11000   20000   6000   65000   28000   12000   10500   70000   8000   10000   90500   22500   30000   10000   37500   72000   0   30000   7000   0   15000   0   4500   4000   6000   17000   45000   0   50000   36000   30000   60000   6000   14000   20000   0   0   18750   31000   20000   2500   2500   2500   2500   0   0   0   30000   22500   22000   21000   8166   12000   6140   37500   18000   10500   10000   24000   37500   30000   24000   35000   7500   30000   0   12000   6140   37500   18000   10500   35000   72001   45000   27000   20000   35000   10000   22500   30000   37500   72000   30000   7000   0   15000   0   50000   36000   30000   60000   6000   14000   20000   0   0   18750   31000   2500   2500   2500   72001   11000   20000   6000   10500   8000   0   0   30000   22500   22000   21000   8166   10000   20000   65000   28000   12000   70000   90500   10000   0   7500   30000   0   4500   4000   6000   17000   45000   20000   2500   24000   37500   30000   24000   30000   37500
reimb_amt   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1105   446   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   690   0   0   0   0   0   0   0   0   0   0   0   0   0   0   760   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1105   446   0   0   0   0   0   0   0   0   0   0   0   0   760   0   0   0   0   0   0   0   0   0   0   0   0   690   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_amt   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   30000   37500   20000   45000   27000   20000   35000   11000   20000   6000   65000   28000   12000   10500   70000   8000   10000   90500   22500   30000   10000   37500   72000   0   30000   7000   0   15000   0   4500   4000   6000   17000   45000   0   51105   36446   30000   60000   6000   14000   20000   0   0   18750   31000   20000   2500   2500   2500   2500   0   0   0   30000   22500   22000   21000   8166   12000   6140   37500   18000   10500   10690   24000   37500   30000   24000   35000   7500   30000   0   12000   6140   37500   18000   10500   35000   72761   45000   27000   20000   35000   10000   22500   30000   37500   72000   30000   7000   0   15000   0   51105   36446   30000   60000   6000   14000   20000   0   0   18750   31000   2500   2500   2500   72761   11000   20000   6000   10500   8000   0   0   30000   22500   22000   21000   8166   10690   20000   65000   28000   12000   70000   90500   10000   0   7500   30000   0   4500   4000   6000   17000   45000   20000   2500   24000   37500   30000   24000   30000   37500
cum_total   165000   249500   233215   105000   107500   20000   115000   45500   30000   6000   215000   278000   56000   17500   162300   84000   100000   328000   60000   80000   106723   250000   300000   90000   203217   21000   0   197500   10575   12000   25000   56000   34161   79350   0   188605   48446   165000   160000   6000   14000   20000   0   0   18750   31000   20000   2500   2500   2500   2500   35000   0   0   125000   37500   126500   154000   10250   18000   29473   147500   189000   70000   65690   168694   262500   240000   144000   133000   180350   210000   35000   18000   29473   147500   189000   70000   133000   582767   105000   107500   20000   115000   100000   60000   80000   250000   300000   203217   21000   0   197500   0   188605   48446   165000   160000   6000   14000   20000   0   0   18750   31000   2500   2500   2500   582767   45500   30000   6000   17500   84000   0   0   125000   37500   126500   154000   10250   65690   233215   215000   278000   56000   162300   328000   106723   90000   180350   210000   10575   12000   25000   56000   34161   79350   20000   2500   168694   262500   240000   144000   165000   249500
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
memo_refno   43   44   45   46   47   48   49   50   51   52   53   54   55   56   57   58   59   60   61   62   63   64   65   66   69   None   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   None   None   None   26   27   28   29   30   31   32   33   34   35   36   37   38   39   40   41   67   68   23   None   None   None   None   None   None   42   None   None   None   None   59   None   None   None   65   69   None   None   None   None   None   81   None   None   None   None   None   None   None   None   90   None   None   None   42   None   None   52   None   None   24   25   None   None   None   29   None   None   45   None   None   None   None   60   63   None   None   None   None   None   None   None   None   None   None   None   37   38   39   40   None   None
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
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
Table: smry
filing_id   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963   2102963
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   1602558   0   29515   29515   1602558   0   0   0   29515   1602558   0   29515   29515   1602558   0   0   0   29515
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