\n | segment | \nperson_id | \nmember_key | \nmember_id | \nmember_suffix | \nfamily_member_id | \nmember_relative | \nmember_first_name | \nmember_mid_initial | \nmember_last_name | \n... | \nmedicare_part_d | \nmetallic_plan | \nohsu_plus | \nonboarding_campaign_indicator | \npaperless | \npharmacy_coverage | \nself_funded_groups | \nuniform_medical_plan_wa | \ncreated_by | \ncreated_time | \n
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \nRegenceAdultEmailOptIn | \n65136899000654 | \n2187896363 | \n8623056062 | \n29 | \n63770390473738 | \nS | \nUlrike | \nNone | \nA'field | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
1 | \nRegenceAdultPharmacyCoverageTxnl | \n69487427716038 | \n6558692381 | \n5257890360 | \n93 | \n73038293802946 | \nH | \nMichel | \nNone | \nCarpenter | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
2 | \nRegenceAdultPharmacyCoverageTxnl | \n82073805599275 | \n0892986118 | \n7105369331 | \n07 | \n35163472420431 | \nD | \nJuana | \nNone | \nBland | \n... | \nTrue | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
3 | \nRegenceAdultPharmacyCoverageTxnl | \n94580767415591 | \n3718649253 | \n6165626172 | \n38 | \n44064968284475 | \nH | \nCatlaina | \nNone | \nGately | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
4 | \nRegenceAdultPharmacyCoverageTxnl | \n47013240258809 | \n3421311723 | \n7374219815 | \n67 | \n04121936530044 | \nH | \nGothart | \nNone | \nPitcaithley | \n... | \nFalse | \nTrue | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
5 | \nRegenceAdultPharmacyCoverageTxnl | \n36105278670472 | \n6182759970 | \n9577234264 | \n24 | \n24866925384705 | \nH | \nRickie | \nNone | \nHillen | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
6 | \nRegenceAdultMDLiveOptIn | \n91242873208245 | \n6868979636 | \n8483095501 | \n91 | \n65845708514901 | \nM | \nAlford | \nNone | \nMcEvilly | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
7 | \nRegenceAdultPharmacyCoverageTxnl | \n12908099647515 | \n2221239308 | \n0228976106 | \n03 | \n58783701003457 | \nW | \nAllyson | \nJ | \nSiviter | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
8 | \nRegenceAdultPharmacyCoverageTxnl | \n27621691403989 | \n1498190027 | \n3574771440 | \n28 | \n02075307471196 | \nH | \nPutnam | \nY | \nMcGahey | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
9 | \nRegenceAdultPharmacyCoverageTxnl | \n56810067198517 | \n2184157635 | \n5619604343 | \n05 | \n41046278389295 | \nH | \nBarny | \nQ | \nBalbeck | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
10 | \nRegenceAdultPharmacyCoverageTxnl | \n82741017886283 | \n5966740469 | \n5597884700 | \n18 | \n35383543619042 | \nH | \nReine | \nW | \nHoward - Gater | \n... | \nTrue | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
11 | \nRegenceAdultPharmacyCoverageTxnl | \n63965048576031 | \n7291520878 | \n0257547294 | \n91 | \n98519729126149 | \nD | \nFindley | \nNone | \nAdriani | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
12 | \nRegenceAdultPharmacyCoverageTxnl | \n96046951836118 | \n0984409704 | \n7100095923 | \n92 | \n06329302570939 | \nH | \nTeresina | \nNone | \nHaysham | \n... | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
13 | \nRegenceAdultPharmacyCoverageTxnl | \n96853587791352 | \n7920488328 | \n5298623102 | \n89 | \n90355163147841 | \nH | \nEnglebert | \nNone | \nJenkison | \n... | \nTrue | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
14 | \nRegenceAdultPharmacyCoverageTxnl | \n87881965900100 | \n0452571454 | \n2624826549 | \n31 | \n19756462906183 | \nH | \nMia | \nNone | \nLamps | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
15 | \nRegenceAdultPharmacyCoverageTxnl | \n00198005473687 | \n5303180233 | \n2549137552 | \n98 | \n17037862751728 | \nD | \nRahal | \nNone | \nPickwell | \n... | \nTrue | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
16 | \nRegenceAdultPharmacyCoverageTxnl | \n49830224836936 | \n3153457413 | \n4092630304 | \n95 | \n44808842091335 | \nD | \nFranklyn | \nI | \nCardenosa | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
17 | \nRegenceAdultPharmacyCoverageTxnl | \n45865714799461 | \n5643664893 | \n9796040839 | \n90 | \n42361329697332 | \nH | \nEva | \nC | \nSkeath | \n... | \nFalse | \nTrue | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
18 | \nRegenceAdultEmailOptIn | \n81566866554534 | \n5908885006 | \n9680412985 | \n38 | \n38743151603177 | \nH | \nMerry | \nS | \nWakeley | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
19 | \nRegenceAdultPharmacyCoverageTxnl | \n62494769799878 | \n3804160262 | \n5491405553 | \n96 | \n55531871740225 | \nS | \nMorgan | \nK | \nFryatt | \n... | \nTrue | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
20 | \nRegenceAdultPharmacyCoverageTxnl | \n08604141830782 | \n5359515283 | \n6228149943 | \n04 | \n56067544460635 | \nS | \nGus | \nZ | \nWicklen | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
21 | \nRegenceAdultPharmacyCoverageTxnl | \n79533604493924 | \n0382294830 | \n0151240351 | \n29 | \n02418535496961 | \nH | \nForbes | \nG | \nEaseman | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
22 | \nRegenceAdultPharmacyCoverageTxnl | \n28895861097260 | \n9913150692 | \n2376193475 | \n78 | \n07221455989541 | \nH | \nDonica | \nNone | \nSemens | \n... | \nFalse | \nTrue | \nFalse | \nFalse | \nFalse | \nTrue | \nTrue | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
23 | \nRegenceAdultPharmacyCoverageTxnl | \n21631079206200 | \n2615763580 | \n0545802358 | \n98 | \n09791925005799 | \nS | \nTadeo | \nG | \nPotapczuk | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
24 | \nRegenceAdultEmailOptIn | \n07289743715805 | \n1777712578 | \n4100647636 | \n77 | \n82528196191966 | \nS | \nChere | \nN | \nMyerscough | \n... | \nFalse | \nTrue | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
25 | \nRegenceAdultEmailOptIn | \n96318241903685 | \n6498633985 | \n0594199555 | \n25 | \n84188761071744 | \nS | \nJess | \nNone | \nFurman | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
26 | \nRegenceAdultPharmacyCoverageTxnl | \n25485899975851 | \n4913104662 | \n3945182083 | \n01 | \n18104879660747 | \nD | \nGigi | \nNone | \nGabbitis | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
27 | \nRegenceAdultMDLiveOptIn | \n50366562224080 | \n8320415938 | \n7253096824 | \n28 | \n47392052104097 | \nH | \nJason | \nI | \nAntognazzi | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
28 | \nRegenceAdultPharmacyCoverageTxnl | \n98844094066556 | \n9001032201 | \n5139590483 | \n10 | \n63667147677376 | \nD | \nArlina | \nL | \nBillingsly | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
29 | \nRegenceAdultPharmacyCoverageTxnl | \n96246797008963 | \n1183520210 | \n8514279203 | \n70 | \n05520283320336 | \nD | \nNell | \nP | \nCreboe | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n
403 | \nRegenceAdultPharmacyCoverageTxnl | \n78500631042211 | \n2326804636 | \n9654659629 | \n21 | \n67360199467388 | \nH | \nRockie | \nNone | \nFletham | \n... | \nFalse | \nTrue | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
404 | \nRegenceAdultEmailOptIn | \n39721127858849 | \n6673997571 | \n9064979036 | \n20 | \n00242281279613 | \nD | \nRowe | \nZ | \nBezarra | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
405 | \nRegenceAdultPharmacyCoverageTxnl | \n00566575723998 | \n3061488711 | \n3671437816 | \n17 | \n26971807012824 | \nD | \nArlan | \nI | \nBrattan | \n... | \nFalse | \nTrue | \nFalse | \nTrue | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
406 | \nRegenceAdultPharmacyCoverageTxnl | \n34378618947410 | \n2357457322 | \n5601354872 | \n38 | \n78025799576746 | \nS | \nSaw | \nNone | \nAndreini | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
407 | \nRegenceAdultPharmacyCoverageTxnl | \n68510964099941 | \n2809659905 | \n9402144174 | \n04 | \n85804904378901 | \nD | \nCamilla | \nNone | \nWaine | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
408 | \nRegenceAdultPharmacyCoverageTxnl | \n96720005126182 | \n6305413261 | \n9849714911 | \n10 | \n83079125682318 | \nM | \nVitia | \nNone | \nSimionato | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
409 | \nRegenceAdultEmailOptIn | \n97079840204532 | \n4270231588 | \n6742809459 | \n07 | \n16959189967794 | \nH | \nGerrilee | \nZ | \nChasle | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
410 | \nRegenceAdultEmailOptIn | \n15916964806196 | \n8646176079 | \n9587147994 | \n20 | \n41295960926233 | \nH | \nOphelia | \nM | \nPittet | \n... | \nFalse | \nTrue | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
411 | \nRegenceAdultPharmacyCoverageTxnl | \n36866352465980 | \n5569581346 | \n5703877810 | \n14 | \n13203225927319 | \nH | \nElane | \nU | \nLackemann | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
412 | \nRegenceAdultEmailOptIn | \n30828262492572 | \n7207762059 | \n5333015264 | \n56 | \n38466843254622 | \nH | \nMalvina | \nI | \nCurtois | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
413 | \nRegenceAdultEmailOptIn | \n37648490633581 | \n1795136457 | \n6543868724 | \n12 | \n67297270078361 | \nH | \nSherm | \nNone | \nScotchmoor | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
414 | \nRegenceAdultEmailOptIn | \n26311452021332 | \n8504505732 | \n6007472997 | \n91 | \n60218933234159 | \nH | \nSampson | \nNone | \nAlvaro | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
415 | \nRegenceAdultPharmacyCoverageTxnl | \n16457646371158 | \n6929480711 | \n5408035244 | \n03 | \n29902238630662 | \nD | \nEwan | \nNone | \nGaukrodge | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
416 | \nRegenceAdultPharmacyCoverageTxnl | \n26030140397385 | \n1212302713 | \n7616183669 | \n17 | \n59847213162089 | \nD | \nRodolphe | \nI | \nGoggey | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
417 | \nRegenceAdultEmailOptIn | \n13471436456243 | \n5145677267 | \n8326641764 | \n34 | \n92573927417617 | \nH | \nPeggi | \nP | \nJepps | \n... | \nFalse | \nTrue | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
418 | \nRegenceAdultPharmacyCoverageTxnl | \n39721127858849 | \n6673997571 | \n9064979036 | \n20 | \n00242281279613 | \nD | \nRowe | \nZ | \nBezarra | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
419 | \nRegenceAdultEmailOptIn | \n70330495634766 | \n3267145924 | \n0035365686 | \n61 | \n51117276711657 | \nH | \nKrista | \nNone | \nBoarleyson | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
420 | \nRegenceAdultPharmacyCoverageTxnl | \n79333306408008 | \n8485508889 | \n2105890588 | \n57 | \n80248342014403 | \nW | \nReed | \nNone | \nGeerits | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
421 | \nRegenceAdultPharmacyCoverageTxnl | \n63986345491265 | \n8965939648 | \n3255205937 | \n71 | \n09818087523794 | \nH | \nHarley | \nNone | \nKhomin | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
422 | \nRegenceAdultEmailOptIn | \n22418313177203 | \n9467145194 | \n9080845729 | \n25 | \n01177174210001 | \nW | \nErek | \nR | \nNorgate | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
423 | \nRegenceAdultMDLiveOptIn | \n44911024655069 | \n1720934434 | \n5192368633 | \n25 | \n92307949874604 | \nS | \nBernardo | \nNone | \nOnians | \n... | \nFalse | \nTrue | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
424 | \nRegenceAdultPharmacyCoverageTxnl | \n62430569669374 | \n6059435847 | \n5726752802 | \n65 | \n83867503595458 | \nH | \nMildrid | \nNone | \nButtel | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
425 | \nRegenceAdultEmailOptIn | \n52672862520659 | \n8332013667 | \n3237820216 | \n23 | \n04246827132295 | \nS | \nGordie | \nNone | \nGronaller | \n... | \nFalse | \nTrue | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
426 | \nRegenceAdultPharmacyCoverageTxnl | \n33126340834310 | \n8304591490 | \n0137650558 | \n45 | \n73849635708117 | \nS | \nRamon | \nF | \nGockelen | \n... | \nTrue | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
427 | \nRegenceAdultPharmacyCoverageTxnl | \n45112650066005 | \n4765895381 | \n7027689265 | \n77 | \n13683617889440 | \nS | \nPolly | \nNone | \nKlausewitz | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
428 | \nRegenceAdultPharmacyCoverageTxnl | \n60992117919161 | \n9331356506 | \n9491034244 | \n12 | \n01184251607796 | \nH | \nHayden | \nD | \nMangeon | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
429 | \nRegenceAdultPharmacyCoverageTxnl | \n64128499032605 | \n2173142409 | \n9646311768 | \n61 | \n94719174082575 | \nW | \nJodi | \nNone | \nLillicrap | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
430 | \nRegenceAdultPharmacyCoverageTxnl | \n45162542976173 | \n1080556500 | \n8225105275 | \n35 | \n68676022174870 | \nH | \nAdlai | \nT | \nMacKenzie | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
431 | \nRegenceAdultPharmacyCoverageTxnl | \n38764461728737 | \n5799244806 | \n7329576809 | \n07 | \n52585456089787 | \nD | \nEster | \nB | \nCouvet | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
432 | \nRegenceAdultEmailOptIn | \n87251346748313 | \n3175338476 | \n1374121884 | \n93 | \n47149869964594 | \nD | \nAlia | \nI | \nSnaddin | \n... | \nFalse | \nFalse | \nFalse | \nFalse | \nFalse | \nTrue | \nFalse | \nFalse | \nr633736 | \n2019-04-04 10:19:27-07:00 | \n
433 rows à 150 columns
\n","text/plain":" segment person_id member_key member_id \\\n0 RegenceAdultEmailOptIn 65136899000654 2187896363 8623056062 \n1 RegenceAdultPharmacyCoverageTxnl 69487427716038 6558692381 5257890360 \n2 RegenceAdultPharmacyCoverageTxnl 82073805599275 0892986118 7105369331 \n3 RegenceAdultPharmacyCoverageTxnl 94580767415591 3718649253 6165626172 \n4 RegenceAdultPharmacyCoverageTxnl 47013240258809 3421311723 7374219815 \n5 RegenceAdultPharmacyCoverageTxnl 36105278670472 6182759970 9577234264 \n6 RegenceAdultMDLiveOptIn 91242873208245 6868979636 8483095501 \n7 RegenceAdultPharmacyCoverageTxnl 12908099647515 2221239308 0228976106 \n8 RegenceAdultPharmacyCoverageTxnl 27621691403989 1498190027 3574771440 \n9 RegenceAdultPharmacyCoverageTxnl 56810067198517 2184157635 5619604343 \n10 RegenceAdultPharmacyCoverageTxnl 82741017886283 5966740469 5597884700 \n11 RegenceAdultPharmacyCoverageTxnl 63965048576031 7291520878 0257547294 \n12 RegenceAdultPharmacyCoverageTxnl 96046951836118 0984409704 7100095923 \n13 RegenceAdultPharmacyCoverageTxnl 96853587791352 7920488328 5298623102 \n14 RegenceAdultPharmacyCoverageTxnl 87881965900100 0452571454 2624826549 \n15 RegenceAdultPharmacyCoverageTxnl 00198005473687 5303180233 2549137552 \n16 RegenceAdultPharmacyCoverageTxnl 49830224836936 3153457413 4092630304 \n17 RegenceAdultPharmacyCoverageTxnl 45865714799461 5643664893 9796040839 \n18 RegenceAdultEmailOptIn 81566866554534 5908885006 9680412985 \n19 RegenceAdultPharmacyCoverageTxnl 62494769799878 3804160262 5491405553 \n20 RegenceAdultPharmacyCoverageTxnl 08604141830782 5359515283 6228149943 \n21 RegenceAdultPharmacyCoverageTxnl 79533604493924 0382294830 0151240351 \n22 RegenceAdultPharmacyCoverageTxnl 28895861097260 9913150692 2376193475 \n23 RegenceAdultPharmacyCoverageTxnl 21631079206200 2615763580 0545802358 \n24 RegenceAdultEmailOptIn 07289743715805 1777712578 4100647636 \n25 RegenceAdultEmailOptIn 96318241903685 6498633985 0594199555 \n26 RegenceAdultPharmacyCoverageTxnl 25485899975851 4913104662 3945182083 \n27 RegenceAdultMDLiveOptIn 50366562224080 8320415938 7253096824 \n28 RegenceAdultPharmacyCoverageTxnl 98844094066556 9001032201 5139590483 \n29 RegenceAdultPharmacyCoverageTxnl 96246797008963 1183520210 8514279203 \n.. ... ... ... ... \n403 RegenceAdultPharmacyCoverageTxnl 78500631042211 2326804636 9654659629 \n404 RegenceAdultEmailOptIn 39721127858849 6673997571 9064979036 \n405 RegenceAdultPharmacyCoverageTxnl 00566575723998 3061488711 3671437816 \n406 RegenceAdultPharmacyCoverageTxnl 34378618947410 2357457322 5601354872 \n407 RegenceAdultPharmacyCoverageTxnl 68510964099941 2809659905 9402144174 \n408 RegenceAdultPharmacyCoverageTxnl 96720005126182 6305413261 9849714911 \n409 RegenceAdultEmailOptIn 97079840204532 4270231588 6742809459 \n410 RegenceAdultEmailOptIn 15916964806196 8646176079 9587147994 \n411 RegenceAdultPharmacyCoverageTxnl 36866352465980 5569581346 5703877810 \n412 RegenceAdultEmailOptIn 30828262492572 7207762059 5333015264 \n413 RegenceAdultEmailOptIn 37648490633581 1795136457 6543868724 \n414 RegenceAdultEmailOptIn 26311452021332 8504505732 6007472997 \n415 RegenceAdultPharmacyCoverageTxnl 16457646371158 6929480711 5408035244 \n416 RegenceAdultPharmacyCoverageTxnl 26030140397385 1212302713 7616183669 \n417 RegenceAdultEmailOptIn 13471436456243 5145677267 8326641764 \n418 RegenceAdultPharmacyCoverageTxnl 39721127858849 6673997571 9064979036 \n419 RegenceAdultEmailOptIn 70330495634766 3267145924 0035365686 \n420 RegenceAdultPharmacyCoverageTxnl 79333306408008 8485508889 2105890588 \n421 RegenceAdultPharmacyCoverageTxnl 63986345491265 8965939648 3255205937 \n422 RegenceAdultEmailOptIn 22418313177203 9467145194 9080845729 \n423 RegenceAdultMDLiveOptIn 44911024655069 1720934434 5192368633 \n424 RegenceAdultPharmacyCoverageTxnl 62430569669374 6059435847 5726752802 \n425 RegenceAdultEmailOptIn 52672862520659 8332013667 3237820216 \n426 RegenceAdultPharmacyCoverageTxnl 33126340834310 8304591490 0137650558 \n427 RegenceAdultPharmacyCoverageTxnl 45112650066005 4765895381 7027689265 \n428 RegenceAdultPharmacyCoverageTxnl 60992117919161 9331356506 9491034244 \n429 RegenceAdultPharmacyCoverageTxnl 64128499032605 2173142409 9646311768 \n430 RegenceAdultPharmacyCoverageTxnl 45162542976173 1080556500 8225105275 \n431 RegenceAdultPharmacyCoverageTxnl 38764461728737 5799244806 7329576809 \n432 RegenceAdultEmailOptIn 87251346748313 3175338476 1374121884 \n\n member_suffix family_member_id member_relative member_first_name \\\n0 29 63770390473738 S Ulrike \n1 93 73038293802946 H Michel \n2 07 35163472420431 D Juana \n3 38 44064968284475 H Catlaina \n4 67 04121936530044 H Gothart \n5 24 24866925384705 H Rickie \n6 91 65845708514901 M Alford \n7 03 58783701003457 W Allyson \n8 28 02075307471196 H Putnam \n9 05 41046278389295 H Barny \n10 18 35383543619042 H Reine \n11 91 98519729126149 D Findley \n12 92 06329302570939 H Teresina \n13 89 90355163147841 H Englebert \n14 31 19756462906183 H Mia \n15 98 17037862751728 D Rahal \n16 95 44808842091335 D Franklyn \n17 90 42361329697332 H Eva \n18 38 38743151603177 H Merry \n19 96 55531871740225 S Morgan \n20 04 56067544460635 S Gus \n21 29 02418535496961 H Forbes \n22 78 07221455989541 H Donica \n23 98 09791925005799 S Tadeo \n24 77 82528196191966 S Chere \n25 25 84188761071744 S Jess \n26 01 18104879660747 D Gigi \n27 28 47392052104097 H Jason \n28 10 63667147677376 D Arlina \n29 70 05520283320336 D Nell \n.. ... ... ... ... \n403 21 67360199467388 H Rockie \n404 20 00242281279613 D Rowe \n405 17 26971807012824 D Arlan \n406 38 78025799576746 S Saw \n407 04 85804904378901 D Camilla \n408 10 83079125682318 M Vitia \n409 07 16959189967794 H Gerrilee \n410 20 41295960926233 H Ophelia \n411 14 13203225927319 H Elane \n412 56 38466843254622 H Malvina \n413 12 67297270078361 H Sherm \n414 91 60218933234159 H Sampson \n415 03 29902238630662 D Ewan \n416 17 59847213162089 D Rodolphe \n417 34 92573927417617 H Peggi \n418 20 00242281279613 D Rowe \n419 61 51117276711657 H Krista \n420 57 80248342014403 W Reed \n421 71 09818087523794 H Harley \n422 25 01177174210001 W Erek \n423 25 92307949874604 S Bernardo \n424 65 83867503595458 H Mildrid \n425 23 04246827132295 S Gordie \n426 45 73849635708117 S Ramon \n427 77 13683617889440 S Polly \n428 12 01184251607796 H Hayden \n429 61 94719174082575 W Jodi \n430 35 68676022174870 H Adlai \n431 07 52585456089787 D Ester \n432 93 47149869964594 D Alia \n\n member_mid_initial member_last_name ... \\\n0 None A'field ... \n1 None Carpenter ... \n2 None Bland ... \n3 None Gately ... \n4 None Pitcaithley ... \n5 None Hillen ... \n6 None McEvilly ... \n7 J Siviter ... \n8 Y McGahey ... \n9 Q Balbeck ... \n10 W Howard - Gater ... \n11 None Adriani ... \n12 None Haysham ... \n13 None Jenkison ... \n14 None Lamps ... \n15 None Pickwell ... \n16 I Cardenosa ... \n17 C Skeath ... \n18 S Wakeley ... \n19 K Fryatt ... \n20 Z Wicklen ... \n21 G Easeman ... \n22 None Semens ... \n23 G Potapczuk ... \n24 N Myerscough ... \n25 None Furman ... \n26 None Gabbitis ... \n27 I Antognazzi ... \n28 L Billingsly ... \n29 P Creboe ... \n.. ... ... ... \n403 None Fletham ... \n404 Z Bezarra ... \n405 I Brattan ... \n406 None Andreini ... \n407 None Waine ... \n408 None Simionato ... \n409 Z Chasle ... \n410 M Pittet ... \n411 U Lackemann ... \n412 I Curtois ... \n413 None Scotchmoor ... \n414 None Alvaro ... \n415 None Gaukrodge ... \n416 I Goggey ... \n417 P Jepps ... \n418 Z Bezarra ... \n419 None Boarleyson ... \n420 None Geerits ... \n421 None Khomin ... \n422 R Norgate ... \n423 None Onians ... \n424 None Buttel ... \n425 None Gronaller ... \n426 F Gockelen ... \n427 None Klausewitz ... \n428 D Mangeon ... \n429 None Lillicrap ... \n430 T MacKenzie ... \n431 B Couvet ... \n432 I Snaddin ... \n\n medicare_part_d metallic_plan ohsu_plus onboarding_campaign_indicator \\\n0 False False False False \n1 False False False False \n2 True False False False \n3 False False False False \n4 False True False False \n5 False False False False \n6 False False False False \n7 False False False False \n8 False False False False \n9 False False False False \n10 True False False False \n11 False False False False \n12 False False False True \n13 True False False False \n14 False False False False \n15 True False False False \n16 False False False False \n17 False True False False \n18 False False False False \n19 True False False False \n20 False False False False \n21 False False False False \n22 False True False False \n23 False False False False \n24 False True False False \n25 False False False False \n26 False False False False \n27 False False False False \n28 False False False False \n29 False False False False \n.. ... ... ... ... \n403 False True False False \n404 False False False False \n405 False True False True \n406 False False False False \n407 False False False False \n408 False False False False \n409 False False False False \n410 False True False False \n411 False False False False \n412 False False False False \n413 False False False False \n414 False False False False \n415 False False False False \n416 False False False False \n417 False True False False \n418 False False False False \n419 False False False False \n420 False False False False \n421 False False False False \n422 False False False False \n423 False True False False \n424 False False False False \n425 False True False False \n426 True False False False \n427 False False False False \n428 False False False False \n429 False False False False \n430 False False False False \n431 False False False False \n432 False False False False \n\n paperless pharmacy_coverage self_funded_groups uniform_medical_plan_wa \\\n0 False False False False \n1 False True False False \n2 False True False False \n3 False True False False \n4 False True False False \n5 False True False False \n6 False True False False \n7 False True False False \n8 False True False False \n9 False True False False \n10 False True False False \n11 False True False False \n12 False True False False \n13 False True False False \n14 False True False False \n15 False True False False \n16 False True False False \n17 False True False False \n18 False True False False \n19 False True False False \n20 False True False False \n21 False True False False \n22 False True True False \n23 False True False False \n24 False False False False \n25 False False False True \n26 False True False False \n27 False False False False \n28 False True False False \n29 False True False False \n.. ... ... ... ... \n403 False True False False \n404 False True False False \n405 False True False False \n406 False True False False \n407 False True False False \n408 False True False False \n409 False False False False \n410 False False False False \n411 False True False False \n412 False True False False \n413 False False False False \n414 False False False False \n415 False True False False \n416 False True False False \n417 False False False False \n418 False True False False \n419 False False False False \n420 False True False False \n421 False True False False \n422 False False False False \n423 False False True False \n424 False True False False \n425 False False False False \n426 False True False False \n427 False True False False \n428 False True False False \n429 False True False False \n430 False True False False \n431 False True False False \n432 False True False False \n\n created_by created_time \n0 r633736 2019-04-04 10:19:27-07:00 \n1 r633736 2019-04-04 10:19:27-07:00 \n2 r633736 2019-04-04 10:19:27-07:00 \n3 r633736 2019-04-04 10:19:27-07:00 \n4 r633736 2019-04-04 10:19:27-07:00 \n5 r633736 2019-04-04 10:19:27-07:00 \n6 r633736 2019-04-04 10:19:27-07:00 \n7 r633736 2019-04-04 10:19:27-07:00 \n8 r633736 2019-04-04 10:19:27-07:00 \n9 r633736 2019-04-04 10:19:27-07:00 \n10 r633736 2019-04-04 10:19:27-07:00 \n11 r633736 2019-04-04 10:19:27-07:00 \n12 r633736 2019-04-04 10:19:27-07:00 \n13 r633736 2019-04-04 10:19:27-07:00 \n14 r633736 2019-04-04 10:19:27-07:00 \n15 r633736 2019-04-04 10:19:27-07:00 \n16 r633736 2019-04-04 10:19:27-07:00 \n17 r633736 2019-04-04 10:19:27-07:00 \n18 r633736 2019-04-04 10:19:27-07:00 \n19 r633736 2019-04-04 10:19:27-07:00 \n20 r633736 2019-04-04 10:19:27-07:00 \n21 r633736 2019-04-04 10:19:27-07:00 \n22 r633736 2019-04-04 10:19:27-07:00 \n23 r633736 2019-04-04 10:19:27-07:00 \n24 r633736 2019-04-04 10:19:27-07:00 \n25 r633736 2019-04-04 10:19:27-07:00 \n26 r633736 2019-04-04 10:19:27-07:00 \n27 r633736 2019-04-04 10:19:27-07:00 \n28 r633736 2019-04-04 10:19:27-07:00 \n29 r633736 2019-04-04 10:19:27-07:00 \n.. ... ... \n403 r633736 2019-04-04 10:19:27-07:00 \n404 r633736 2019-04-04 10:19:27-07:00 \n405 r633736 2019-04-04 10:19:27-07:00 \n406 r633736 2019-04-04 10:19:27-07:00 \n407 r633736 2019-04-04 10:19:27-07:00 \n408 r633736 2019-04-04 10:19:27-07:00 \n409 r633736 2019-04-04 10:19:27-07:00 \n410 r633736 2019-04-04 10:19:27-07:00 \n411 r633736 2019-04-04 10:19:27-07:00 \n412 r633736 2019-04-04 10:19:27-07:00 \n413 r633736 2019-04-04 10:19:27-07:00 \n414 r633736 2019-04-04 10:19:27-07:00 \n415 r633736 2019-04-04 10:19:27-07:00 \n416 r633736 2019-04-04 10:19:27-07:00 \n417 r633736 2019-04-04 10:19:27-07:00 \n418 r633736 2019-04-04 10:19:27-07:00 \n419 r633736 2019-04-04 10:19:27-07:00 \n420 r633736 2019-04-04 10:19:27-07:00 \n421 r633736 2019-04-04 10:19:27-07:00 \n422 r633736 2019-04-04 10:19:27-07:00 \n423 r633736 2019-04-04 10:19:27-07:00 \n424 r633736 2019-04-04 10:19:27-07:00 \n425 r633736 2019-04-04 10:19:27-07:00 \n426 r633736 2019-04-04 10:19:27-07:00 \n427 r633736 2019-04-04 10:19:27-07:00 \n428 r633736 2019-04-04 10:19:27-07:00 \n429 r633736 2019-04-04 10:19:27-07:00 \n430 r633736 2019-04-04 10:19:27-07:00 \n431 r633736 2019-04-04 10:19:27-07:00 \n432 r633736 2019-04-04 10:19:27-07:00 \n\n[433 rows x 150 columns]"},"execution_count":5,"metadata":{},"output_type":"execute_result"}],"source":"engine = get_database_engine(parm_df)\nresult = engine.execute(sa.text(data_select)).fetchall()\ncolumn_list = engine.execute(sa.text(metadata_select)).fetchall()\ncolumn_list_final = ['segment'] + [col[0] for col in column_list] \n#column_list_final = [col[0] for col in column_list] \nresult_df = pd.DataFrame.from_records(result, columns = column_list_final)\nfor column in result_df.columns:\n result_df[column] = result_df[column].astype(str)\n#for column in ['member_birth_date', 'member_create_date', 'member_effective_date', 'member_end_date',\n# 'member_previous_end_date', 'created_time']:\n# result_df[column] = result_df[column].dt.strftime('%Y-%m-%d %H:%M:%S').astype(str)\n#print(result_df.dtypes)\nAlteryx.write(result_df,1)"},{"cell_type":"code","execution_count":null,"metadata":{"trusted":false},"outputs":[],"source":""}],"metadata":{"kernelspec":{"display_name":"Python 3","language":"python","name":"python3"},"language_info":{"codemirror_mode":{"name":"ipython","version":3},"file_extension":".py","mimetype":"text/x-python","name":"python","nbconvert_exporter":"python","pygments_lexer":"ipython3","version":"3.6.0"}},"nbformat":4,"nbformat_minor":2}]]>