In [57]:
# Configure the necessary Spark environment
import os
os.environ['SPARK_HOME'] = '/opt/spark/'

# And Python path
import sys
sys.path.insert(0, '/opt/spark/python')
sys.path.insert(0, os.path.join('/opt/spark/', 'python/lib/py4j-0.8.2.1-src.zip'))

# connect to spark
from pyspark import SparkContext, SparkConf
# sc is an existing SparkContext.
from pyspark.sql import SQLContext, Row

# Detect the PySpark URL
CLUSTER_URL = 'spark://alton1:7077'
#CLUSTER_URL = 'local'

In [59]:
# disconnect if already connected
sc.stop()

# connect to spark with 3.5GB of ram per node
sconf = SparkConf()
conf = (SparkConf().setMaster(CLUSTER_URL)
    .setAppName("ipython-2.5g")
    .set("spark.executor.memory", "2500m"))
sc = SparkContext(conf=conf)

sqlContext = SQLContext(sc)

In [47]:
# Load a text file and convert each line to a Row.
lines = sc.textFile("hdfs://alton1:9000/appreciation/raw-data/fact_recognition.csv")

In [30]:
parts = lines.map(lambda l: l.split(","))
people = parts.map(lambda p: Row(key=int(p[0]), 
                                 nomination_nominee_id=int(p[1]),
                                 eproduct_recipient_id=p[2],
                                 user_transaction_id=p[3],
                                 reward_code_id=p[4],
                                 customer_sold_to_party_nbr=p[5],
                                 program_key=p[6],
                                 PROGRAM_NAME=p[7],
                                 al_award_level_key=p[8],
                                 al_AWARD_LEVEL_NAME=p[9],
                                 rl_award_level_key=p[10],
                                 rl_award_level_name=p[11],
                                 RECOGNITION_STATUS_KEY=p[12],
                                 RECOGNITION_STATUS_NAME=p[13],
                                 issued_date_key=p[14],
                                 CANCELLED_DATE_KEY=p[15],
                                 declined_date_key=p[16],
                                 recognition_date_key=p[17],
                                 final_approval_date_key=p[18],
                                 giver_user_key=p[19],
                                 RECEIVER_USER_KEY=p[20],
                                 PROXY_GIVER_USER_KEY=p[21],
                                 GBU_BUSINESS_UNIT_ID=p[22],
                                 GBU_BUSINESS_UNIT_NAME=p[23],
                                 GBU_PARENT_BUSINESS_UNIT_ID=p[24],
                                 RBU_BUSINESS_UNIT_ID=p[25],
                                 RBU_BUSINESS_UNIT_NAME=p[26],
                                 RBU_PARENT_BUSINESS_UNIT_ID=p[27],
                                 PBU_BUSINESS_UNIT_ID=p[28],
                                 PBU_BUSINESS_UNIT_NAME=p[29],
                                 PBU_PARENT_BUSINESS_UNIT_ID=p[30],
                                 days_to_approve=p[31],
                                 points_value=p[32],
                                 GA_ACTIVITY_ID=p[33],
                                 GA_ACTIVITY_DESCR=p[34],
                                 ra_activity_id=p[35],
                                 ra_activity_descr=p[36]
                                 )
                   )

# Infer the schema, and register the DataFrame as a table.
schemaPeople = sqlContext.inferSchema(people)
schemaPeople.registerTempTable("recognition")

In [31]:
# how many recognitions do we have?
sqlContext.sql("SELECT count(*) FROM recognition").collect()


Out[31]:
[Row(c0=39718092)]

In [32]:
# what are the top programs?
PROGRAM_NAMES = sqlContext.sql("SELECT count(*), PROGRAM_NAME name FROM recognition group by PROGRAM_NAME")

In [35]:
PROGRAM_NAMES.collect()


Out[35]:
[Row(c0=6698, name=u'"Hands on Excellence"'),
 Row(c0=719850, name=u'"Celebrate Excellence"'),
 Row(c0=42256, name=u'"Recognize Results"'),
 Row(c0=14134, name=u'"Shine"'),
 Row(c0=428, name=u'"Sales Rewards/Non-SIP"'),
 Row(c0=138, name=u'"Claritas Sales Rewards"'),
 Row(c0=4456, name=u'"On The Spot"'),
 Row(c0=6, name=u'"Wright"'),
 Row(c0=20, name=u'"Alireza Mahmoodshahi Innovation Award"'),
 Row(c0=4, name=u'"Hollister"'),
 Row(c0=24990, name=u'"Recognition"'),
 Row(c0=12386, name=u'"Small Spot"'),
 Row(c0=78926, name=u'"Excellence In Action"'),
 Row(c0=2562, name=u'"Gerdau Performance in Sales"'),
 Row(c0=26050, name=u'"Send an eCard or eButton"'),
 Row(c0=316242, name=u'"Spot Awards"'),
 Row(c0=19706, name=u'"Praising Effort"'),
 Row(c0=7210, name=u'"See Raise Win"'),
 Row(c0=88214, name=u'"WOW Sales"'),
 Row(c0=214, name=u'"Bravo"'),
 Row(c0=28, name=u'"INDIA Reward Results"'),
 Row(c0=11392, name=u'"ACE Award"'),
 Row(c0=38, name=u'"eThanks!"'),
 Row(c0=416, name=u'"Points"'),
 Row(c0=27420, name=u'"Spark Awards"'),
 Row(c0=464640, name=u'"Hi5"'),
 Row(c0=2528, name=u'"Manager\'s ALLstar"'),
 Row(c0=300940, name=u'"My Wellness"'),
 Row(c0=22, name=u'"CIS or CIM Nominations"'),
 Row(c0=129788, name=u'"eThanks"'),
 Row(c0=246, name=u'"Glorious Codes"'),
 Row(c0=24, name=u'"Second Access Codes"'),
 Row(c0=4, name=u'"Chaiman\'s Test"'),
 Row(c0=876, name=u'"Legendary Acts"'),
 Row(c0=982384, name=u'"Milestone Celebration"'),
 Row(c0=260, name=u'"President\'s Awards ? GBG"'),
 Row(c0=1648, name=u'"UxL"'),
 Row(c0=1478, name=u'"CFO Pinnacle Award"'),
 Row(c0=1866, name=u'"Total Rewards"'),
 Row(c0=1082, name=u'"Enduring Value"'),
 Row(c0=4, name=u'"GABM (Do Not Use)"'),
 Row(c0=32, name=u'"Client Compliments Test"'),
 Row(c0=69176, name=u'"STAR"'),
 Row(c0=36766, name=u'"Bravo!"'),
 Row(c0=59706, name=u'"US Nominee - H.E.A.R.T. & eThanks"'),
 Row(c0=120034, name=u'"Thanks-A-Lotto"'),
 Row(c0=58108, name=u'"Above N Beyond"'),
 Row(c0=36452, name=u'"ACE Awards"'),
 Row(c0=3526, name=u'"3 Diamond"'),
 Row(c0=3778, name=u'"Diamond Keepsake"'),
 Row(c0=8408, name=u'"Difference Maker"'),
 Row(c0=298, name=u'"President\'s Awards ? CCSG"'),
 Row(c0=1812, name=u'"Inner Circle Award"'),
 Row(c0=164, name=u'"Notice Efforts"'),
 Row(c0=738, name=u'"Celebrating Loyalty"'),
 Row(c0=413422, name=u'"Recognize Great Work"'),
 Row(c0=938, name=u'"President\'s Awards- CPS"'),
 Row(c0=212, name=u'"October Test 1"'),
 Row(c0=5028, name=u'"appreciateYOU"'),
 Row(c0=373596, name=u'"Above and Beyond"'),
 Row(c0=4086, name=u'"Voice of Success"'),
 Row(c0=126, name=u'"Demo Reward Results"'),
 Row(c0=382414, name=u'"Everyday Appreciation"'),
 Row(c0=346, name=u'"Division Function Stock Awards"'),
 Row(c0=954, name=u'"President\'s Awards - GMS"'),
 Row(c0=53332, name=u'"eStar Cards & Recognition"'),
 Row(c0=7418, name=u'"SHINE Awards"'),
 Row(c0=2710, name=u'"Monthly ACE Team Award"'),
 Row(c0=4042, name=u'"Appreciation Station"'),
 Row(c0=19832, name=u'"Reward Results "'),
 Row(c0=73824, name=u'"Notice Effort-Reward Results"'),
 Row(c0=2439346, name=u'"Unknown"'),
 Row(c0=147470, name=u'"STAR (Special Thanks and Recognition)"'),
 Row(c0=9667726, name=u'"Praise Effort"'),
 Row(c0=20, name=u'"Homer Awards"'),
 Row(c0=2622, name=u'"WOW Performance"'),
 Row(c0=3212, name=u'"Attendance Awards"'),
 Row(c0=422, name=u'"Living the Ventura Edge"'),
 Row(c0=4298, name=u'"P42 Congratulations"'),
 Row(c0=839912, name=u'"Points Program"'),
 Row(c0=6094, name=u'"Our Great Work Administrator"'),
 Row(c0=19654, name=u'"Awesome Job"'),
 Row(c0=828, name=u'"Great work"'),
 Row(c0=19658, name=u'"Together We Lead and Learn"'),
 Row(c0=198, name=u'"Channel Awards"'),
 Row(c0=6, name=u'"President\'s Awards - CCSG"'),
 Row(c0=355154, name=u'"Rewards of Excellence"'),
 Row(c0=1408, name=u'"Encore"'),
 Row(c0=4048, name=u'"Miraca Values Player"'),
 Row(c0=11408, name=u'"Thanks And Recognition"'),
 Row(c0=5572, name=u'"Peer Power"'),
 Row(c0=24616, name=u'"Driving Success"'),
 Row(c0=29396, name=u'"Well with US"'),
 Row(c0=26498, name=u'"E MAX"'),
 Row(c0=19010, name=u'"Pinnacle"'),
 Row(c0=368, name=u'"Engineering Achievement Awards"'),
 Row(c0=78798, name=u'"Safety Excellence"'),
 Row(c0=106672, name=u'"Reward Great Work"'),
 Row(c0=298810, name=u'"Recognizing Great Work"'),
 Row(c0=150, name=u'"Access Code Program"'),
 Row(c0=1502, name=u'"Celebrations"'),
 Row(c0=1522776, name=u'"Notice Effort"'),
 Row(c0=4285552, name=u'"Appreciate Effort"'),
 Row(c0=394, name=u'"GABM CMO Award"'),
 Row(c0=46, name=u'"Performance Awards"'),
 Row(c0=6534, name=u'"BRAVO"'),
 Row(c0=152082, name=u'"grady recognition"'),
 Row(c0=65704, name=u'"RPS Rewards"'),
 Row(c0=10106, name=u'"Recognize Someone"'),
 Row(c0=23868, name=u'"Impact Awards"'),
 Row(c0=78, name=u'"Appreciation Station DO NOT USE"'),
 Row(c0=36, name=u'"Great Work2"'),
 Row(c0=25864, name=u'"Celebrate Loyalty"'),
 Row(c0=15160, name=u'"Spotlight On Success"'),
 Row(c0=16, name=u'"Lely Test Program"'),
 Row(c0=33738, name=u'"RewardYou"'),
 Row(c0=2560, name=u'"Cheers4Peers"'),
 Row(c0=370, name=u'"Submit CIS Nomination"'),
 Row(c0=43208, name=u'"Aspire Higher Appreciation "'),
 Row(c0=26492, name=u'"Volunteer Rewards"'),
 Row(c0=24, name=u'"Access Codes"'),
 Row(c0=12, name=u'"Award of Excellence"'),
 Row(c0=710, name=u'"CEO New Hire and 6 Month Award"'),
 Row(c0=28, name=u'"Campus Recruiting"'),
 Row(c0=1000, name=u'"Way to Go"'),
 Row(c0=54, name=u'"Points Program "'),
 Row(c0=24, name=u'"Points Campus Recruiting "'),
 Row(c0=408, name=u'"President\'s Awards - GNS & GNB"'),
 Row(c0=5064, name=u'"August Test"'),
 Row(c0=16, name=u'"Spotlight on Excellence Access Code"'),
 Row(c0=6370, name=u'"All the Best"'),
 Row(c0=1590, name=u'"Customer Star Awards"'),
 Row(c0=36, name=u'"Access-Code"'),
 Row(c0=54378, name=u'"You Make the Difference"'),
 Row(c0=58, name=u'"On The Spot Access Code program with 40c"'),
 Row(c0=522, name=u'"Hall of Fame"'),
 Row(c0=108346, name=u'"Celebrate Great Work"'),
 Row(c0=758, name=u'"Outstanding Achievement"'),
 Row(c0=50, name=u'"President\'s Awards - GBG"'),
 Row(c0=72, name=u'"RB Data Cleanup"'),
 Row(c0=606, name=u'"Enduring Partnerships"'),
 Row(c0=8712, name=u'"Moments of Excellence"'),
 Row(c0=17174, name=u'"Appreciation Central"'),
 Row(c0=478016, name=u'"Appreciate"'),
 Row(c0=36058, name=u'"Recognition Share Award"'),
 Row(c0=61024, name=u'"Heart and Soul"'),
 Row(c0=22544, name=u'"Rewarding Results"'),
 Row(c0=1322, name=u'"SIR-PAS Awards"'),
 Row(c0=6600, name=u'"eCards & eButtons"'),
 Row(c0=738, name=u'"Recognize & Appreciate"'),
 Row(c0=43392, name=u'"Reward Results Points"'),
 Row(c0=1696, name=u'"RIM Excellence Award"'),
 Row(c0=19252, name=u'"Thank a Banker"'),
 Row(c0=17724, name=u'"Above & Beyond"'),
 Row(c0=346, name=u'"Appreciation"'),
 Row(c0=3548, name=u'"INFAstar"'),
 Row(c0=25866, name=u'"Honour The Best"'),
 Row(c0=254, name=u'"Chairman\'s Awards"'),
 Row(c0=188756, name=u'"Applause"'),
 Row(c0=96, name=u'"Great Work "'),
 Row(c0=7846, name=u'"SuperQualstar"'),
 Row(c0=6074, name=u'"I-LIFT"'),
 Row(c0=17728, name=u'"Quality Awards"'),
 Row(c0=12616, name=u'"On the Spot"'),
 Row(c0=36600, name=u'"RB Deposit"'),
 Row(c0=13384, name=u'"Ignite the Exceptional"'),
 Row(c0=14946, name=u'"eXceed"'),
 Row(c0=55374, name=u'"The Spirit Of Flowserve"'),
 Row(c0=5110, name=u'"Shout Out"'),
 Row(c0=14, name=u'"President\'s Awards - S&BT"'),
 Row(c0=10246, name=u'"Recognize Excellence"'),
 Row(c0=11350, name=u'"Special Honors"'),
 Row(c0=20, name=u'"H.E.A.R.T"'),
 Row(c0=252492, name=u'"Our Great Work"'),
 Row(c0=385226, name=u'"Healthy Points"'),
 Row(c0=7438, name=u'"Recognize Effort"'),
 Row(c0=49264, name=u'"Performance"'),
 Row(c0=5468, name=u'"Canadian Photography Achievement Program"'),
 Row(c0=158, name=u'"Excellence in Action"'),
 Row(c0=2720, name=u'"President\'s Awards - GNICS"'),
 Row(c0=423932, name=u'"Qualstar"'),
 Row(c0=162, name=u'"Our Way"'),
 Row(c0=242, name=u'"Great Work Access Code"'),
 Row(c0=1868, name=u'"Champions for Children"'),
 Row(c0=2030, name=u'"Send E-Thank You Card"'),
 Row(c0=1240, name=u'"Enterprise Growth Pinnacle Award"'),
 Row(c0=2, name=u'"Reward Rewards"'),
 Row(c0=1046, name=u'"HR Pinnacle Award"'),
 Row(c0=30900, name=u'"Safety"'),
 Row(c0=114, name=u'"Recognizing Courageous Integrity"'),
 Row(c0=101370, name=u'"Moments of Thanks"'),
 Row(c0=71410, name=u'"Elite Officer Membership Club"'),
 Row(c0=38624, name=u'"Celebrate Milestones"'),
 Row(c0=1252, name=u'"Contact Center Points"'),
 Row(c0=448220, name=u'"FIS is You"'),
 Row(c0=2, name=u'"CEO Awards"'),
 Row(c0=441578, name=u'"Appreciate Great Work"'),
 Row(c0=144, name=u'"Test Program"'),
 Row(c0=3976, name=u'"Non-US Nominee - H.E.A.R.T. & eThanks"'),
 Row(c0=3930, name=u'" Ideas"'),
 Row(c0=4710, name=u'"Voice of Support"'),
 Row(c0=16656, name=u'"Prod Program"'),
 Row(c0=652, name=u'"Testing Budget & ERM Reports"'),
 Row(c0=7428, name=u'"Special Thanks"'),
 Row(c0=132, name=u'"President\'s Awards- DPD"'),
 Row(c0=450, name=u'"President\'s Awards - OPEN"'),
 Row(c0=266, name=u'"Point Awards"'),
 Row(c0=4696, name=u'"Exceptional Performance"'),
 Row(c0=13990, name=u'"Recognise Milestones"'),
 Row(c0=142, name=u'"Experts in Action"'),
 Row(c0=44934, name=u'"Recognize Achievements"'),
 Row(c0=502, name=u'"President\'s Awards- India Business"'),
 Row(c0=4, name=u'"Program Ashley Badger"'),
 Row(c0=31014, name=u'"Recognizing Excellence"'),
 Row(c0=42, name=u'"Kaye Test"'),
 Row(c0=18630, name=u'"Client Compliments"'),
 Row(c0=86, name=u'"Bravo Points!"'),
 Row(c0=10, name=u'"You Rocked It!"'),
 Row(c0=838, name=u'"Ovation"'),
 Row(c0=63926, name=u'"Aspire Higher Appreciation"'),
 Row(c0=2290, name=u'"SuperStar"'),
 Row(c0=1686, name=u'"CIS or Employee of the QTR"'),
 Row(c0=4, name=u'"Test Program "'),
 Row(c0=71358, name=u'"Say Thanks"'),
 Row(c0=532, name=u'"FIS is You Test"'),
 Row(c0=570, name=u'"President\'s Award"'),
 Row(c0=5960, name=u'"Get STARted"'),
 Row(c0=27340, name=u'"Safety First"'),
 Row(c0=1210, name=u'"BRAVO Finalist"'),
 Row(c0=60, name=u'"RewardYou Test"'),
 Row(c0=2146, name=u'"The Palm Awards"'),
 Row(c0=6120, name=u'"Praise Work"'),
 Row(c0=38998, name=u'"W2G"'),
 Row(c0=148808, name=u'"appreciate great work"'),
 Row(c0=10438, name=u'"Health Matters "'),
 Row(c0=496, name=u'"Ring of Honor"'),
 Row(c0=6066, name=u'"Career Achievement"'),
 Row(c0=312, name=u'"Stellar Work"'),
 Row(c0=10202, name=u'"Safe Actions For Everyone"'),
 Row(c0=170, name=u'"Manager of the Year Award"'),
 Row(c0=628, name=u'"Above and Beyond "'),
 Row(c0=88, name=u'"Employee Recognition Program"'),
 Row(c0=35976, name=u'"#applause"'),
 Row(c0=91520, name=u'"Cape Safety Program"'),
 Row(c0=14, name=u'"Celebrating Milestones"'),
 Row(c0=6100, name=u'"Top Achiever Cash Awards"'),
 Row(c0=1310, name=u'"Celebrate Your Career Milestone"'),
 Row(c0=294068, name=u'"WeAppreciate"'),
 Row(c0=9573810, name=u'"Reward Results"'),
 Row(c0=240, name=u'"Recognising You"'),
 Row(c0=196116, name=u'"Great Work"'),
 Row(c0=32676, name=u'"The NorthBay Way"')]

In [37]:
# recognition status
RECOGNITION_STATUS = sqlContext.sql("SELECT RECOGNITION_STATUS_NAME name, count(*) FROM recognition group by RECOGNITION_STATUS_NAME")

In [38]:
RECOGNITION_STATUS.collect()


Out[38]:
[Row(name=u'0', c1=16),
 Row(name=u'1', c1=2),
 Row(name=u'4', c1=586),
 Row(name=u'5', c1=64),
 Row(name=u'"EXPIRED"', c1=47722),
 Row(name=u'"SAVED"', c1=1364),
 Row(name=u'"SCHEDULED"', c1=24804),
 Row(name=u'"DEPOSITED"', c1=13048180),
 Row(name=u'"Unknown"', c1=912612),
 Row(name=u'000 Cash Award"', c1=426),
 Row(name=u'"CANCELLED"', c1=6024),
 Row(name=u'"RECEIVED"', c1=19418628),
 Row(name=u'000 Blue Awards"', c1=15728),
 Row(name=u'"COMPLETED"', c1=295654),
 Row(name=u'14', c1=4),
 Row(name=u'15', c1=58),
 Row(name=u'"ISSUED"', c1=5326226),
 Row(name=u'"DECLINED"', c1=245516),
 Row(name=u'500 Points"', c1=1122),
 Row(name=u'29', c1=84),
 Row(name=u'000 Points"', c1=3512),
 Row(name=u'000"', c1=84),
 Row(name=u'500 points"', c1=110),
 Row(name=u'"PENDING"', c1=357846),
 Row(name=u'000 points"', c1=14),
 Row(name=u'30', c1=11706)]

Users


In [76]:
# Load a text file and convert each line to a Row.
lines = sc.textFile("hdfs://alton1:9000/appreciation/raw-data/dim_user.csv").cache()

In [111]:
# print any row that doesn't have enough commas
counts = lines.map(lambda l: (len(l.split(',')), l)).cache()
# remove those rows from the users table
print counts.keys().min()
print counts.keys().max()


print counts.first()


8
13
(12, u'146,72371,"TERMINATED",20100518,,"terminated","0001305356",,6379,"Y",20141114,90001231                                  ')

In [102]:
# remove the ones that are too short!
print counts.count()
counts.keys().filter(lambda x: x < 12).count()


40086928
Out[102]:
4276

In [113]:
counts.filter(lambda x: x[0] < 12).take(20)


Out[113]:
[(11,
  u'19897894,2363413,"ACTIVE",20121118,,"manager and above - consulting (m1)","0001444278",2364096,70455,"Y",20130          '),
 (11,
  u'19897903,2363461,"ACTIVE",20111006,,"manager and above - consulting (m1)","0001444278",2364383,70720,"N",20140          '),
 (11,
  u'19897904,2363461,"ACTIVE",20111006,,"manager and above - consulting (m1)","0001444278",3506187,70720,"N",20141          '),
 (11,
  u'19897905,2363461,"ACTIVE",20111006,,"manager and above - consulting (m1)","0001444278",2363684,70720,"N",20141          '),
 (11,
  u'19897882,2363413,"ACTIVE",20121118,,"manager and above - consulting (m1)","0001444278",2364291,70723,"N",20110          '),
 (11,
  u'19897959,2363461,"ACTIVE",20111006,,"manager and above - consulting (m1)","0001444278",2363523,70720,"Y",20141          '),
 (11,
  u'19897980,2363519,"TERMINATED",20111222,,"manager and above - consulting","0001444278",2363840,70455,"N",201305          '),
 (11,
  u'19897983,2363540,"ACTIVE",20111103,,"manager and above - consulting (m1)","0001444278",2364220,70723,"N",20111          '),
 (11,
  u'19897985,2363540,"ACTIVE",20111103,,"manager and above - consulting (m1)","0001444278",2364220,70723,"N",20120          '),
 (11,
  u'19898414,2364272,"ACTIVE",20120224,,"manager and above - consulting (m1)","0001444278",2363348,70734,"Y",20140          '),
 (11,
  u'19898427,2364364,"ACTIVE",20110906,,"manager and above - consulting (m1)","0001444278",2364035,70733,"N",20110          '),
 (11,
  u'19898428,2364364,"ACTIVE",20110906,,"manager and above - consulting (m1)","0001444278",2364403,70733,"N",20111          '),
 (11,
  u'19898429,2364364,"ACTIVE",20110906,,"manager and above - consulting (m1)","0001444278",2364035,70733,"N",20111          '),
 (11,
  u'19898588,2364437,"ACTIVE",20120110,,"manager and above - consulting (m1)","0001444278",2364035,70733,"N",20140          '),
 (11,
  u'19898589,2364437,"ACTIVE",20120110,,"manager and above - consulting (m1)","0001444278",2363796,70455,"N",20140          '),
 (11,
  u'19898590,2364437,"ACTIVE",20120110,,"manager and above - consulting (m1)","0001444278",2363948,70455,"N",20140          '),
 (11,
  u'19898591,2364437,"ACTIVE",20120110,,"manager and above - consulting (m1)","0001444278",2363787,70455,"Y",20140          '),
 (11,
  u'19898296,2364142,"TERMINATED",20111102,,"manager and above - consulting","0001444278",2363601,70720,"N",201404          '),
 (11,
  u'19898494,2364364,"ACTIVE",20110906,,"manager and above - consulting (m1)","0001444278",2363785,70734,"N",20130          '),
 (11,
  u'19898495,2364364,"TERMINATED",20110906,,"manager and above - consulting (m1)","0001444278",2363785,70734,"N",2          ')]

In [115]:
# remove broken records
lines = counts.filter(lambda x: x[0] >= 12).values()
parts = lines.map(lambda l: l.split(","))

# new count of records
lines.count()


Out[115]:
40082652

In [117]:
#counts.uncache()

In [118]:
users = parts.map(lambda p: Row( system_user_id=p[1],
                                 employment_status=p[2],
                                 account_claimed_dt=p[3],
                                 user_security_role=p[5],
                                 business_unit_id=p[8],
                                 current_yn=p[9]))


# Infer the schema, and register the DataFrame as a table.
schemaPeople = sqlContext.inferSchema(users)
schemaPeople.registerTempTable("users")

In [119]:
# how many users do we have?
sqlContext.sql("SELECT count(*) FROM users").collect()


Out[119]:
[Row(c0=40082652)]

In [120]:
sqlContext.sql("SELECT employment_status, count(*) FROM users group by employment_status").collect()


Out[120]:
[Row(employment_status=u'"TERMINATED"', c1=8199530),
 Row(employment_status=u'"Terminated"', c1=96),
 Row(employment_status=u'"ACTIVE"', c1=31722934),
 Row(employment_status=u'"INACTIVE"', c1=160092)]

In [122]:
sqlContext.sql("SELECT user_security_role, count(*) FROM users group by user_security_role").collect()


Out[122]:
[Row(user_security_role=u'"l37735"', c1=10),
 Row(user_security_role=u'"l9552"', c1=16),
 Row(user_security_role=u'"n16282"', c1=58),
 Row(user_security_role=u'"l14352"', c1=12),
 Row(user_security_role=u'"n15715"', c1=4),
 Row(user_security_role=u'"21-13340-2331"', c1=6),
 Row(user_security_role=u'"y10306"', c1=34),
 Row(user_security_role=u'"l14514"', c1=18),
 Row(user_security_role=u'"34-54019-5134"', c1=4),
 Row(user_security_role=u'"33-33137-2651"', c1=2),
 Row(user_security_role=u'"33-33121-5297"', c1=2),
 Row(user_security_role=u'"nuclear technical spec iii"', c1=24),
 Row(user_security_role=u'"34-54195-3027"', c1=2),
 Row(user_security_role=u'"l5042"', c1=52),
 Row(user_security_role=u'"739"', c1=14),
 Row(user_security_role=u'"4e"', c1=1886),
 Row(user_security_role=u'"22-11440-2016"', c1=6),
 Row(user_security_role=u'"y32636"', c1=4),
 Row(user_security_role=u'"l12075"', c1=62),
 Row(user_security_role=u'"028-21201 lead cycle counter"', c1=2),
 Row(user_security_role=u'"5141"', c1=70),
 Row(user_security_role=u'"l25495"', c1=8),
 Row(user_security_role=u'"003-01302 bulk picker/rover"', c1=20),
 Row(user_security_role=u'"y14203"', c1=6),
 Row(user_security_role=u'"621"', c1=50),
 Row(user_security_role=u'"y_t40usa"', c1=6168),
 Row(user_security_role=u'"hr_n"', c1=3370),
 Row(user_security_role=u'"n33535"', c1=364),
 Row(user_security_role=u'"24-17015-1862"', c1=2),
 Row(user_security_role=u'"l14190"', c1=42),
 Row(user_security_role=u'"5310site manager"', c1=194),
 Row(user_security_role=u'"chairman', c1=8),
 Row(user_security_role=u'"pl0030"', c1=6990),
 Row(user_security_role=u'"n26407"', c1=938),
 Row(user_security_role=u'"n21295"', c1=18),
 Row(user_security_role=u'"app002"', c1=4),
 Row(user_security_role=u'"y26075"', c1=4),
 Row(user_security_role=u'"34-54563-1660"', c1=4),
 Row(user_security_role=u'"project controls analyst lead"', c1=12),
 Row(user_security_role=u'"y648"', c1=102),
 Row(user_security_role=u'"property accountant"', c1=20),
 Row(user_security_role=u'"mnt037"', c1=32),
 Row(user_security_role=u'"1695"', c1=26),
 Row(user_security_role=u'"n17335"', c1=542),
 Row(user_security_role=u'"ncus39"', c1=146),
 Row(user_security_role=u'"n12385"', c1=86),
 Row(user_security_role=u'"34-47015-2032"', c1=2),
 Row(user_security_role=u'"sys engr 2"', c1=92),
 Row(user_security_role=u'"126"', c1=30),
 Row(user_security_role=u'"n14211"', c1=76),
 Row(user_security_role=u'"22-14010-5391"', c1=4),
 Row(user_security_role=u'"488"', c1=20),
 Row(user_security_role=u'"l9463"', c1=58),
 Row(user_security_role=u'"n_m30hrusa"', c1=82),
 Row(user_security_role=u'"n30935"', c1=82),
 Row(user_security_role=u'"003-02115 bulk picker/rover"', c1=34),
 Row(user_security_role=u'"n479"', c1=66),
 Row(user_security_role=u'"n22097"', c1=230),
 Row(user_security_role=u'"l32245"', c1=50),
 Row(user_security_role=u'"canmgrsales"', c1=1272),
 Row(user_security_role=u'"business area admin"', c1=4),
 Row(user_security_role=u'"y40610"', c1=8),
 Row(user_security_role=u'"assistant community manager"', c1=374),
 Row(user_security_role=u'"pt03le"', c1=6),
 Row(user_security_role=u'"y25095"', c1=8),
 Row(user_security_role=u'"dedication lab specialist"', c1=4),
 Row(user_security_role=u'"n11729"', c1=10),
 Row(user_security_role=u'"n32555"', c1=12),
 Row(user_security_role=u'"24-13315-2388"', c1=2),
 Row(user_security_role=u'"l12599"', c1=32),
 Row(user_security_role=u'"y_p35"', c1=252),
 Row(user_security_role=u'"y38677"', c1=8),
 Row(user_security_role=u'"n34175"', c1=46),
 Row(user_security_role=u'"l32858"', c1=8),
 Row(user_security_role=u'"8896director general admin"', c1=14),
 Row(user_security_role=u'"22-13222-2433"', c1=24),
 Row(user_security_role=u'"director of operational excell"', c1=4),
 Row(user_security_role=u'"y17076"', c1=4),
 Row(user_security_role=u'"80"', c1=530),
 Row(user_security_role=u'"n2206"', c1=98),
 Row(user_security_role=u'"cpt007"', c1=4),
 Row(user_security_role=u'"financial analyst i"', c1=6),
 Row(user_security_role=u'"ap clerk ii"', c1=14),
 Row(user_security_role=u'"y41295"', c1=4),
 Row(user_security_role=u'"cntrctadmmgr"', c1=2),
 Row(user_security_role=u'"l1100"', c1=22),
 Row(user_security_role=u'"y23475"', c1=6),
 Row(user_security_role=u'"21-11112-8036"', c1=20),
 Row(user_security_role=u'"21-13700-6026"', c1=2),
 Row(user_security_role=u'"089-17101 lead cigarette/tobac"', c1=4),
 Row(user_security_role=u'"ypusc6"', c1=40),
 Row(user_security_role=u'"us73pdr"', c1=56),
 Row(user_security_role=u'"y12170"', c1=2),
 Row(user_security_role=u'"pla0007"', c1=1094),
 Row(user_security_role=u'"y14114"', c1=2),
 Row(user_security_role=u'"principal contracts agent"', c1=4),
 Row(user_security_role=u'"l41317"', c1=4),
 Row(user_security_role=u'"super user"', c1=14),
 Row(user_security_role=u'"n39576"', c1=54),
 Row(user_security_role=u'"y16185"', c1=90),
 Row(user_security_role=u'"y15456"', c1=6),
 Row(user_security_role=u'"n5050"', c1=142),
 Row(user_security_role=u'"l22895"', c1=14),
 Row(user_security_role=u'"1650"', c1=20),
 Row(user_security_role=u'"n8949"', c1=16),
 Row(user_security_role=u'"project leader"', c1=42),
 Row(user_security_role=u'"n12458"', c1=28),
 Row(user_security_role=u'"us01aair"', c1=234),
 Row(user_security_role=u'"financial system analyst staff"', c1=4),
 Row(user_security_role=u'"hrr008"', c1=4),
 Row(user_security_role=u'"n32717"', c1=336),
 Row(user_security_role=u'"fleet ops support manager"', c1=6),
 Row(user_security_role=u'"00rr"', c1=70),
 Row(user_security_role=u'"l20662"', c1=14),
 Row(user_security_role=u'"site project lead"', c1=166),
 Row(user_security_role=u'"n14735"', c1=112),
 Row(user_security_role=u'"n523"', c1=502),
 Row(user_security_role=u'"10-17153-5362"', c1=4),
 Row(user_security_role=u'"l18935"', c1=156),
 Row(user_security_role=u'"l14425"', c1=6),
 Row(user_security_role=u'"23-15060-3004"', c1=4),
 Row(user_security_role=u'"5052"', c1=8),
 Row(user_security_role=u'"22-13444-3120"', c1=2),
 Row(user_security_role=u'"cs"', c1=26),
 Row(user_security_role=u'"1155"', c1=6),
 Row(user_security_role=u'"24-13330-2422"', c1=4),
 Row(user_security_role=u'"l14174"', c1=20),
 Row(user_security_role=u'"l37557"', c1=8),
 Row(user_security_role=u'"064-06304 data process/compute"', c1=2),
 Row(user_security_role=u'"y21315"', c1=12),
 Row(user_security_role=u'"2119"', c1=12),
 Row(user_security_role=u'"un phar cashier"', c1=660),
 Row(user_security_role=u'"2i"', c1=366),
 Row(user_security_role=u'"0337"', c1=6),
 Row(user_security_role=u'"n20883"', c1=24),
 Row(user_security_role=u'"l37395"', c1=24),
 Row(user_security_role=u'"l490"', c1=10),
 Row(user_security_role=u'"n5079"', c1=52),
 Row(user_security_role=u'"l22355"', c1=62),
 Row(user_security_role=u'"281"', c1=20),
 Row(user_security_role=u'"associate general counsel"', c1=6),
 Row(user_security_role=u'"pl02le"', c1=22),
 Row(user_security_role=u'"22-13700-5124"', c1=28),
 Row(user_security_role=u'"22-11425-3003"', c1=2),
 Row(user_security_role=u'"us87nas"', c1=8),
 Row(user_security_role=u'"rgn033"', c1=4),
 Row(user_security_role=u'"n_r50usa"', c1=17062),
 Row(user_security_role=u'"professional other"', c1=2),
 Row(user_security_role=u'"n434"', c1=6),
 Row(user_security_role=u'"10-17132-1795"', c1=8),
 Row(user_security_role=u'"605"', c1=68),
 Row(user_security_role=u'"21-11124-8036"', c1=6),
 Row(user_security_role=u'"vpp016"', c1=2),
 Row(user_security_role=u'"professional nas"', c1=2),
 Row(user_security_role=u'"y8769"', c1=4),
 Row(user_security_role=u'"22-13455-1664"', c1=4),
 Row(user_security_role=u'"npmy12"', c1=4),
 Row(user_security_role=u'"y12081"', c1=2),
 Row(user_security_role=u'"34-54036-3023"', c1=4),
 Row(user_security_role=u'"y1-n/u rx u-grad intern yr 1"', c1=2),
 Row(user_security_role=u'"npca07"', c1=4),
 Row(user_security_role=u'"npus29"', c1=46),
 Row(user_security_role=u'"52-13440-3007"', c1=6),
 Row(user_security_role=u'"n37416"', c1=198),
 Row(user_security_role=u'"l27756"', c1=20),
 Row(user_security_role=u'"10-17205-5006"', c1=4),
 Row(user_security_role=u'"5620"', c1=4),
 Row(user_security_role=u'"21-15229-8016"', c1=4),
 Row(user_security_role=u'"n29235"', c1=12),
 Row(user_security_role=u'"y32296"', c1=6),
 Row(user_security_role=u'"n32628"', c1=50),
 Row(user_security_role=u'"director of information systems"', c1=4),
 Row(user_security_role=u'"us78wwr"', c1=14),
 Row(user_security_role=u'"088-18201 lead data process/co"', c1=4),
 Row(user_security_role=u'"2001"', c1=10),
 Row(user_security_role=u'"1679"', c1=40),
 Row(user_security_role=u'"y26716"', c1=30),
 Row(user_security_role=u'"l12392"', c1=32),
 Row(user_security_role=u'"fr13le"', c1=214),
 Row(user_security_role=u'"fremontmgr"', c1=292),
 Row(user_security_role=u'"yptw05"', c1=10),
 Row(user_security_role=u'"10-17006-1801"', c1=4),
 Row(user_security_role=u'"us12vrf"', c1=6),
 Row(user_security_role=u'"y20875"', c1=6),
 Row(user_security_role=u'"pl0014"', c1=31522),
 Row(user_security_role=u'"23-11307-2141"', c1=2),
 Row(user_security_role=u'"34-71133-2391"', c1=2),
 Row(user_security_role=u'"facilities foreman"', c1=44),
 Row(user_security_role=u'"vp or higher_tic_y"', c1=4),
 Row(user_security_role=u'"l17955"', c1=2),
 Row(user_security_role=u'"ee+"', c1=21328),
 Row(user_security_role=u'"l1373"', c1=90),
 Row(user_security_role=u'"n26635"', c1=92),
 Row(user_security_role=u'"34-54410-5134"', c1=10),
 Row(user_security_role=u'"n28417"', c1=12),
 Row(user_security_role=u'"n40891"', c1=8),
 Row(user_security_role=u'"22-15010-8061"', c1=6),
 Row(user_security_role=u'"100131"', c1=40),
 Row(user_security_role=u'"developer"', c1=2),
 Row(user_security_role=u'"n9706"', c1=350),
 Row(user_security_role=u'"097-training manager"', c1=22),
 Row(user_security_role=u'"l16975"', c1=14),
 Row(user_security_role=u'"n28868"', c1=6),
 Row(user_security_role=u'"y15935"', c1=14),
 Row(user_security_role=u'"10-17136-3264"', c1=4),
 Row(user_security_role=u'"n14106"', c1=34),
 Row(user_security_role=u'"maintenance mgr - mfin"', c1=22),
 Row(user_security_role=u'"10-17136-8052"', c1=2),
 Row(user_security_role=u'"y33755"', c1=12),
 Row(user_security_role=u'"vp or abovevs5.2"', c1=4),
 Row(user_security_role=u'"43-n/u n-e ast mgr"', c1=1484),
 Row(user_security_role=u'"crp029"', c1=2),
 Row(user_security_role=u'"y9453"', c1=82),
 Row(user_security_role=u'"pt78le"', c1=6),
 Row(user_security_role=u'"y26465"', c1=14),
 Row(user_security_role=u'"n40602"', c1=60),
 Row(user_security_role=u'"21-11410-1418"', c1=4),
 Row(user_security_role=u'"22-13455-2628"', c1=2),
 Row(user_security_role=u'"10-17169-2700"', c1=4),
 Row(user_security_role=u'"l28558"', c1=4),
 Row(user_security_role=u'"l21375"', c1=42),
 Row(user_security_role=u'"22-15200-5366"', c1=4),
 Row(user_security_role=u'"l32229"', c1=12),
 Row(user_security_role=u'"managing director"', c1=8),
 Row(user_security_role=u'"y20335"', c1=10),
 Row(user_security_role=u'"516"', c1=24),
 Row(user_security_role=u'"22-11412-2098"', c1=4),
 Row(user_security_role=u'"niusc8"', c1=4),
 Row(user_security_role=u'"colleague25"', c1=10),
 Row(user_security_role=u'"6378"', c1=18),
 Row(user_security_role=u'"tec"', c1=148),
 Row(user_security_role=u'"c10"', c1=6),
 Row(user_security_role=u'"npnl06"', c1=2),
 Row(user_security_role=u'"l563"', c1=50),
 Row(user_security_role=u'"10-17114-2667"', c1=6),
 Row(user_security_role=u'"28-11410-8009"', c1=2),
 Row(user_security_role=u'"063-18103 clerical"', c1=2),
 Row(user_security_role=u'"l26776"', c1=20),
 Row(user_security_role=u'"bcc projspec"', c1=4),
 Row(user_security_role=u'"l4992"', c1=22),
 Row(user_security_role=u'"33-33102-5352"', c1=4),
 Row(user_security_role=u'"10-17133-3162"', c1=2),
 Row(user_security_role=u'"22-17030-5268"', c1=4),
 Row(user_security_role=u'"m20hrusa"', c1=6),
 Row(user_security_role=u'"n28255"', c1=454),
 Row(user_security_role=u'"prp051"', c1=12),
 Row(user_security_role=u'"l14409"', c1=12),
 Row(user_security_role=u'"pct007"', c1=6),
 Row(user_security_role=u'"34-71145-2391"', c1=6),
 Row(user_security_role=u'"nuclear security officer', c1=602),
 Row(user_security_role=u'"23-13305-2328"', c1=8),
 Row(user_security_role=u'"24-15010-1765"', c1=4),
 Row(user_security_role=u'"n16221"', c1=254),
 Row(user_security_role=u'"l15995"', c1=290),
 Row(user_security_role=u'"22-13000-8049"', c1=88),
 Row(user_security_role=u'"l29855"', c1=14),
 Row(user_security_role=u'"css ii"', c1=122),
 Row(user_security_role=u'"l1"', c1=60),
 Row(user_security_role=u'"glcvs5.1"', c1=154),
 Row(user_security_role=u'"33-33145-2652"', c1=2),
 Row(user_security_role=u'"265"', c1=8),
 Row(user_security_role=u'"pl77le"', c1=14),
 Row(user_security_role=u'"l14202"', c1=40),
 Row(user_security_role=u'"l11647"', c1=100),
 Row(user_security_role=u'"coordinator iii"', c1=14),
 Row(user_security_role=u'"business development analyst"', c1=8),
 Row(user_security_role=u'"922"', c1=20),
 Row(user_security_role=u'"y14342"', c1=2),
 Row(user_security_role=u'"n8726"', c1=782),
 Row(user_security_role=u'"y28158"', c1=20),
 Row(user_security_role=u'"34-71182-2391"', c1=4),
 Row(user_security_role=u'"n9455"', c1=56),
 Row(user_security_role=u'"fr88le"', c1=4),
 Row(user_security_role=u'"0816"', c1=6),
 Row(user_security_role=u'"n27275"', c1=10),
 Row(user_security_role=u'"28-13305-2423"', c1=4),
 Row(user_security_role=u'"n37238"', c1=34),
 Row(user_security_role=u'"ncus60"', c1=8),
 Row(user_security_role=u'"100042"', c1=20),
 Row(user_security_role=u'"l34417"', c1=8),
 Row(user_security_role=u'"ncusc5"', c1=4),
 Row(user_security_role=u'"ca12rhcc"', c1=54),
 Row(user_security_role=u'"n12073"', c1=104),
 Row(user_security_role=u'"n913"', c1=12),
 Row(user_security_role=u'"mechanic-nuclear"', c1=198),
 Row(user_security_role=u'"hr rep ii"', c1=2),
 Row(user_security_role=u'"rgn017"', c1=4),
 Row(user_security_role=u'"0041"', c1=22222),
 Row(user_security_role=u'"npusd1"', c1=8),
 Row(user_security_role=u'"n32288"', c1=320),
 Row(user_security_role=u'"34-54563-3248"', c1=14),
 Row(user_security_role=u'"y14298"', c1=4),
 Row(user_security_role=u'"y26420"', c1=4),
 Row(user_security_role=u'"y32775"', c1=16),
 Row(user_security_role=u'"y_t80usa"', c1=3370),
 Row(user_security_role=u'"y36177"', c1=8),
 Row(user_security_role=u'"760"', c1=90),
 Row(user_security_role=u'"dis tran mgr"', c1=6),
 Row(user_security_role=u'"34-85272-2310"', c1=2),
 Row(user_security_role=u'"22-15210-2383"', c1=4),
 Row(user_security_role=u'"5442"', c1=6),
 Row(user_security_role=u'"063-06109 clerical-c"', c1=2),
 Row(user_security_role=u'"y14180"', c1=10),
 Row(user_security_role=u'"n/u phar tech"', c1=4186),
 Row(user_security_role=u'"y16575"', c1=6),
 Row(user_security_role=u'"n37482"', c1=8),
 Row(user_security_role=u'"l547"', c1=282),
 Row(user_security_role=u'"y29455"', c1=22),
 Row(user_security_role=u'"100115"', c1=20),
 Row(user_security_role=u'"assc2"', c1=202),
 Row(user_security_role=u'"21-11210-2099"', c1=8),
 Row(user_security_role=u'"l14069"', c1=16),
 Row(user_security_role=u'"n26457"', c1=6),
 Row(user_security_role=u'"n14379"', c1=282),
 Row(user_security_role=u'"y12471"', c1=28),
 Row(user_security_role=u'"l17075"', c1=48),
 Row(user_security_role=u'"n32856"', c1=34),
 Row(user_security_role=u'"regulatory affairs vp"', c1=6),
 Row(user_security_role=u'"21-13500-3069"', c1=18),
 Row(user_security_role=u'"div dir hr"', c1=2),
 Row(user_security_role=u'"administrative asst sr (west)"', c1=2),
 Row(user_security_role=u'"21-13500-1449"', c1=8),
 Row(user_security_role=u'"n7746"', c1=100),
 Row(user_security_role=u'"1500"', c1=56),
 Row(user_security_role=u'"0001a"', c1=1180),
 Row(user_security_role=u'"proj ctrls report&admin supr"', c1=4),
 Row(user_security_role=u'"22-11440-3001"', c1=46),
 Row(user_security_role=u'"ncus89"', c1=28),
 Row(user_security_role=u'"n20660"', c1=154),
 Row(user_security_role=u'"non-accr training instructor"', c1=34),
 Row(user_security_role=u'"338"', c1=10),
 Row(user_security_role=u'"n12597"', c1=54),
 Row(user_security_role=u'"33-33106-5288"', c1=20),
 Row(user_security_role=u'"176"', c1=28),
 Row(user_security_role=u'"34-79521-2391"', c1=2),
 Row(user_security_role=u'"y13975"', c1=24),
 Row(user_security_role=u'"n1454"', c1=284),
 Row(user_security_role=u'"34-54076-1660"', c1=2),
 Row(user_security_role=u'"y16035"', c1=62),
 Row(user_security_role=u'"br02rbr"', c1=74),
 Row(user_security_role=u'"004-02111 lead bulk picker/rov"', c1=4),
 Row(user_security_role=u'"23-11410-3074"', c1=10),
 Row(user_security_role=u'"l38676"', c1=4),
 Row(user_security_role=u'"n9366"', c1=48),
 Row(user_security_role=u'"y10"', c1=1622),
 Row(user_security_role=u'"mechanic"', c1=38),
 Row(user_security_role=u'"10-17100-1081"', c1=2),
 Row(user_security_role=u'"l6145"', c1=12),
 Row(user_security_role=u'"l4976"', c1=32),
 Row(user_security_role=u'"220"', c1=160),
 Row(user_security_role=u'"9e"', c1=594),
 Row(user_security_role=u'"5515"', c1=6),
 Row(user_security_role=u'"10-17133-3146"', c1=18),
 Row(user_security_role=u'"y4982"', c1=14),
 Row(user_security_role=u'"n32243"', c1=142),
 Row(user_security_role=u'"ypus29"', c1=46),
 Row(user_security_role=u'"34-71194-2391"', c1=4),
 Row(user_security_role=u'"5191"', c1=6),
 Row(user_security_role=u'"individual contributor"', c1=6014),
 Row(user_security_role=u'"10-17117-2080"', c1=4),
 Row(user_security_role=u'"manager1"', c1=28),
 Row(user_security_role=u'"bfl"', c1=58),
 Row(user_security_role=u'"1005"', c1=8),
 Row(user_security_role=u'"l4525"', c1=78),
 Row(user_security_role=u'"cycle planner"', c1=42),
 Row(user_security_role=u'"21-13442-2373"', c1=18),
 Row(user_security_role=u'"n40875"', c1=12),
 Row(user_security_role=u'"l28875"', c1=130),
 Row(user_security_role=u'"n38535"', c1=12),
 Row(user_security_role=u'"restricted"', c1=106),
 Row(user_security_role=u'"l2159"', c1=30),
 Row(user_security_role=u'"l12080"', c1=18),
 Row(user_security_role=u'"21-11112-8086"', c1=6),
 Row(user_security_role=u'"100026"', c1=6),
 Row(user_security_role=u'"l16257"', c1=60),
 Row(user_security_role=u'"088-18304 lead data process/co"', c1=2),
 Row(user_security_role=u'"vp cust sup"', c1=2),
 Row(user_security_role=u'"063-clerical"', c1=110),
 Row(user_security_role=u'"agm"', c1=124),
 Row(user_security_role=u'"sup/anm"', c1=2376),
 Row(user_security_role=u'"n7206"', c1=144),
 Row(user_security_role=u'"10-17153-5079"', c1=2),
 Row(user_security_role=u'"10-17131-2582"', c1=20),
 Row(user_security_role=u'"a0017"', c1=36546),
 Row(user_security_role=u'"34-41566-2033"', c1=2),
 Row(user_security_role=u'"l458"', c1=32),
 Row(user_security_role=u'"y8006"', c1=34),
 Row(user_security_role=u'"33-33512-3262"', c1=2),
 Row(user_security_role=u'"pla000299"', c1=6),
 Row(user_security_role=u'"y26404"', c1=16),
 Row(user_security_role=u'"n37555"', c1=36),
 Row(user_security_role=u'"us78pdr"', c1=74),
 Row(user_security_role=u'"l26715"', c1=112),
 Row(user_security_role=u'"au72rau"', c1=26),
 Row(user_security_role=u'"mnt042"', c1=58),
 Row(user_security_role=u'"discipline scheduler"', c1=52),
 Row(user_security_role=u'"r20usa"', c1=502),
 Row(user_security_role=u'"001-01304 loader/shipper"', c1=8),
 Row(user_security_role=u'"n573"', c1=10),
 Row(user_security_role=u'"n26412"', c1=40),
 Row(user_security_role=u'"n_r20"', c1=21788),
 Row(user_security_role=u'"906"', c1=130),
 Row(user_security_role=u'"6233dispatcher"', c1=24),
 Row(user_security_role=u'"l502"', c1=18),
 Row(user_security_role=u'"ntus29"', c1=4),
 Row(user_security_role=u'"n40335"', c1=20),
 Row(user_security_role=u'"249"', c1=20),
 Row(user_security_role=u'"22-14001-2159"', c1=4),
 Row(user_security_role=u'"y9186"', c1=2),
 Row(user_security_role=u'"y26855"', c1=56),
 Row(user_security_role=u'"fuel analyst sr"', c1=8),
 Row(user_security_role=u'"0476"', c1=6),
 Row(user_security_role=u'"03"', c1=2),
 Row(user_security_role=u'"n19735"', c1=4),
 Row(user_security_role=u'"22-13340-2370"', c1=2),
 Row(user_security_role=u'"npusb5"', c1=4),
 Row(user_security_role=u'"n39337"', c1=84),
 Row(user_security_role=u'"call center"', c1=390),
 Row(user_security_role=u'"y28637"', c1=2),
 Row(user_security_role=u'"ncusa9"', c1=12),
 Row(user_security_role=u'"y12382"', c1=6),
 Row(user_security_role=u'"y1436"', c1=6),
 Row(user_security_role=u'"21-15210-5006"', c1=4),
 Row(user_security_role=u'"l12855"', c1=4),
 Row(user_security_role=u'"23-15070-6001"', c1=2),
 Row(user_security_role=u'"744"', c1=20),
 Row(user_security_role=u'"us03corp"', c1=118),
 Row(user_security_role=u'"0025"', c1=200974),
 Row(user_security_role=u'"131"', c1=26),
 Row(user_security_role=u'"l27895"', c1=4),
 Row(user_security_role=u'"n14172"', c1=174),
 Row(user_security_role=u'"n5786"', c1=162),
 Row(user_security_role=u'"52-15010-8114"', c1=4),
 Row(user_security_role=u'"21-11440-2016"', c1=18),
 Row(user_security_role=u'"npus79"', c1=10),
 Row(user_security_role=u'"n4895"', c1=440),
 Row(user_security_role=u'"nuclear security captain (dev)"', c1=32),
 Row(user_security_role=u'"002-lead loader/shipper"', c1=44),
 Row(user_security_role=u'"l23296"', c1=8),
 Row(user_security_role=u'"y37296"', c1=12),
 Row(user_security_role=u'"administrator i"', c1=74),
 Row(user_security_role=u'"22-13315-3172"', c1=2),
 Row(user_security_role=u'"7001"', c1=10),
 Row(user_security_role=u'"011-02111 each pick/repack i"', c1=2),
 Row(user_security_role=u'"n28556"', c1=72),
 Row(user_security_role=u'"fdadotopspec"', c1=6),
 Row(user_security_role=u'"khec - first-line manager"', c1=132),
 Row(user_security_role=u'"ypusd1"', c1=4),
 Row(user_security_role=u'"pla0012"', c1=1706),
 Row(user_security_role=u'"y25875"', c1=8),
 Row(user_security_role=u'"n14245"', c1=60),
 Row(user_security_role=u'"n1438"', c1=1138),
 Row(user_security_role=u'"n34955"', c1=260),
 Row(user_security_role=u'"y39078"', c1=24),
 Row(user_security_role=u'"n21535"', c1=22),
 Row(user_security_role=u'"maintenance mgr - i&c"', c1=34),
 Row(user_security_role=u'"y26315"', c1=8),
 Row(user_security_role=u'"51-ast fe mgr/rx (ca only)"', c1=8),
 Row(user_security_role=u'"data flow process owner"', c1=10),
 Row(user_security_role=u'"34-54562-1833"', c1=10),
 Row(user_security_role=u'"34-54521-3250"', c1=2),
 Row(user_security_role=u'"34-54015-8109"', c1=4),
 Row(user_security_role=u'"y_p40"', c1=886),
 Row(user_security_role=u'"2169"', c1=4),
 Row(user_security_role=u'"l9586"', c1=20),
 Row(user_security_role=u'"custodian"', c1=52),
 Row(user_security_role=u'"204"', c1=188),
 Row(user_security_role=u'"sqa analyst 1"', c1=20),
 Row(user_security_role=u'"n26936"', c1=528),
 Row(user_security_role=u'"y14237"', c1=2),
 Row(user_security_role=u'"nfus15"', c1=62),
 Row(user_security_role=u'"l5076"', c1=16),
 Row(user_security_role=u'"us79rpd"', c1=28),
 Row(user_security_role=u'"y2238"', c1=76),
 Row(user_security_role=u'"l22116"', c1=4),
 Row(user_security_role=u'"l32250"', c1=4),
 Row(user_security_role=u'"28-15200-5041"', c1=4),
 Row(user_security_role=u'"y37458"', c1=8),
 Row(user_security_role=u'"y4a"', c1=118),
 Row(user_security_role=u'"coop - nontechnical"', c1=2),
 Row(user_security_role=u'"n646"', c1=4),
 Row(user_security_role=u'"l28859"', c1=40),
 Row(user_security_role=u'"n34298"', c1=40),
 Row(user_security_role=u'"l27355"', c1=4),
 Row(user_security_role=u'"n37015"', c1=436),
 Row(user_security_role=u'"22-11330-8037"', c1=14),
 Row(user_security_role=u'"a000599"', c1=2),
 Row(user_security_role=u'"52-13700-6037"', c1=6),
 Row(user_security_role=u'"n11734"', c1=110),
 Row(user_security_role=u'"technician (hrly)"', c1=332),
 Row(user_security_role=u'"089-lead cigarette/tobacco pic"', c1=6),
 Row(user_security_role=u'"n38195"', c1=16),
 Row(user_security_role=u'"493"', c1=16),
 Row(user_security_role=u'"21-11124-8086"', c1=12),
 Row(user_security_role=u'"hrr013"', c1=2),
 Row(user_security_role=u'"n32227"', c1=50),
 Row(user_security_role=u'"l26464"', c1=14),
 Row(user_security_role=u'"003-01105 bulk picker/rover"', c1=2),
 Row(user_security_role=u'"n484"', c1=30),
 Row(user_security_role=u'"22-17020-5108"', c1=6),
 Row(user_security_role=u'"22-11420-2099"', c1=12),
 Row(user_security_role=u'"33-33162-2640"', c1=6),
 Row(user_security_role=u'"21-13222-2433"', c1=8),
 Row(user_security_role=u'"22-15060-3004"', c1=4),
 Row(user_security_role=u'"l937"', c1=26),
 Row(user_security_role=u'"6240scheduling manager"', c1=744),
 Row(user_security_role=u'"610"', c1=24),
 Row(user_security_role=u'"0298"', c1=6),
 Row(user_security_role=u'"exec"', c1=152),
 Row(user_security_role=u'"34-54420-1008"', c1=6),
 Row(user_security_role=u'"n18215"', c1=524),
 Row(user_security_role=u'"medical services consultant sr"', c1=24),
 Row(user_security_role=u'"0009"', c1=650),
 Row(user_security_role=u'"n37539"', c1=282),
 Row(user_security_role=u'"tfilltec ii"', c1=38),
 Row(user_security_role=u'"n12536"', c1=92),
 Row(user_security_role=u'"site programs manager"', c1=4),
 Row(user_security_role=u'"l14297"', c1=8),
 Row(user_security_role=u'"bc admast ii"', c1=6),
 Row(user_security_role=u'"33-33113-8097"', c1=6),
 Row(user_security_role=u'"023-06201 rx stacker/replenish"', c1=4),
 Row(user_security_role=u'"nfin04"', c1=16),
 Row(user_security_role=u'"y14148"', c1=30),
 Row(user_security_role=u'"n40319"', c1=8),
 Row(user_security_role=u'"l5031"', c1=8),
 Row(user_security_role=u'"fleet nuclear security manager"', c1=4),
 Row(user_security_role=u'"n32633"', c1=4),
 Row(user_security_role=u'"n37421"', c1=388),
 Row(user_security_role=u'"l24755"', c1=34),
 Row(user_security_role=u'"n20717"', c1=64),
 Row(user_security_role=u'"p30"', c1=110),
 Row(user_security_role=u'"n29196"', c1=130),
 Row(user_security_role=u'"fleet projects manager"', c1=8),
 Row(user_security_role=u'"npca12"', c1=12),
 Row(user_security_role=u'"34-41055-2122"', c1=4),
 Row(user_security_role=u'"115"', c1=44),
 Row(user_security_role=u'"l27761"', c1=14),
 Row(user_security_role=u'"728"', c1=584),
 Row(user_security_role=u'"10-17130-2936"', c1=4),
 Row(user_security_role=u'"10-17006-1267"', c1=6),
 Row(user_security_role=u'"n33975"', c1=124),
 Row(user_security_role=u'"n22175"', c1=30),
 Row(user_security_role=u'"e"', c1=43522),
 Row(user_security_role=u'"it analyst', c1=10),
 Row(user_security_role=u'"33-33127-2586"', c1=4),
 Row(user_security_role=u'"l21136"', c1=22),
 Row(user_security_role=u'"3d"', c1=2846),
 Row(user_security_role=u'"van washer"', c1=30),
 Row(user_security_role=u'"34-45563-2032"', c1=2),
 Row(user_security_role=u'"l32279"', c1=40),
 Row(user_security_role=u'"y23715"', c1=4),
 Row(user_security_role=u'"l18356"', c1=14),
 Row(user_security_role=u'"5248"', c1=6),
 Row(user_security_role=u'"061-asst dept manager"', c1=228),
 Row(user_security_role=u'"n14200"', c1=138),
 Row(user_security_role=u'"n14156"', c1=32),
 Row(user_security_role=u'"34-88272-2391"', c1=4),
 Row(user_security_role=u'"25-11510-3038"', c1=6),
 Row(user_security_role=u'"nonpartner_advisory_md"', c1=546),
 Row(user_security_role=u'"replenishement buyer"', c1=26),
 Row(user_security_role=u'"22-11125-2099"', c1=4),
 Row(user_security_role=u'"y386"', c1=2),
 Row(user_security_role=u'"34-54125-3212"', c1=4),
 Row(user_security_role=u'"n12609"', c1=174),
 Row(user_security_role=u'"n17235"', c1=18),
 Row(user_security_role=u'"y16336"', c1=22),
 Row(user_security_role=u'"cs coordinator"', c1=12),
 Row(user_security_role=u'"1595"', c1=170),
 Row(user_security_role=u'"materials sourcing supervisor"', c1=4),
 Row(user_security_role=u'"95-un hrly rx intl grad intern"', c1=10),
 Row(user_security_role=u'"5654"', c1=6),
 Row(user_security_role=u'"pmy"', c1=908),
 Row(user_security_role=u'"n20015"', c1=344),
 Row(user_security_role=u'"cc mgr"', c1=2),
 Row(user_security_role=u'"010-20107 lead each pick/repac"', c1=2),
 Row(user_security_role=u'"n12447"', c1=96),
 Row(user_security_role=u'"n512"', c1=18),
 Row(user_security_role=u'"521"', c1=48),
 Row(user_security_role=u'"n31815"', c1=2),
 Row(user_security_role=u'"n16182"', c1=2),
 Row(user_security_role=u'"l14252"', c1=14),
 Row(user_security_role=u'"y14392"', c1=10),
 Row(user_security_role=u'"n21195"', c1=114),
 Row(user_security_role=u'"5492"', c1=2),
 Row(user_security_role=u'"y12439"', c1=6),
 Row(user_security_role=u'"n11_rps"', c1=414),
 Row(user_security_role=u'"ypusb5"', c1=8),
 Row(user_security_role=u'"site systems manager"', c1=16),
 Row(user_security_role=u'"28-17000-5197"', c1=6),
 Row(user_security_role=u'"n14229"', c1=38),
 Row(user_security_role=u'"21-13700-5124"', c1=4),
 Row(user_security_role=u'"10-17150-2199"', c1=48),
 Row(user_security_role=u'"34-42077-2032"', c1=4),
 Row(user_security_role=u'"n14067"', c1=46),
 Row(user_security_role=u'"011-02102 each pick/repack i"', c1=230),
 Row(user_security_role=u'"pct012"', c1=10),
 Row(user_security_role=u'"n32995"', c1=264),
 Row(user_security_role=u'"financial plng & reporting mgr"', c1=2),
 Row(user_security_role=u'"n35055"', c1=10),
 Row(user_security_role=u'"y29756"', c1=12),
 Row(user_security_role=u'"un cshr/clrk"', c1=2892),
 Row(user_security_role=u'"34-54163-5164"', c1=6),
 Row(user_security_role=u'"npnl11"', c1=132),
 Row(user_security_role=u'"l28563"', c1=34),
 Row(user_security_role=u'"22-11145-5100"', c1=6),
 Row(user_security_role=u'"n33435"', c1=10),
 Row(user_security_role=u'"l32234"', c1=10),
 Row(user_security_role=u'"approver25"', c1=362),
 Row(user_security_role=u'"n/u rx u-grad intrn yr 6"', c1=556),
 Row(user_security_role=u'"labor relations manager"', c1=4),
 Row(user_security_role=u'"n14111"', c1=146),
 Row(user_security_role=u'"supplier compliance manager"', c1=16),
 Row(user_security_role=u'"l37635"', c1=4),
 Row(user_security_role=u'"22-11146-8016"', c1=42),
 Row(user_security_role=u'"n_v10"', c1=30),
 Row(user_security_role=u'"21-11440-5006"', c1=2),
 Row(user_security_role=u'"n15615"', c1=508),
 Row(user_security_role=u'"22-17040-1812"', c1=4),
 Row(user_security_role=u'"33-33174-2640"', c1=2),
 Row(user_security_role=u'"y14059"', c1=4),
 Row(user_security_role=u'"34-54598-2318"', c1=4),
 Row(user_security_role=u'"n28873"', c1=18),
 Row(user_security_role=u'"23-11305-5033"', c1=4),
 Row(user_security_role=u'"suspend"', c1=2262),
 Row(user_security_role=u'"34-42584-2033"', c1=2),
 Row(user_security_role=u'"l38977"', c1=8),
 Row(user_security_role=u'"24-17000-1076"', c1=6),
 Row(user_security_role=u'"n468"', c1=4),
 Row(user_security_role=u'"n16795"', c1=1154),
 Row(user_security_role=u'"100092"', c1=4),
 Row(user_security_role=u'"10-17210-2127"', c1=100),
 Row(user_security_role=u'"l24215"', c1=8),
 Row(user_security_role=u'"477"', c1=20),
 Row(user_security_role=u'"y1051"', c1=2),
 Row(user_security_role=u'"34-71584-2391"', c1=2),
 Row(user_security_role=u'"y32285"', c1=24),
 Row(user_security_role=u'"n12402"', c1=2),
 Row(user_security_role=u'"engineering supervisor cap"', c1=20),
 Row(user_security_role=u'"make ready technician"', c1=280),
 Row(user_security_role=u'"l36817"', c1=20),
 Row(user_security_role=u'"21-11505-3038"', c1=36),
 Row(user_security_role=u'"y459"', c1=2),
 Row(user_security_role=u'"008-21104 inventory control cl"', c1=4),
 Row(user_security_role=u'"l41055"', c1=8),
 Row(user_security_role=u'"dir man car"', c1=6),
 Row(user_security_role=u'"270"', c1=14),
 Row(user_security_role=u'"oe program manager"', c1=4),
 Row(user_security_role=u'"22-13305-2328"', c1=56),
 Row(user_security_role=u'"pas i"', c1=112),
 Row(user_security_role=u'"project cost analyst i"', c1=18),
 Row(user_security_role=u'"l32596"', c1=58),
 Row(user_security_role=u'"l26403"', c1=382),
 Row(user_security_role=u'"l37546"', c1=66),
 Row(user_security_role=u'"l7086"', c1=2),
 Row(user_security_role=u'"22-11412-3067"', c1=14),
 Row(user_security_role=u'"pt02le"', c1=2),
 Row(user_security_role=u'"n9460"', c1=220),
 Row(user_security_role=u'"pl0003"', c1=442),
 Row(user_security_role=u'"l5510"', c1=12),
 Row(user_security_role=u'"n7507"', c1=142),
 Row(user_security_role=u'"y9487"', c1=48),
 Row(user_security_role=u'"n27398"', c1=100),
 Row(user_security_role=u'"22-13300-5315"', c1=26),
 Row(user_security_role=u'"r60usa"', c1=72),
 Row(user_security_role=u'"34-54134-3228"', c1=2),
 Row(user_security_role=u'"y19415"', c1=4),
 Row(user_security_role=u'"y_t30"', c1=416),
 Row(user_security_role=u'"lds"', c1=886),
 Row(user_security_role=u'"apr"', c1=44),
 Row(user_security_role=u'"n4221"', c1=118),
 Row(user_security_role=u'"l22795"', c1=12),
 Row(user_security_role=u'"l28636"', c1=16),
 Row(user_security_role=u'"l37997"', c1=12),
 Row(user_security_role=u'"npth01"', c1=10),
 Row(user_security_role=u'"acu"', c1=6),
 Row(user_security_role=u'"y23375"', c1=4),
 Row(user_security_role=u'"n12358"', c1=26),
 Row(user_security_role=u'"22-13700-6004"', c1=4),
 Row(user_security_role=u'"vpp005"', c1=8),
 Row(user_security_role=u'"receiver/loader"', c1=4),
 Row(user_security_role=u'"n423"', c1=28),
 Row(user_security_role=u'"ypus79"', c1=12),
 Row(user_security_role=u'"n32617"', c1=18),
 Row(user_security_role=u'"21-15010-8061"', c1=24),
 Row(user_security_role=u'"y18975"', c1=20),
 Row(user_security_role=u'"fleet programs director"', c1=6),
 Row(user_security_role=u'"2108"', c1=92),
 Row(user_security_role=u'"21-15200-5366"', c1=16),
 Row(user_security_role=u'"10-17100-1004"', c1=4),
 Row(user_security_role=u'"l1451"', c1=28),
 Row(user_security_role=u'"n34075"', c1=46),
 Row(user_security_role=u'"y8307"', c1=16),
 Row(user_security_role=u'"rgn022"', c1=4),
 Row(user_security_role=u'"service technician"', c1=358),
 Row(user_security_role=u'"2559"', c1=8),
 Row(user_security_role=u'"au77rau"', c1=36),
 Row(user_security_role=u'"y9109"', c1=4),
 Row(user_security_role=u'"2190"', c1=2),
 Row(user_security_role=u'"fr12le"', c1=146),
 Row(user_security_role=u'"5638"', c1=10),
 Row(user_security_role=u'"34-73271-2391"', c1=2),
 Row(user_security_role=u'"52-17000-5381"', c1=2),
 Row(user_security_role=u'"n31475"', c1=74),
 Row(user_security_role=u'"nz11rnz"', c1=4),
 Row(user_security_role=u'"299"', c1=446),
 Row(user_security_role=u'"entry"', c1=11484),
 Row(user_security_role=u'"ypca12"', c1=2),
 Row(user_security_role=u'"l37295"', c1=12),
 Row(user_security_role=u'"22-11240-2099"', c1=12),
 Row(user_security_role=u'"n4907"', c1=22),
 Row(user_security_role=u'"field executive vp', c1=2),
 Row(user_security_role=u'"21-11390-2212"', c1=2),
 Row(user_security_role=u'"001-01301 loader/shipper"', c1=18),
 Row(user_security_role=u'"employee - nc"', c1=20900),
 Row(user_security_role=u'"first-line manager"', c1=3520),
 Row(user_security_role=u'"21-13205-2479"', c1=6),
 Row(user_security_role=u'"volunteer"', c1=16),
 Row(user_security_role=u'"5204concierge"', c1=272),
 Row(user_security_role=u'"21-13324-5164"', c1=4),
 Row(user_security_role=u'"n40880"', c1=40),
 Row(user_security_role=u'"l32218"', c1=8),
 Row(user_security_role=u'"33-33124-2203"', c1=4),
 Row(user_security_role=u'"34-77077-2391"', c1=2),
 Row(user_security_role=u'"y26454"', c1=14),
 Row(user_security_role=u'"23-13315-2327"', c1=8),
 Row(user_security_role=u'"100076"', c1=8),
 Row(user_security_role=u'"l40075"', c1=4),
 Row(user_security_role=u'"l17855"', c1=2),
 Row(user_security_role=u'"paralegal exempt"', c1=4),
 Row(user_security_role=u'"22-11237-2011"', c1=6),
 Row(user_security_role=u'"l5872"', c1=18),
 Row(user_security_role=u'"21-13000-8049"', c1=60),
 Row(user_security_role=u'"l8707"', c1=40),
 Row(user_security_role=u'"0_cat 3"', c1=36),
 Row(user_security_role=u'"100120"', c1=12),
 Row(user_security_role=u'"n23456"', c1=4),
 Row(user_security_role=u'"l12454"', c1=52),
 Row(user_security_role=u'"n15275"', c1=46),
 Row(user_security_role=u'"appr elecn-nu"', c1=82),
 Row(user_security_role=u'"n26462"', c1=14),
 Row(user_security_role=u'"10-17136-3091"', c1=8),
 Row(user_security_role=u'"n28857"', c1=54),
 Row(user_security_role=u'"181"', c1=30),
 Row(user_security_role=u'"n947"', c1=1916),
 Row(user_security_role=u'"34-54025-5134"', c1=2),
 Row(user_security_role=u'"n37316"', c1=8),
 Row(user_security_role=u'"34-72029-2032"', c1=2),
 Row(user_security_role=u'"mx02lmx"', c1=4),
 Row(user_security_role=u'"0075"', c1=6),
 Row(user_security_role=u'"28-15050-7004"', c1=2),
 Row(user_security_role=u'"pl01le"', c1=4),
 Row(user_security_role=u'"1461"', c1=10),
 Row(user_security_role=u'"100-18104 lead clerical"', c1=2),
 Row(user_security_role=u'"n19858"', c1=42),
 Row(user_security_role=u'"22-15010-8079"', c1=8),
 Row(user_security_role=u'"4540"', c1=428),
 Row(user_security_role=u'"n407"', c1=26),
 Row(user_security_role=u'"y14331"', c1=8),
 Row(user_security_role=u'"n30495"', c1=100),
 Row(user_security_role=u'"l40599"', c1=16),
 Row(user_security_role=u'"n28155"', c1=38),
 Row(user_security_role=u'"y15060"', c1=8),
 Row(user_security_role=u'"91-un hrly ovrnght 24 hr pharm"', c1=36),
 Row(user_security_role=u'"52-11110-3274"', c1=14),
 Row(user_security_role=u'"hr spec"', c1=2),
 Row(user_security_role=u'"22-13354-2328"', c1=6),
 Row(user_security_role=u'"254"', c1=98),
 Row(user_security_role=u'"n14501"', c1=6),
 Row(user_security_role=u'"gatekeeper"', c1=2),
 Row(user_security_role=u'"100031"', c1=24),
 Row(user_security_role=u'"n32277"', c1=50),
 Row(user_security_role=u'"21-11440-3001"', c1=24),
 Row(user_security_role=u'"operator 1"', c1=6),
 Row(user_security_role=u'"28-15010-2329"', c1=4),
 Row(user_security_role=u'"rgn006"', c1=8),
 Row(user_security_role=u'"nfus65"', c1=3192),
 Row(user_security_role=u'"034-non cnvybl ii"', c1=26),
 Row(user_security_role=u'"n_m30"', c1=1368),
 Row(user_security_role=u'"22-14003-2694"', c1=2),
 Row(user_security_role=u'"l14309"', c1=12),
 Row(user_security_role=u'"un wellness ambassador"', c1=174),
 Row(user_security_role=u'"y1441"', c1=28),
 Row(user_security_role=u'"6885area vice president"', c1=138),
 Row(user_security_role=u'"ncusb4"', c1=14),
 Row(user_security_role=u'"y15835"', c1=18),
 Row(user_security_role=u'"n902"', c1=68),
 Row(user_security_role=u'"l10907"', c1=164),
 Row(user_security_role=u'"34-41208-2032"', c1=2),
 Row(user_security_role=u'"n1370"', c1=6),
 Row(user_security_role=u'"a0022"', c1=60234),
 Row(user_security_role=u'"23-13442-3003"', c1=4),
 Row(user_security_role=u'"10-17190-8008"', c1=2),
 Row(user_security_role=u'"l12365"', c1=34),
 Row(user_security_role=u'"ycusa6"', c1=4),
 Row(user_security_role=u'"nyyny"', c1=270),
 Row(user_security_role=u'"l34695"', c1=28),
 Row(user_security_role=u'"n24915"', c1=20),
 Row(user_security_role=u'"vp or abovevs4.2"', c1=178),
 Row(user_security_role=u'"n12675"', c1=32),
 Row(user_security_role=u'"lead environmental spec"', c1=6),
 Row(user_security_role=u'"34-71036-2391"', c1=2),
 Row(user_security_role=u'"ypnl11"', c1=34),
 Row(user_security_role=u'"n38118"', c1=38),
 Row(user_security_role=u'"y1397"', c1=108),
 Row(user_security_role=u'"n/u hrly pharmacist"', c1=464),
 Row(user_security_role=u'"080-rx forklift/equipment"', c1=2),
 Row(user_security_role=u'"911"', c1=222),
 Row(user_security_role=u'"0030"', c1=25588),
 Row(user_security_role=u'"sr director', c1=16),
 Row(user_security_role=u'"1534"', c1=4),
 Row(user_security_role=u'"us72kw"', c1=18),
 Row(user_security_role=u'"pt77le"', c1=8),
 Row(user_security_role=u'"2425"', c1=8),
 Row(user_security_role=u'"n26535"', c1=240),
 Row(user_security_role=u'"34-54030-3023"', c1=12),
 Row(user_security_role=u'"22-17015-5398"', c1=2),
 Row(user_security_role=u'"0805"', c1=6),
 Row(user_security_role=u'"34-54062-5134"', c1=6),
 Row(user_security_role=u'"nuclear planning specialist sr"', c1=244),
 Row(user_security_role=u'"executive vice president"', c1=40),
 Row(user_security_role=u'"sec"', c1=522),
 Row(user_security_role=u'"n14295"', c1=350),
 Row(user_security_role=u'"l8951"', c1=14),
 Row(user_security_role=u'"nfus20"', c1=38),
 Row(user_security_role=u'"npus84"', c1=18),
 Row(user_security_role=u'"z3-un rx u-grad intrn yr 3"', c1=16),
 Row(user_security_role=u'"34-54017-3023"', c1=10),
 Row(user_security_role=u'"n14368"', c1=210),
 Row(user_security_role=u'"n12586"', c1=76),
 Row(user_security_role=u'"34-42521-2032"', c1=4),
 Row(user_security_role=u'"165"', c1=20),
 Row(user_security_role=u'"ypus18"', c1=4),
 Row(user_security_role=u'"pst-cdl iii"', c1=94),
 Row(user_security_role=u'"l32535"', c1=22),
 Row(user_security_role=u'"n10966"', c1=188),
 Row(user_security_role=u'"n813"', c1=1774),
 Row(user_security_role=u'"d50usa"', c1=12),
 Row(user_security_role=u'"l24516"', c1=14),
 Row(user_security_role=u'"21-11430-2011"', c1=4),
 Row(user_security_role=u'"ep manager (dev)"', c1=4),
 Row(user_security_role=u'"34-54198-3212"', c1=2),
 Row(user_security_role=u'"n38975"', c1=32),
 Row(user_security_role=u'"ypmy01"', c1=2),
 Row(user_security_role=u'"33-33200-1526"', c1=4),
 Row(user_security_role=u'"y_v10usa"', c1=3526),
 Row(user_security_role=u'"n_t40usa"', c1=534),
 Row(user_security_role=u'"21-11238-2042"', c1=78),
 Row(user_security_role=u'"n12630"', c1=26),
 Row(user_security_role=u'"l15895"', c1=208),
 Row(user_security_role=u'"10-17153-5319"', c1=2),
 Row(user_security_role=u'"003-20302 bulk picker/rover"', c1=4),
 Row(user_security_role=u'"general"', c1=2),
 Row(user_security_role=u'"n21496"', c1=62),
 Row(user_security_role=u'"22-15070-6001"', c1=8),
 Row(user_security_role=u'"l14058"', c1=34),
 Row(user_security_role=u'"778"', c1=132),
 Row(user_security_role=u'"8"', c1=1194),
 Row(user_security_role=u'"glcvs4.1"', c1=14),
 Row(user_security_role=u'"22-15090-8023"', c1=50),
 Row(user_security_role=u'"n15259"', c1=406),
 Row(user_security_role=u'"n32232"', c1=44),
 Row(user_security_role=u'"8d"', c1=132),
 Row(user_security_role=u'"n26446"', c1=768),
 Row(user_security_role=u'"n15097"', c1=30),
 Row(user_security_role=u'"senior system architech"', c1=2),
 Row(user_security_role=u'"nuclear ops trg mgr (temp)"', c1=4),
 Row(user_security_role=u'"n14412"', c1=30),
 Row(user_security_role=u'"fr87le"', c1=24),
 Row(user_security_role=u'"34-54566-5134"', c1=8),
 Row(user_security_role=u'"l987"', c1=6),
 Row(user_security_role=u'"10-17216-2352"', c1=8),
 Row(user_security_role=u'"administrative assistant"', c1=82),
 Row(user_security_role=u'"gm/rsm/director"', c1=280),
 Row(user_security_role=u'"5504"', c1=6),
 Row(user_security_role=u'"l11547"', c1=170),
 Row(user_security_role=u'"npjp15"', c1=4),
 Row(user_security_role=u'"822"', c1=4),
 Row(user_security_role=u'"ypth01"', c1=4),
 Row(user_security_role=u'"y29895"', c1=54),
 Row(user_security_role=u'"33-33552-2640"', c1=2),
 Row(user_security_role=u'"lead"', c1=1546),
 Row(user_security_role=u'"l2237"', c1=104),
 Row(user_security_role=u'"y26438"', c1=60),
 Row(user_security_role=u'"l12438"', c1=20),
 Row(user_security_role=u'"l14391"', c1=62),
 Row(user_security_role=u'"2174"', c1=6),
 Row(user_security_role=u'"n23935"', c1=478),
 Row(user_security_role=u'"us84corp"', c1=8),
 Row(user_security_role=u'"4000"', c1=30),
 Row(user_security_role=u'"n10426"', c1=2),
 Row(user_security_role=u'"y2154"', c1=60),
 Row(user_security_role=u'"y1425"', c1=4),
 Row(user_security_role=u'"n37995"', c1=16),
 Row(user_security_role=u'"nuclear ops plant instr', c1=60),
 Row(user_security_role=u'"l21259"', c1=2),
 Row(user_security_role=u'"y14153"', c1=10),
 Row(user_security_role=u'"y12533"', c1=32),
 Row(user_security_role=u'"n26401"', c1=230),
 Row(user_security_role=u'"10-17169-1531"', c1=4),
 Row(user_security_role=u'"238"', c1=1110),
 Row(user_security_role=u'"n14323"', c1=276),
 Row(user_security_role=u'"21-11415-5100"', c1=2),
 Row(user_security_role=u'"10-17221-1745"', c1=2),
 Row(user_security_role=u'"34-76192-2391"', c1=2),
 Row(user_security_role=u'"n14161"', c1=76),
 Row(user_security_role=u'"21-11115-2209"', c1=4),
 Row(user_security_role=u'"n38435"', c1=150),
 Row(user_security_role=u'"gm 5"', c1=26),
 Row(user_security_role=u'"031-21201 lead inventory contr"', c1=2),
 Row(user_security_role=u'"l898"', c1=14),
 Row(user_security_role=u'"21-13315-3172"', c1=2),
 Row(user_security_role=u'"y480"', c1=4),
 Row(user_security_role=u'"mnt031"', c1=16),
 Row(user_security_role=u'"npbe06"', c1=8),
 Row(user_security_role=u'"10-17147-2161"', c1=6),
 Row(user_security_role=u'"100015"', c1=120),
 Row(user_security_role=u'"ncus33"', c1=104),
 Row(user_security_role=u'"22-17015-1862"', c1=4),
 Row(user_security_role=u'"it mgr', c1=2),
 Row(user_security_role=u'"de03hpc"', c1=62),
 Row(user_security_role=u'"employee_cgic"', c1=40),
 Row(user_security_role=u'"21-11000-8015"', c1=2),
 Row(user_security_role=u'"120"', c1=26),
 Row(user_security_role=u'"n12541"', c1=34),
 Row(user_security_role=u'"npusa4"', c1=4),
 Row(user_security_role=u'"y8446"', c1=10),
 Row(user_security_role=u'"y20219"', c1=50),
 Row(user_security_role=u'"y37536"', c1=2),
 Row(user_security_role=u'"a0006"', c1=30308),
 Row(user_security_role=u'"y_f10"', c1=4),
 Row(user_security_role=u'"22-11410-8008"', c1=10),
 Row(user_security_role=u'"fleet engineering director"', c1=4),
 Row(user_security_role=u'"n22955"', c1=8),
 Row(user_security_role=u'"50-19510-8015"', c1=2),
 Row(user_security_role=u'"21-11115-2542"', c1=2),
 Row(user_security_role=u'"fleet ld instr technologist"', c1=6),
 Row(user_security_role=u'"34-72589-2391"', c1=6),
 Row(user_security_role=u'"na"', c1=2034),
 Row(user_security_role=u'"21-13324-2386"', c1=4),
 Row(user_security_role=u'"n27581"', c1=2),
 Row(user_security_role=u'"733"', c1=328),
 Row(user_security_role=u'"n21118"', c1=144),
 Row(user_security_role=u'"n25015"', c1=12),
 Row(user_security_role=u'"22-13352-5077"', c1=12),
 Row(user_security_role=u'"y32630"', c1=16),
 Row(user_security_role=u'"0014"', c1=55674),
 Row(user_security_role=u'"n9428"', c1=196),
 Row(user_security_role=u'"n37544"', c1=26),
 Row(user_security_role=u'"n2245"', c1=140),
 Row(user_security_role=u'"n14279"', c1=144),
 Row(user_security_role=u'"21-17020-5108"', c1=4),
 Row(user_security_role=u'"y27735"', c1=44),
 Row(user_security_role=u'"ho employee"', c1=610),
 Row(user_security_role=u'"y12371"', c1=20),
 Row(user_security_role=u'"n32756"', c1=264),
 Row(user_security_role=u'"l8773"', c1=60),
 Row(user_security_role=u'"10-17108-1877"', c1=2),
 Row(user_security_role=u'"us03nac"', c1=258),
 Row(user_security_role=u'"21-15070-8111"', c1=8),
 Row(user_security_role=u'"y15495"', c1=16),
 Row(user_security_role=u'"us11rhc"', c1=36),
 Row(user_security_role=u'"22-11410-2211"', c1=2),
 Row(user_security_role=u'"fleet mgr"', c1=2),
 Row(user_security_role=u'"52-11000-1857"', c1=2),
 Row(user_security_role=u'"middle manager"', c1=408),
 Row(user_security_role=u'"l12593"', c1=8),
 Row(user_security_role=u'"us95nac"', c1=20),
 Row(user_security_role=u'"n39075"', c1=394),
 Row(user_security_role=u'"pla0001"', c1=526),
 Row(user_security_role=u'"n33558"', c1=2),
 Row(user_security_role=u'"n14234"', c1=84),
 Row(user_security_role=u'"149"', c1=22),
 Row(user_security_role=u'"34-41016-2032"', c1=2),
 Row(user_security_role=u'"68-n/u cashier/clerk"', c1=14900),
 Row(user_security_role=u'"hrr002"', c1=4),
 Row(user_security_role=u'"10-17205-2039"', c1=38),
 Row(user_security_role=u'"n_d50"', c1=14),
 Row(user_security_role=u'"y5071"', c1=6),
 Row(user_security_role=u'"n15576"', c1=108),
 Row(user_security_role=u'"n40235"', c1=8),
 Row(user_security_role=u'"1 - executive staff"', c1=294),
 Row(user_security_role=u'"l37596"', c1=8),
 Row(user_security_role=u'"2653"', c1=20),
 Row(user_security_role=u'"21-15060-3004"', c1=10),
 Row(user_security_role=u'"33-33513-2005"', c1=2),
 Row(user_security_role=u'"22-11410-1682"', c1=2),
 Row(user_security_role=u'"npus68"', c1=22),
 Row(user_security_role=u'"l28235"', c1=100),
 Row(user_security_role=u'"trn002"', c1=16),
 Row(user_security_role=u'"33-33257-2640"', c1=2),
 Row(user_security_role=u'"n21975"', c1=232),
 Row(user_security_role=u'"n12452"', c1=64),
 Row(user_security_role=u'"22-13222-5100"', c1=4),
 Row(user_security_role=u'"33-33100-1273"', c1=4),
 Row(user_security_role=u'"l26615"', c1=6),
 Row(user_security_role=u'"n27816"', c1=108),
 Row(user_security_role=u'"accounting manager"', c1=26),
 Row(user_security_role=u'"y9086"', c1=2),
 Row(user_security_role=u'"22-14013-2643"', c1=12),
 Row(user_security_role=u'"y_t80"', c1=528),
 ...]

In [123]:
sqlContext.sql("SELECT current_yn, count(*) FROM users group by current_yn").collect()


Out[123]:
[Row(current_yn=u'167207', c1=4406),
 Row(current_yn=u'249963', c1=2),
 Row(current_yn=u'243338', c1=54),
 Row(current_yn=u'249350', c1=2),
 Row(current_yn=u'243339', c1=6),
 Row(current_yn=u'264660', c1=90),
 Row(current_yn=u'250467', c1=2),
 Row(current_yn=u'167208', c1=650),
 Row(current_yn=u'251359', c1=2),
 Row(current_yn=u'167209', c1=1276),
 Row(current_yn=u'252583', c1=4),
 Row(current_yn=u'250963', c1=2),
 Row(current_yn=u'244726', c1=2),
 Row(current_yn=u'248623', c1=2),
 Row(current_yn=u'249191', c1=2),
 Row(current_yn=u'264662', c1=16),
 Row(current_yn=u'248462', c1=4),
 Row(current_yn=u'251198', c1=2),
 Row(current_yn=u'264663', c1=4),
 Row(current_yn=u'249192', c1=2),
 Row(current_yn=u'264664', c1=8),
 Row(current_yn=u'249194', c1=2),
 Row(current_yn=u'251697', c1=2),
 Row(current_yn=u'252588', c1=10),
 Row(current_yn=u'248015', c1=2),
 Row(current_yn=u'250194', c1=2),
 Row(current_yn=u'252138', c1=2),
 Row(current_yn=u'243228', c1=4),
 Row(current_yn=u'243229', c1=4),
 Row(current_yn=u'167270', c1=1936),
 Row(current_yn=u'250240', c1=2),
 Row(current_yn=u'251583', c1=2),
 Row(current_yn=u'167271', c1=6),
 Row(current_yn=u'248352', c1=24),
 Row(current_yn=u'250404', c1=2),
 Row(current_yn=u'252024', c1=2),
 Row(current_yn=u'248353', c1=2),
 Row(current_yn=u'247626', c1=2),
 Row(current_yn=u'250244', c1=4),
 Row(current_yn=u'251631', c1=2),
 Row(current_yn=u'249247', c1=2),
 Row(current_yn=u'286930', c1=2),
 Row(current_yn=u'247510', c1=2),
 Row(current_yn=u'248519', c1=2),
 Row(current_yn=u'248690', c1=2),
 Row(current_yn=u'247511', c1=2),
 Row(current_yn=u'250247', c1=2),
 Row(current_yn=u'243290', c1=6),
 Row(current_yn=u'252362', c1=6),
 Row(current_yn=u'247512', c1=4),
 Row(current_yn=u'243291', c1=28),
 Row(current_yn=u'249132', c1=2),
 Row(current_yn=u'247513', c1=2),
 Row(current_yn=u'243293', c1=12),
 Row(current_yn=u'251023', c1=2),
 Row(current_yn=u'243294', c1=26),
 Row(current_yn=u'250584', c1=4),
 Row(current_yn=u'252528', c1=10),
 Row(current_yn=u'243295', c1=4),
 Row(current_yn=u'249631', c1=2),
 Row(current_yn=u'266227', c1=8),
 Row(current_yn=u'243296', c1=4),
 Row(current_yn=u'243340', c1=48),
 Row(current_yn=u'249470', c1=4),
 Row(current_yn=u'248903', c1=16),
 Row(current_yn=u'243341', c1=80),
 Row(current_yn=u'248580', c1=2),
 Row(current_yn=u'243297', c1=12),
 Row(current_yn=u'248085', c1=4),
 Row(current_yn=u'252413', c1=14),
 Row(current_yn=u'167210', c1=2108),
 Row(current_yn=u'250137', c1=2),
 Row(current_yn=u'243342', c1=14),
 Row(current_yn=u'252252', c1=2),
 Row(current_yn=u'249635', c1=2),
 Row(current_yn=u'243299', c1=24),
 Row(current_yn=u'243343', c1=98),
 Row(current_yn=u'243344', c1=98),
 Row(current_yn=u'248908', c1=2),
 Row(current_yn=u'248089', c1=2),
 Row(current_yn=u'243345', c1=52),
 Row(current_yn=u'251365', c1=2),
 Row(current_yn=u'243346', c1=10),
 Row(current_yn=u'167216', c1=5906),
 Row(current_yn=u'251366', c1=2),
 Row(current_yn=u'244734', c1=4),
 Row(current_yn=u'248631', c1=24),
 Row(current_yn=u'248136', c1=2),
 Row(current_yn=u'250476', c1=2),
 Row(current_yn=u'167217', c1=3332),
 Row(current_yn=u'252591', c1=2),
 Row(current_yn=u'243348', c1=6),
 Row(current_yn=u'250520', c1=2),
 Row(current_yn=u'167218', c1=652),
 Row(current_yn=u'247741', c1=2),
 Row(current_yn=u'249974', c1=2),
 Row(current_yn=u'243349', c1=18),
 Row(current_yn=u'247903', c1=2),
 Row(current_yn=u'243231', c1=36),
 Row(current_yn=u'167219', c1=4376),
 Row(current_yn=u'243232', c1=10),
 Row(current_yn=u'247699', c1=2),
 Row(current_yn=u'248634', c1=2),
 Row(current_yn=u'243233', c1=4),
 Row(current_yn=u'252099', c1=4),
 Row(current_yn=u'249364', c1=4),
 Row(current_yn=u'243234', c1=4),
 Row(current_yn=u'250029', c1=4),
 Row(current_yn=u'"Y"', c1=10884100),
 Row(current_yn=u'251254', c1=2),
 Row(current_yn=u'252145', c1=6),
 Row(current_yn=u'243235', c1=288),
 Row(current_yn=u'248637', c1=2),
 Row(current_yn=u'243236', c1=6),
 Row(current_yn=u'243237', c1=12),
 Row(current_yn=u'243238', c1=4),
 Row(current_yn=u'243239', c1=8),
 Row(current_yn=u'247632', c1=4),
 Row(current_yn=u'251303', c1=2),
 Row(current_yn=u'252032', c1=4),
 Row(current_yn=u'251755', c1=2),
 Row(current_yn=u'250415', c1=2),
 Row(current_yn=u'251145', c1=2),
 Row(current_yn=u'249257', c1=2),
 Row(current_yn=u'252037', c1=4),
 Row(current_yn=u'250255', c1=2),
 Row(current_yn=u'222472', c1=10),
 Row(current_yn=u'249419', c1=2),
 Row(current_yn=u'250418', c1=2),
 Row(current_yn=u'248529', c1=2),
 Row(current_yn=u'251642', c1=2),
 Row(current_yn=u'249098', c1=2),
 Row(current_yn=u'250140', c1=2),
 Row(current_yn=u'248414', c1=2),
 Row(current_yn=u'248911', c1=2),
 Row(current_yn=u'249308', c1=2),
 Row(current_yn=u'250757', c1=4),
 Row(current_yn=u'249597', c1=4),
 Row(current_yn=u'243350', c1=22),
 Row(current_yn=u'249309', c1=2),
 Row(current_yn=u'251487', c1=2),
 Row(current_yn=u'248300', c1=2),
 Row(current_yn=u'167220', c1=868),
 Row(current_yn=u'251037', c1=2),
 Row(current_yn=u'252262', c1=2),
 Row(current_yn=u'243352', c1=12),
 Row(current_yn=u'167221', c1=3372),
 Row(current_yn=u'248591', c1=2),
 Row(current_yn=u'249032', c1=2),
 Row(current_yn=u'243353', c1=40),
 Row(current_yn=u'243354', c1=2),
 Row(current_yn=u'167223', c1=30),
 Row(current_yn=u'301053', c1=282),
 Row(current_yn=u'248918', c1=2),
 Row(current_yn=u'167224', c1=16),
 Row(current_yn=u'243355', c1=48),
 Row(current_yn=u'249035', c1=2),
 Row(current_yn=u'243356', c1=4),
 Row(current_yn=u'243400', c1=46),
 Row(current_yn=u'167225', c1=6),
 Row(current_yn=u'249036', c1=2),
 Row(current_yn=u'243357', c1=4),
 Row(current_yn=u'243401', c1=6),
 Row(current_yn=u'167226', c1=6040),
 Row(current_yn=u'243240', c1=74),
 Row(current_yn=u'247912', c1=2),
 Row(current_yn=u'248759', c1=2),
 Row(current_yn=u'243402', c1=4),
 Row(current_yn=u'243358', c1=4),
 Row(current_yn=u'167227', c1=7294),
 Row(current_yn=u'243359', c1=10),
 Row(current_yn=u'250487', c1=2),
 Row(current_yn=u'249038', c1=2),
 Row(current_yn=u'243241', c1=2),
 Row(current_yn=u'243403', c1=206),
 Row(current_yn=u'167228', c1=574),
 Row(current_yn=u'243404', c1=4),
 Row(current_yn=u'167229', c1=2978),
 Row(current_yn=u'243242', c1=24),
 Row(current_yn=u'250983', c1=2),
 Row(current_yn=u'248030', c1=8),
 Row(current_yn=u'252315', c1=2),
 Row(current_yn=u'243405', c1=118),
 Row(current_yn=u'244747', c1=4),
 Row(current_yn=u'243243', c1=6),
 Row(current_yn=u'243406', c1=4),
 Row(current_yn=u'252154', c1=2),
 Row(current_yn=u'243244', c1=22),
 Row(current_yn=u'243245', c1=14),
 Row(current_yn=u'247918', c1=2),
 Row(current_yn=u'243246', c1=18),
 Row(current_yn=u'243247', c1=222),
 Row(current_yn=u'247595', c1=2),
 Row(current_yn=u'243248', c1=112),
 Row(current_yn=u'250376', c1=2),
 Row(current_yn=u'243249', c1=68),
 Row(current_yn=u'252493', c1=2),
 Row(current_yn=u'247642', c1=4),
 Row(current_yn=u'251313', c1=12),
 Row(current_yn=u'251765', c1=2),
 Row(current_yn=u'251315', c1=2),
 Row(current_yn=u'252540', c1=2),
 Row(current_yn=u'249150', c1=2),
 Row(current_yn=u'251652', c1=2),
 Row(current_yn=u'251491', c1=2),
 Row(current_yn=u'250763', c1=2),
 Row(current_yn=u'250312', c1=2),
 Row(current_yn=u'250766', c1=2),
 Row(current_yn=u'249650', c1=2),
 Row(current_yn=u'248264', c1=2),
 Row(current_yn=u'251658', c1=2),
 Row(current_yn=u'250811', c1=2),
 Row(current_yn=u'250154', c1=2),
 Row(current_yn=u'243360', c1=8),
 Row(current_yn=u'249490', c1=2),
 Row(current_yn=u'248923', c1=2),
 Row(current_yn=u'248266', c1=2),
 Row(current_yn=u'252271', c1=2),
 Row(current_yn=u'167230', c1=1382),
 Row(current_yn=u'252389', c1=4),
 Row(current_yn=u'243362', c1=14),
 Row(current_yn=u'250201', c1=2),
 Row(current_yn=u'250653', c1=2),
 Row(current_yn=u'167232', c1=1202),
 Row(current_yn=u'250491', c1=2),
 Row(current_yn=u'167233', c1=1964),
 Row(current_yn=u'250492', c1=2),
 Row(current_yn=u'243364', c1=30),
 Row(current_yn=u'243365', c1=36),
 Row(current_yn=u'167234', c1=1786),
 Row(current_yn=u'248766', c1=4),
 Row(current_yn=u'169350', c1=18),
 Row(current_yn=u'243366', c1=20),
 Row(current_yn=u'250494', c1=2),
 Row(current_yn=u'167235', c1=6),
 Row(current_yn=u'248317', c1=2),
 Row(current_yn=u'250701', c1=8),
 Row(current_yn=u'172249', c1=18),
 Row(current_yn=u'167236', c1=164),
 Row(current_yn=u'243368', c1=16),
 Row(current_yn=u'243250', c1=18),
 Row(current_yn=u'248651', c1=4),
 Row(current_yn=u'167237', c1=10),
 Row(current_yn=u'243369', c1=10),
 Row(current_yn=u'247761', c1=2),
 Row(current_yn=u'167238', c1=10042),
 Row(current_yn=u'243252', c1=4),
 Row(current_yn=u'"N"', c1=29033482),
 Row(current_yn=u'167239', c1=6464),
 Row(current_yn=u'248816', c1=2),
 Row(current_yn=u'243253', c1=12),
 Row(current_yn=u'249996', c1=2),
 Row(current_yn=u'248817', c1=2),
 Row(current_yn=u'243254', c1=2),
 Row(current_yn=u'249547', c1=2),
 Row(current_yn=u'251274', c1=4),
 Row(current_yn=u'243300', c1=40),
 Row(current_yn=u'243256', c1=4),
 Row(current_yn=u'243301', c1=42),
 Row(current_yn=u'243257', c1=50),
 Row(current_yn=u'248045', c1=2),
 Row(current_yn=u'250385', c1=2),
 Row(current_yn=u'251772', c1=2),
 Row(current_yn=u'243258', c1=22),
 Row(current_yn=u'248497', c1=2),
 Row(current_yn=u'248209', c1=2),
 Row(current_yn=u'243303', c1=14),
 Row(current_yn=u'243259', c1=6),
 Row(current_yn=u'250882', c1=2),
 Row(current_yn=u'250883', c1=10),
 Row(current_yn=u'249273', c1=2),
 Row(current_yn=u'243305', c1=6),
 Row(current_yn=u'251324', c1=4),
 Row(current_yn=u'248706', c1=2),
 Row(current_yn=u'257616', c1=20),
 Row(current_yn=u'243306', c1=4),
 Row(current_yn=u'257617', c1=18),
 Row(current_yn=u'250435', c1=2),
 Row(current_yn=u'257618', c1=26),
 Row(current_yn=u'249438', c1=2),
 Row(current_yn=u'257619', c1=30),
 Row(current_yn=u'252219', c1=6),
 Row(current_yn=u'183713', c1=10),
 Row(current_yn=u'248388', c1=4),
 Row(current_yn=u'247704', c1=2),
 Row(current_yn=u'252104', c1=2),
 Row(current_yn=u'248434', c1=2),
 Row(current_yn=u'252108', c1=2),
 Row(current_yn=u'252397', c1=2),
 Row(current_yn=u'251218', c1=2),
 Row(current_yn=u'243370', c1=2),
 Row(current_yn=u'250822', c1=4),
 Row(current_yn=u'251552', c1=10),
 Row(current_yn=u'167240', c1=2908),
 Row(current_yn=u'252605', c1=2),
 Row(current_yn=u'167241', c1=6862),
 Row(current_yn=u'248160', c1=2),
 Row(current_yn=u'249169', c1=2),
 Row(current_yn=u'167242', c1=14206),
 Row(current_yn=u'167243', c1=2774),
 Row(current_yn=u'251717', c1=2),
 Row(current_yn=u'243374', c1=6),
 Row(current_yn=u'251600', c1=4),
 Row(current_yn=u'167244', c1=3714),
 Row(current_yn=u'243375', c1=4),
 Row(current_yn=u'251601', c1=2),
 Row(current_yn=u'167245', c1=514),
 Row(current_yn=u'243376', c1=8),
 Row(current_yn=u'249713', c1=2),
 Row(current_yn=u'243377', c1=6),
 Row(current_yn=u'243260', c1=4),
 Row(current_yn=u'248779', c1=2),
 Row(current_yn=u'243378', c1=22),
 Row(current_yn=u'167247', c1=9028),
 Row(current_yn=u'250550', c1=8),
 Row(current_yn=u'243261', c1=4),
 Row(current_yn=u'252171', c1=2),
 Row(current_yn=u'243379', c1=4),
 Row(current_yn=u'247771', c1=2),
 Row(current_yn=u'250551', c1=2),
 Row(current_yn=u'243262', c1=10),
 Row(current_yn=u'248050', c1=2),
 Row(current_yn=u'249554', c1=4),
 Row(current_yn=u'249717', c1=2),
 Row(current_yn=u'248213', c1=2),
 Row(current_yn=u'248051', c1=2),
 Row(current_yn=u'249600', c1=2),
 Row(current_yn=u'250716', c1=2),
 Row(current_yn=u'257620', c1=62),
 Row(current_yn=u'243265', c1=4),
 Row(current_yn=u'250556', c1=2),
 Row(current_yn=u'248667', c1=2),
 Row(current_yn=u'252338', c1=2),
 Row(current_yn=u'249396', c1=2),
 Row(current_yn=u'257621', c1=6),
 Row(current_yn=u'243311', c1=2),
 Row(current_yn=u'243267', c1=4),
 Row(current_yn=u'251330', c1=2),
 Row(current_yn=u'248100', c1=2),
 Row(current_yn=u'243312', c1=26),
 Row(current_yn=u'243268', c1=4),
 Row(current_yn=u'250558', c1=2),
 Row(current_yn=u'249280', c1=2),
 Row(current_yn=u'243313', c1=32),
 Row(current_yn=u'243269', c1=2),
 Row(current_yn=u'250280', c1=2),
 Row(current_yn=u'243314', c1=20),
 Row(current_yn=u'253610', c1=36),
 Row(current_yn=u'250442', c1=2),
 Row(current_yn=u'243315', c1=48),
 Row(current_yn=u'243317', c1=18),
 Row(current_yn=u'250607', c1=2),
 Row(current_yn=u'251337', c1=2),
 Row(current_yn=u'247666', c1=2),
 Row(current_yn=u'243319', c1=12),
 Row(current_yn=u'251338', c1=4),
 Row(current_yn=u'250609', c1=2),
 Row(current_yn=u'247668', c1=2),
 Row(current_yn=u'249171', c1=4),
 Row(current_yn=u'250332', c1=2),
 Row(current_yn=u'248284', c1=2),
 Row(current_yn=u'251721', c1=2),
 Row(current_yn=u'248447', c1=2),
 Row(current_yn=u'248942', c1=2),
 Row(current_yn=u'252613', c1=2),
 Row(current_yn=u'248609', c1=4),
 Row(current_yn=u'249671', c1=2),
 Row(current_yn=u'248285', c1=2),
 Row(current_yn=u'252452', c1=2),
 Row(current_yn=u'252119', c1=20),
 Row(current_yn=u'243380', c1=8),
 Row(current_yn=u'249834', c1=2),
 Row(current_yn=u'250337', c1=2),
 Row(current_yn=u'248782', c1=4),
 Row(current_yn=u'252453', c1=2),
 Row(current_yn=u'250833', c1=2),
 Row(current_yn=u'243381', c1=164),
 Row(current_yn=u'248170', c1=4),
 Row(current_yn=u'167251', c1=6808),
 Row(current_yn=u'243383', c1=36),
 Row(current_yn=u'250835', c1=10),
 Row(current_yn=u'167252', c1=580),
 Row(current_yn=u'248171', c1=2),
 Row(current_yn=u'250179', c1=2),
 Row(current_yn=u'248172', c1=8),
 Row(current_yn=u'167253', c1=1788),
 Row(current_yn=u'251114', c1=2),
 Row(current_yn=u'243384', c1=40),
 Row(current_yn=u'167254', c1=2180),
 Row(current_yn=u'243385', c1=12),
 Row(current_yn=u'252502', c1=2),
 Row(current_yn=u'251116', c1=2),
 Row(current_yn=u'251567', c1=2),
 Row(current_yn=u'249065', c1=12),
 Row(current_yn=u'167255', c1=9482),
 Row(current_yn=u'250721', c1=2),
 Row(current_yn=u'167256', c1=1552),
 Row(current_yn=u'243387', c1=4),
 Row(current_yn=u'268930', c1=8),
 Row(current_yn=u'248338', c1=4),
 Row(current_yn=u'243388', c1=6),
 Row(current_yn=u'250560', c1=2),
 Row(current_yn=u'167257', c1=3148),
 Row(current_yn=u'251613', c1=2),
 Row(current_yn=u'167258', c1=1448),
 Row(current_yn=u'243389', c1=8),
 Row(current_yn=u'248339', c1=2),
 Row(current_yn=u'268931', c1=2),
 Row(current_yn=u'248177', c1=2),
 Row(current_yn=u'167259', c1=1478),
 Row(current_yn=u'243272', c1=12),
 Row(current_yn=u'244776', c1=72),
 Row(current_yn=u'252506', c1=2),
 Row(current_yn=u'250725', c1=2),
 Row(current_yn=u'244777', c1=22),
 Row(current_yn=u'243274', c1=6),
 Row(current_yn=u'244778', c1=30),
 Row(current_yn=u'248720', c1=4),
 Row(current_yn=u'244779', c1=22),
 Row(current_yn=u'243275', c1=112),
 Row(current_yn=u'248225', c1=2),
 Row(current_yn=u'251619', c1=2),
 Row(current_yn=u'243276', c1=88),
 Row(current_yn=u'243320', c1=32),
 Row(current_yn=u'250611', c1=2),
 Row(current_yn=u'248560', c1=2),
 Row(current_yn=u'252187', c1=2),
 Row(current_yn=u'251341', c1=2),
 Row(current_yn=u'252188', c1=2),
 Row(current_yn=u'251009', c1=2),
 Row(current_yn=u'250613', c1=2),
 Row(current_yn=u'252189', c1=2),
 Row(current_yn=u'248067', c1=2),
 Row(current_yn=u'243324', c1=46),
 Row(current_yn=u'244711', c1=4),
 Row(current_yn=u'249455', c1=2),
 Row(current_yn=u'252074', c1=2),
 Row(current_yn=u'243326', c1=12),
 Row(current_yn=u'248114', c1=2),
 Row(current_yn=u'247675', c1=14),
 Row(current_yn=u'249952', c1=2),
 Row(current_yn=u'248115', c1=2),
 Row(current_yn=u'252237', c1=2),
 Row(current_yn=u'248728', c1=18),
 Row(current_yn=u'249791', c1=2),
 Row(current_yn=u'243329', c1=44),
 Row(current_yn=u'248118', c1=2),
 Row(current_yn=u'250007', c1=2),
 Row(current_yn=u'248000', c1=2),
 Row(current_yn=u'250791', c1=2),
 Row(current_yn=u'250459', c1=2),
 Row(current_yn=u'252123', c1=2),
 Row(current_yn=u'249957', c1=2),
 Row(current_yn=u'250180', c1=26),
 Row(current_yn=u'252124', c1=2),
 Row(current_yn=u'249344', c1=2),
 Row(current_yn=u'247725', c1=2),
 Row(current_yn=u'248292', c1=2),
 Row(current_yn=u'248003', c1=2),
 Row(current_yn=u'251848', c1=2),
 Row(current_yn=u'251730', c1=2),
 Row(current_yn=u'248951', c1=2),
 Row(current_yn=u'249185', c1=2),
 Row(current_yn=u'248500', c1=2),
 Row(current_yn=u'249348', c1=2),
 Row(current_yn=u'257862', c1=10),
 Row(current_yn=u'250798', c1=2),
 Row(current_yn=u'243390', c1=322),
 Row(current_yn=u'250680', c1=10),
 Row(current_yn=u'247729', c1=2),
 Row(current_yn=u'248296', c1=4),
 Row(current_yn=u'257863', c1=12),
 Row(current_yn=u'251120', c1=2),
 Row(current_yn=u'264659', c1=24),
 Row(current_yn=u'243391', c1=40),
 Row(current_yn=u'167260', c1=1222),
 Row(current_yn=u'248341', c1=2),
 Row(current_yn=u'249189', c1=2),
 Row(current_yn=u'248504', c1=2),
 Row(current_yn=u'243392', c1=30),
 Row(current_yn=u'167261', c1=1132),
 Row(current_yn=u'243393', c1=42),
 Row(current_yn=u'250845', c1=4),
 Row(current_yn=u'250232', c1=4),
 Row(current_yn=u'243394', c1=22),
 Row(current_yn=u'244780', c1=52),
 Row(current_yn=u'167263', c1=1192),
 Row(current_yn=u'252466', c1=2),
 Row(current_yn=u'243395', c1=14),
 Row(current_yn=u'243396', c1=8),
 Row(current_yn=u'167265', c1=1368),
 Row(current_yn=u'248508', c1=12),
 Row(current_yn=u'167266', c1=1256),
 Row(current_yn=u'244783', c1=26),
 Row(current_yn=u'243397', c1=6),
 Row(current_yn=u'250570', c1=4),
 Row(current_yn=u'248681', c1=2),
 Row(current_yn=u'243398', c1=8),
 Row(current_yn=u'167267', c1=1430),
 Row(current_yn=u'250237', c1=2),
 Row(current_yn=u'167268', c1=2530),
 Row(current_yn=u'244785', c1=30),
 Row(current_yn=u'243399', c1=6),
 Row(current_yn=u'243282', c1=4),
 Row(current_yn=u'287491', c1=2),
 Row(current_yn=u'250734', c1=2),
 Row(current_yn=u'244786', c1=28),
 Row(current_yn=u'167269', c1=1146),
 Row(current_yn=u'248232', c1=2),
 Row(current_yn=u'248188', c1=2),
 Row(current_yn=u'249079', c1=8),
 Row(current_yn=u'250572', c1=2),
 Row(current_yn=u'243283', c1=6),
 Row(current_yn=u'244787', c1=38),
 Row(current_yn=u'243284', c1=14),
 Row(current_yn=u'252400', c1=4),
 Row(current_yn=u'252356', c1=2),
 Row(current_yn=u'252240', c1=26),
 Row(current_yn=u'243330', c1=26),
 Row(current_yn=u'248075', c1=4),
 Row(current_yn=u'243287', c1=18),
 Row(current_yn=u'243331', c1=8),
 Row(current_yn=u'243332', c1=10),
 Row(current_yn=u'243288', c1=14),
 Row(current_yn=u'248734', c1=4),
 Row(current_yn=u'247681', c1=2),
 Row(current_yn=u'243333', c1=4),
 Row(current_yn=u'252082', c1=4),
 Row(current_yn=u'250624', c1=2),
 Row(current_yn=u'243334', c1=20),
 Row(current_yn=u'167203', c1=4436),
 Row(current_yn=u'167204', c1=70),
 Row(current_yn=u'249961', c1=2),
 Row(current_yn=u'167205', c1=1564),
 Row(current_yn=u'251355', c1=2),
 Row(current_yn=u'243336', c1=2),
 Row(current_yn=u'250627', c1=2),
 Row(current_yn=u'243337', c1=48),
 Row(current_yn=u'167206', c1=4392)]