Csv Cloud Neiman Marcus Database
Neiman Marcus Database
thans to ShinyHunters
The leak contained data on more than 40 million customers and included over 40 million unique email addresses, account balances, browser user agent details, credit cards, dates of birth, gift cards, IP addresses, names, payment histories, payment methods, phone numbers, physical addresses.
Compromised Data :
Account balances, Browser user agent details, Credit cards, Dates of birth, Email addresses, Gift cards, IP addresses, Names, Payment histories, Payment methods, Phone numbers, Physical addresses.
Date: 05/2024
Data: ~40m emails in PII_SEC
incircle account ~5.8m rows
incirclf_mtf_dim 85m rows, giftcard 12m rows
finally pii_sec_email is all their emails for the CRM tool
Sample :
thans to ShinyHunters
The leak contained data on more than 40 million customers and included over 40 million unique email addresses, account balances, browser user agent details, credit cards, dates of birth, gift cards, IP addresses, names, payment histories, payment methods, phone numbers, physical addresses.
Compromised Data :
Account balances, Browser user agent details, Credit cards, Dates of birth, Email addresses, Gift cards, IP addresses, Names, Payment histories, Payment methods, Phone numbers, Physical addresses.
Date: 05/2024
Data: ~40m emails in PII_SEC
incircle account ~5.8m rows
incirclf_mtf_dim 85m rows, giftcard 12m rows
finally pii_sec_email is all their emails for the CRM tool
Hidden content
Sample :
HTML:
$ head -1 *
==> AURUS_TRANSACTIONS.csv <==
CARD_TYPE,RECEIPT_TOKEN,CARD_LAST_4_DIGIT,APPROVAL_CODE,RESPONSE_MESSAGE,RESPONSE_CODE,BILLING_ADDRESS,SHIPPING_ADDRESS,CUSTOMER_NAME,ISSUER_COUNTRY_CODE,ISSUER_BANK_NAME,TENDER_TYPE,MASKED_CARD_NUMBER,HOST_CARD_IDENTIFIER,MERCHANT_CARD_IDENTIFIER,MERCHANT_CUSTOMER_IDENTIFIER,CUSTOMER_TYPE,CVV_BYPASS,AURUS_TRANSACTIONS_KEY,STORE_ID,STORE_NAME,STORE_BRAND,STORE_CITY,STORE_STATE,STORE_COUNTRY,TICKET_NUMBER,TRANSACTION_ID,STORE_TRANSACTION_DATE_TIME,HOST_TRANSACTION_DATE_TIME,TRANSACTION_TYPE,RESPONSE_CARD_NUMBER,WALLET_TYPE,TRANSACTION_STATUS,ENTRY_DATA_SOURCE,TRANSACTION_SEQUENCE_NUMBER,SUB_TRANSACTION_TYPE,VOID_REVERSAL_INDICATOR,AVS_RESPONSE_MESSAGE,CVV_RESPONSE_MESSAGE,POS_TRANSACTION_NUMBER,INVOICE_NUMBER,PARENT_TRANSACTION_ID,CURRENCY_CODE,APPROVED_AMOUNT,REQUESTED_AMOUNT,SKU_TOTAL,TAX_AMOUNT,TIP_AMOUNT,CHARITY_AMOUNT,DISCOUNT_AMOUNT,BALANCE_AMOUNT,CASH_BALANCE_AMOUNT,FOOD_BALANCE_AMOUNT,CASHBACK_AMOUNT,SETTLEMENT_AMOUNT,SETTLEMENT_DATE,SETTLEMENT_STATUS,SETTLEMENT_TYPE,BATCH_NUMBER,PROCESSOR_NAME,PROCESSOR_TRANSACTION_TIME,REFERRAL_INDICATOR,REFERRAL_ID,REFERRAL_TRANSACTION_SOURCE,SNF_TRANSACTION,SNF_TICKET_NUMBER,SNF_APPROVAL_CODE,PRESALE_DATE,FALLBACK_INDICATOR,SIGNATURE_AVAILABILITY,SIGNATURE_BYPASS,PIN_RECEIVED,CHARITY_NAME,CALLER_ID,TIP_PERCENTAGE,BILLING_CONTROL_NUMBER,CHECK_NUMBER,CHECK_TRACE_ID,TERMINAL_NUMBER,TERMINAL_TYPE,DEVICE_SERIAL_NUMBER,POS_REGISTER_NO,DEVICE_SOFTWARE_VERSION,IP_ADDRESS,MAC_ADDRESS,OS_VERSION,AESDK_VERSION,ASSOCIATE_CASHIER_ID,ASSOCIATE_CASHIER_NAME,DCC_OFFERED,DCC_RESPONSE_CODE,DCC_FOREIGN_AMOUNT,DCC_EXCHANGE_RATE,DCC_EXCHANGE_RATE_SOURCE_NAME,DCC_EXCHANGE_RATE_SOURCE_TIME,DCC_FOREIGN_CURRENCY_CODE,DCC_ALPHA_CURRENCY_CODE,DCC_TIME_ZONE,DCC_MARGIN_RATE_PERCENTAGE,DCC_COMMISSION_PERCENTAGE,DCC_MINOR_UNITS,DCC_VALID_HOURS,RISK_AND_FRAUD_SCORE,RISK_AND_FRAUD_DECISION,PROCESSOR_RESPONSE_CODE,EMV_ATC_9F40,EMV_APPLICATION_CRYPTOGRAM_9F26,EMV_AID_4F,EMV_APPLICATION_LABEL_50,EMV_APPLICATION_PREFERRED_NAME_9F12,EMV_ARC_8A,EMV_CVM_LIST_8E,EMV_CVM_9F34,EMV_IAP_DATA_9F10,EMV_IAU_DATA_91,EMV_SERVICE_CODE_5F30,EMV_TERMINAL_CAPABILITIES_9F33,EMV_TVR_95,EMV_TSI_9B,EMV_AID_DETAILS_4F,EMV_PIN_95,EMV_CVM_SELECTED_9F34,EMV_CVM_LIST_DETAILS_8E,EMV_TRANSACTION_DATE_9A,EMV_AEX_DATE_5F24,EMV_ISSUER_COUNTRY_CODE_5F28,EMV_CASHBACK_OR_OTHER_AMOUNT_9F03,EMV_IAC_DENIAL_9F0E,EMV_TRANSACTION_COUNTRY_CODE_9F1A,EMV_TS_COUNTER_9F41,EMV_ICC_DYNAMIC_NUMBER_9F4C,EMV_AUTHORIZED_AMOUNT_9F02,EMV_TERMINAL_AID_9F06,EMV_TTQ_9F66,EMV_MERCHANT_CUSTOM_DATA_9F7C,EMV_TRM_DATA_9F1D,EMV_CAVN_9F08,EMV_DEDICATED_FILE_NAME_84,EMV_CARD_SEQUENCE_NUMBER_5F34,EMV_TRANSACTION_CURRENCY_CODE_5F2A,EMV_APPLICATION_VERSION_NUMBER_9F09,EMV_IAC_ONLINE_9F0F,EMV_CID_9F27,EMV_ATC_9F36,EMV_LANGUAGE_IDENTIFIER_C2,EMV_TERMINAL_TYPE_9F35,EMV_AUC_9F07,EMV_IFD_SERIAL_NUMBER_9F1E,EMV_FORM_FACTOR_INDICATOR_9F6E,EMV_FALLBACK_INDICATOR_9F39,EMV_TRANSACTION_TIME_9F21,EMV_AEF_DATE_5F25,EMV_ISSUER_SCRIPT_TEMPLATE_71_OR_72,EMV_TRANSACTION_TYPE_9C,EMV_LANGUAGE_PREFERENCE_5F2D,EMV_IAC_DEFAULT_9F0D,EMV_AIP_82,EMV_UN_9F37,EMV_APPLICATION_CURRENCY_CODE_9F42,EMV_CAPKI_8F,EMV_AUC_DETAILS_9F07,EMV_TRANSACTION_CATEGORY_CODE_9F53,EMV_CARD_TRANSACTION_QUALIFIERS_9F6C,EMV_POS_ENTRY_MODE_9F39,L3_LEVEL_DATA,SOURCE_TRANSACTION_ID,CALL_BACK_URL,CARRIER_WISE_DATA,STORE_TYPE,ONE_ORDER_TOKEN,ONE_TIME_TOKEN,TOTAL_RESPONSE_TIME,HOST_RESPONSE_TIME,DISTRICT,REGION,AREA_ZONE,STAN,TRANSACTION_UNIQUE_ID,UPC,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10,LOAD_LOG_KEY,SOURCE_NAME,RECORD_CREATION_DATETIME,RECORD_UPDATED_DATETIME,SUB_CARD_TYPE,TRANSACTION_TOTAL_AMOUNT,SERVICE_TOTAL,SESSION_ID,TRAINING_MODE,LOYALTY_REWARD,LOYALTY_NUMBER,LOYALTY_REWARD_ID,LOYALTY_PROMOTION_ID,LOYALTY_AMOUNT,IVR_APPROVAL_CODE,PURCHASE_ORDER_NUMBER,OMNI_CHANNEL_INDICATOR,ROUTING_STORE_ID,ROUTING_STORE_NAME,ROUTING_TERMINAL_NUMBER,HOST_TRANSACTION_TYPE,POS_TYPE,PAYPAL_BILLING_AGREEMENT_NUMBER,PAYPAL_AUTHORIZATION_EXPIRATION_DATE,PAYER_EMAIL,PAYER_STATUS,MERCHANT_PROTECTION_ELIGIBILITY,TRANSACTION_INTEGRITY_CLASSIFICATIONS,TOTAL_INVOICE_AMOUNT,
UPDATED_AMOUNT,RRN,ASSET_ORIGINATOR,WIFI_SIGNAL,GPRS_SIGNAL,PCI_APP_VERSION,ENCRYPTION_DATA_TYPE,OTC_AMOUNT,OTC_FOOD_AMOUNT,OTC_OTHER_AMOUNT,OTC_APPROVED_AMOUNT,OTC_FOOD_APPROVED_AMOUNT,NETWORK_ID,NETWORK_NAME,HOST_NAME,MAKE_AND_MODEL,BALANCE_AUTH_AMOUNT,TRANSACTION_MODE,DEPARTMENT_CATEGORY,GUEST_CHECKOUT,DELIVERY_TIMEFRAME,ACCOUNT_RETRIEVAL_TYPE,SPECIAL_AUTHORIZATION_TYPE,CHANNEL_INDICATOR,STORE_ASSOCIATE_FAMILIARITY,KEYED_ENTRY_REASON_CODE,ADJUSTMENT_TYPE,STATE_AGENCY_SETTLEMENT_AMOUNT,MOBILE_DEVICE_IDENTIFIER,DRAFT_LOCATOR_ID,TOTAL_TAX_AMOUNT,POS_REGISTER_NAME,POS_IP,POS_CLIENT_NAME,POS_VERSION,ISSUER_TRANSACTION_ID,ROUTING_FORM_FACTOR_MODEL,PARTIAL_APPROVED_FLAG,HOST_REFERENCE_ID,CRM_TOKEN_ID,CRM_TOKEN,CRM_DECRYPTION_STATUS,CRM_TOKENIZATION_STATUS,PROCESSOR_TERMINAL_ID,PROCESSOR_MERCHANT_ID,DECRYPTION_TIME,TOKENIZATION_TIME,IS_DEBIT_CARD
==> FULL_ORATENDER_T_202405241011.csv <==
"FULL_ORATENDER_KEY","CUSTOMER_NO","TENDER_ID","TENDER_TYPE","TENDER_LAST_FOUR_DIGITS","TENDER_CARD_OWNER_FLG","TENDER_CSRV_MAINT_DT"
==> GIFT_CARD_MASTER_T.csv <==
GIFT_CARD_MASTER_KEY,SEQUENCE_NUMBER,TOTAL_RECORD_COUNT,NM_TRACKING_KEY,GIFTCARD_NUMBER,ALTERNATE_GIFTCARD_NUMBER,REPLACED_BY_GIFTCARD_NUMBER,CARD_TYPE,CREATE_REQUESTED,ACCOUNT_CREATE_RECONCILED,OFAC_STATUS,FINCEN_STATUS,CREATE_SOURCE_APPLICATION,CARD_CLASS,PROMO_ID,THEME,EXPIRE_DATE,ACTIVATION_DATE,SALTED_GIFTCARD_NUMBER,SALTED_GIFTCARD_EXPIRE_DATE,CUSTOMER_FIRST_NAME,CUSTOMER_LAST_NAME,CUSTOMER_ADDRESS_1,CUSTOMER_ADDRESS_2,CUSTOMER_CITY,CUSTOMER_STATE,CUSTOMER_COUNTRY,CUSTOMER_ZIP,CUSTOMER_PHONE,CUSTOMER_EMAIL_ADDRESS,RECIPIENT_FIRST_NAME,RECIPIENT_LAST_NAME,RECIPIENT_ADDRESS_1,RECIPIENT_ADDRESS_2,RECIPIENT_CITY,RECIPIENT_STATE,RECIPIENT_COUNTRY,RECIPIENT_ZIP,RECIPIENT_PHONE,RECIPIENT_EMAIL_ADDRESS,RECIPIENT_MOBILE,RECIPIENT_OS,RECIPIENT_BROWSER,RECIPIENT_OPTIN,ORIG_BALANCE,PREVIOUS_BALANCE,LAST_PTD_BALANCE,KI,KI_CARD_TYPE,CLIENTSMART_ID,EMPLOYEE_PIN,CUSTOMER_WEB_ID,CMD_ID,STORE,TERMINAL,TRANSACTION_NUMBER,LAST_UPDATE_DATE_TIME,LAST_UPDATED_BY_USERID,LAST_TRANSACTION_DATE,BRAND,PURCHASED_DATE,PROCESSED_DATE,TERMINAL_LOCAL_TIMESTAMP,SHIPPED,DELIVERYDATE,CARDSOWNED,SHIPTYPE,TRACKING,PURCHASER_MOBILE,PURCHASER_OS,PURCHASER_BROWSER,AUDIO_UPLOADED,IMAGE_UPLOADED,FACEBOOK_WALLPOST,PURCHASER_OPTIN,PAYMENT_TYPE,PAYMENT_IPADDRESS,PAYMENT_DISTANCE,PAYMENT_RISK,PAYMENT_AMOUNT,TRANSACTION_STORE_FRONT,TRANSACTION_B2B_ACCOUNT,GL_NUMBER,PROMO_DESC_SHORT,DIVISION_NUMBER,DO_NOT_SEND_FLAG,ORIGIN_ID,OPER_ID,FOREIGN_FLAG,OPT_FLAG,ORDER_TRACKING_NUMBER,CHECK_TYPE,KEY_DATE,KEY_TIME,CUSTOMER_INIT,TRAN,RECORD_NUMBER,ACCT_NUMBER,LAST_TRANSACTION_TYPE,GIFT_REGISTER_ID,CMOS_ORDER_ID,JOB_ID,PROMO_DESC_LONG,HASH_NUMBER,WEB_ORDER_ID,TCKT_REFUND_ID,CAMPAIGN_ID,OFAC_REQUIRED,FINCEN_REQUIRED
==> INCIRCLE_ACCT_T.csv <==
INCIRCLE_ACCT_KEY,OWNER,PROGRAM_YEAR,DATE,TIME,TENDER_ID,CURRENT_POINTS,CURRENT_POINTS_SIGN,PROGRAM_ACHIEVED,LEVEL_ACHIEVED,NAME,ADDRESS_LINE1,ADDRESS_LINE2,CITY,STATE,ZIP,FOREIGN_ADDRESS_FLAG,SSN,REDEEM_PROGRAM_CCYY,REDEEM_ASOF_DATE,REDEEM_EARNED,REDEEM_EARNED_SIGN,REDEEM_MAINT,REDEEM_MAINT_SIGN,REDEEM,REDEEM_SIGN,REDEEM_AVAIL,REDEEM_AVAIL_SIGN,NON_PROGRAM_CCYY,NON_ASOF_DATE,NON_EARNED,NON_EARNED_SIGN,NON_MAINT,NON_MAINT_SIGN,NON_REDEEM,NON_REDEEM_SIGN,NON_AVAIL,NON_AVAIL_SIGN,MEMBERSHIP_OWNER,TY_MEMBERSHIP,LY_MEMBERSHIP,INDEX_ACCOUNT,PHONE,MET_DAY,CURRENT_SPEND,CURRENT_SPEND_SIGN,EARNED_LEVEL,EARNED_LEVEL_NAME,BENEFIT_LEVEL,BENEFIT_LEVEL_NAME,CY_EARN_DATE,GP_FLAG,LY_EARNED_LEVEL,LY_BENEFIT_LEVEL
==> INCIRCLE_MTF_DIM.csv <==
MTF_OWNER,MTF_KI,MTF_CARD_TYPE,MTF_TF_ACCT,MTF_CUST_NAME,MTF_ADDR1,MTF_ADDR2,MTF_CITY,MTF_STATE,MTF_ZIP,MTF_PHONE,MTF_PHONE_OTH,MTF_COUNTRY_CD,MTF_CO_HOLDER_NAME,MTF_FOREIGN_ADDR_FLG,MTF_DOB,MTF_GRS_PUR_MTD,MTF_GRS_PTS_MTD,MTF_GRS_TRANS_MTD,MTF_RET_DLRS_MTD,MTF_RET_PTS_MTD,MTF_RET_TRANS_MTD,MTF_GRS_PUR_PTD,MTF_GRS_PTS_PTD,MTF_GRS_TRANS_PTD,MTF_RET_DLRS_PTD,MTF_RET_PTS_PTD,MTF_RET_TRANS_PTD,MTF_GP_TOT_PTS_RDM,MTF_GP_LY_CO_PTS,MTF_GP_MBR_FST_YR_PTS,MTF_GP_DT_CHTR_MET,MTF_GP_LY_PTS,MTF_GP_LY_SPEND,MTF_GSP_GRS_PUR,MTF_GSP_GRS_PTS,MTF_GSP_GRS_TRNS,MTF_GSP_RET_DLRS,MTF_GSP_RET_PTS,MTF_GSP_RET_TRNS,MTF_GSP_PTS_RDM,MTF_GSP_LY_CO_PTS,MTF_PY_ADJ_PTS,MTF_PY_MNT_ID,MTF_PY_MNT_DT,MTF_PY_IND,MTF_PY_MAX_CO,MTF_PY_PCT,MTF_SH_LAST_STR_MTD1,MTF_SH_LAST_STR_PTD1,MTF_SH_LAST_STR_MTD2,MTF_SH_LAST_STR_PTD2,MTF_SH_LAST_STR_MTD3,MTF_SH_LAST_STR_PTD3,MTF_SH_LAST_STR_MTD4,MTF_SH_LAST_STR_PTD4,MTF_PG_PART_FLG,MTF_PG_INCL_DT,MTF_PG_FST_PRG,MTF_PG_LVL_DT,MTF_PG_ACHV,MTF_PG_LVL_ACHV,MTF_PG_NW_LVL_MSG,MTF_PG_LVL_NTF,MTF_PG_CHRTR_MB_SWT,MTF_PG_LST_CONT_DT,MTF_PG_CONT_FLG,MTF_PG_DEROG_DT,MTF_PG_DEROG_FLG,MTF_INDEX_KI,MTF_PG_LY_DOC_DT,MTF_PG_CY_DOC_DT,MTF_PG_OPT_OUT_IND,MTF_PG_OPT_OUT_DT,MTF_SL_CMS_USER_CD,MTF_SL_PLST_LVL,MTF_SL_INCL_LVL,MTF_SL_PP_LVL,MTF_SL_CH_PLT_LVL,MTF_SL_LY_CMS_USR_CD,MTF_SL_LY_PLST_LVL,MTF_SL_LY_CMS_USR_CD2,MTF_SL_LY_PLST_LVL2,MTF_GI_ENRL_NO,MTF_GI_DT_OPEN,MTF_GI_DT_ISSUE,MTF_GI_LST_DRCR_DT,MTF_GI_LST_DRCR_FLG,MTF_GI_LST_DRCR_AMT,MTF_GI_LST_MNT_ID,MTF_GI_LST_MNT_DT,MTF_GI_PND_DRCR_FLG,MTF_GI_LST4_SSN,MTF_ST_BL_CYCL,MTF_ST_LST_PTS,MTF_ST_YTD_PTS,MTF_ST_LST_RTNS,MTF_ST_LST_RDM,MTF_RM_CY_ERN_LVL,MTF_RM_CY_ERN_DT,MTF_RM_CY_BEN_LVL,MTF_RM_CY_BEN_DT,MTF_RM_LY_ERN_LVL,MTF_RM_LY_ERN_DT,MTF_RM_LY_BEN_LVL,MTF_RM_LY_BEN_DT,MTF_RM_SVC_CRD_CY,MTF_RM_SVC_CY_DT,MTF_RM_SVC_CRD_LY,MTF_RM_SVC_LY_DT,MTF_RM_CY_BEN_SW,MTF_RM_LY_BEN_SW,MTF_GR_EVNT_TYPE,MTF_GR_EVNT_DT,MTF_GR_EF_BGDT,MTF_GR_EF_ENDT,MTF_GR_MSG_SW,MTF_GR_STATUS,MTF_GR_STAT_DT,MTF_GR_EXPR_FLG,MTF_RTC_DOC_LY,MTF_RTC_DOC_LY_DT,MTF_RTC_DOC_CY,MTF_RTC_DOC_CY_DT,MTF_RTC_DOC_UNUSED,MTF_RTC_DOC_GC_UNUSED,MTF_RTC_LY_LVL2,MTF_RTC_LY_LVL2_DT,MTF_RTC_CY_LVL2,MTF_RTC_CY_LVL2_DT,MTF_DR_CUST_BLK_1,MTF_DR_NCE_BLK_1,MTF_DR_CUST_BLK_2,MTF_DR_NCE_BLK_2,MTF_DR_CUST_DELQ,MTF_DR_NCE_DELQ,MTF_DR_CUST_INT_ST,MTF_DR_NCE_INT_ST,MTF_DR_CUST_DIST,MTF_DR_NCE_DIST,MTF_DR_CUST_RTN_MAIL,MTF_DR_NCE_RTN_MAIL,MTF_DR_CUST_LOGO,MTF_DR_NCE_LOGO,MTF_DR_CUST_EMPL,MTF_DR_NCE_EMPL,MTF_DR_CUST_CSE_DST,MTF_DR_NCE_CSE_DST,MTF_DM_NET_SALES,MTF_DM_NET_POINTS,MTF_DM_AVAIL_PTS,MTF_DEROG_REDM,MTF_DEROG_PERK,EMAIL_ADDRESS,MTF_CUSTOMER_RANK,MTF_RDATE,TEND_UKEY
==> PII_SEC.ADDR1_LOOKUP_T_202405180319.csv <==
"ADDR1_KEY","ADDR1","RECORD_CREATION_DATETIME"
==> PII_SEC.BIRTHDATE_LOOKUP_T_202405180319.csv <==
"BIRTHDATE_KEY","BIRTHDATE","RECORD_CREATION_DATETIME"
==> PII_SEC.ECOA_NEW_EMAIL_LOOKUP_T_202405180319.csv <==
"ECOA_NEW_EMAIL_KEY","ECOA_NEW_EMAIL","RECORD_CREATION_DATETIME"
==> PII_SEC.EMAIL_LOOKUP_T_202405180319.csv <==
"EMAIL_KEY","EMAIL","RECORD_CREATION_DATETIME"
==> PII_SEC.EVAR28_LOOKUP_T_202405180319.csv <==
"EVAR28_KEY","EVAR28","RECORD_CREATION_DATETIME"
==> PII_SEC.EVAR29_LOOKUP_T_202405180319.csv <==
"EVAR29_KEY","EVAR29","RECORD_CREATION_DATETIME"
==> PII_SEC.EVAR49_LOOKUP_T_202405180319.csv <==
"EVAR49_KEY","EVAR49","RECORD_CREATION_DATETIME"
==> PII_SEC.EVAR60_LOOKUP_T_202405180319.csv <==
"EVAR60_KEY","EVAR60","RECORD_CREATION_DATETIME"
==> PII_SEC.EVARS_LOOKUP_T_202405180319.csv <==
"EVARS_KEY","EVARS","RECORD_CREATION_DATETIME"
==> PII_SEC.FNAME_LOOKUP_T_202405180319.csv <==
"FNAME_KEY","FNAME","RECORD_CREATION_DATETIME"
==> PII_SEC.IP_ADDRESS_LOOKUP_T_202405180319.csv <==
"IP_ADDRESS_KEY","IP_ADDRESS","RECORD_CREATION_DATETIME"
==> PII_SEC.LNAME_LOOKUP_T_202405180319.csv <==
"LNAME_KEY","LNAME","RECORD_CREATION_DATETIME"
==> PII_SEC.PHONE_LOOKUP_T_202405180319.csv <==
"PHONE_KEY","PHONE","RECORD_CREATION_DATETIME"
==> PII_SEC.POST_EVARS_LOOKUP_T_202405180319.csv <==
"POST_EVARS_KEY","POST_EVARS","RECORD_CREATION_DATETIME"
==> PII_SEC.POST_PROPS_LOOKUP_T_202405180319.csv <==
"POST_PROPS_KEY","POST_PROPS","RECORD_CREATION_DATETIME"
==> PII_SEC.POSTEVAR28_LOOKUP_T_202405180319.csv <==
"POSTEVAR28_KEY","POSTEVAR28","RECORD_CREATION_DATETIME"
==> PII_SEC.POSTEVAR29_LOOKUP_T_202405180319.csv <==
"POSTEVAR29_KEY","POSTEVAR29","RECORD_CREATION_DATETIME"
==> PII_SEC.POSTEVAR49_LOOKUP_T_202405180319.csv <==
"POSTEVAR49_KEY","POSTEVAR49","RECORD_CREATION_DATETIME"
==> PII_SEC.POSTEVAR60_LOOKUP_T_202405180319.csv <==
"POSTEVAR60_KEY","POSTEVAR60","RECORD_CREATION_DATETIME"
==> PII_SEC.PROP31_LOOKUP_T_202405180319.csv <==
"PROP31_KEY","PROP31","RECORD_CREATION_DATETIME"
==> PII_SEC.PROPS_LOOKUP_T_202405180319.csv <==
"PROPS_KEY","PROPS","RECORD_CREATION_DATETIME"
$ wc -l *
13233750 AURUS_TRANSACTIONS.csv
34383235 FULL_ORATENDER_T_202405241011.csv
12307729 GIFT_CARD_MASTER_T.csv
5804212 INCIRCLE_ACCT_T.csv
84727298 INCIRCLE_MTF_DIM.csv
127057 PII_SEC.ADDR1_LOOKUP_T_202405180319.csv
3206 PII_SEC.BIRTHDATE_LOOKUP_T_202405180319.csv
21 PII_SEC.ECOA_NEW_EMAIL_LOOKUP_T_202405180319.csv
42108096 PII_SEC.EMAIL_LOOKUP_T_202405180319.csv
26 PII_SEC.EVAR28_LOOKUP_T_202405180319.csv
274837 PII_SEC.EVAR29_LOOKUP_T_202405180319.csv
715537 PII_SEC.EVAR49_LOOKUP_T_202405180319.csv
79843 PII_SEC.EVAR60_LOOKUP_T_202405180319.csv
1 PII_SEC.EVARS_LOOKUP_T_202405180319.csv
681903 PII_SEC.FNAME_LOOKUP_T_202405180319.csv
51619617 PII_SEC.IP_ADDRESS_LOOKUP_T_202405180319.csv
980879 PII_SEC.LNAME_LOOKUP_T_202405180319.csv
94063 PII_SEC.PHONE_LOOKUP_T_202405180319.csv
1 PII_SEC.POST_EVARS_LOOKUP_T_202405180319.csv
1 PII_SEC.POST_PROPS_LOOKUP_T_202405180319.csv
26 PII_SEC.POSTEVAR28_LOOKUP_T_202405180319.csv
56650 PII_SEC.POSTEVAR29_LOOKUP_T_202405180319.csv
418138 PII_SEC.POSTEVAR49_LOOKUP_T_202405180319.csv
79955 PII_SEC.POSTEVAR60_LOOKUP_T_202405180319.csv
1 PII_SEC.PROP31_LOOKUP_T_202405180319.csv
1 PII_SEC.PROPS_LOOKUP_T_202405180319.csv
247696083 total
