November 7, 2022 at 1:16 AM
Im selling the customer info of Luxottica's American and Canadian companies/retail stores, all combined it is 306,090,199 records (14,113,577 records are from canda). It contains alot of PII data mainly emails, first name, middle name, last name, address, dob and more. The data is split in 500+ parquet files (https://www.snowflake.com/guides/what-parquet) totalling 123 GB of data, and parquet is already compressed. It can easily be transfered to any format such as CSV.
Heres the full list of columns, its really big just a warning for anyone opening the spoiler:
[spoiler]
persona_h_hid,persona_brand_h_hid,individual_h_hid,indv_brand_h_hid,household_h_hid,company_code,sales_organization,distribution_channel,customer_id_external,tax_code,first_name,middle_name,last_name,birth_date,death_date,gender_ind,last_transaction_datetime,home_email_comm_h_hid,home_email_address,home_uncleansed_email_address,home_email_primary_flag,home_email_opt_out_flag,home_email_opt_in_out_date,home_email_opt_in_out_source,home_email_opt_in_out_source_description,work_email_comm_h_hid,work_email_address,work_uncleansed_email_address,work_email_primary_flag,work_email_opt_out_flag,work_email_opt_in_out_source,work_email_opt_in_out_source_description,bill_email_comm_h_hid,bill_email_address,bill_uncleansed_email_address,bill_email_primary_flag,bill_email_opt_out_flag,bill_email_opt_in_out_source,bill_email_opt_in_out_source_description,ship_email_comm_h_hid,ship_email_address,ship_uncleansed_email_address,ship_email_primary_flag,ship_email_opt_out_flag,ship_email_opt_in_out_source,ship_email_opt_in_out_source_description,home_postal_comm_h_hid,home_address_1,home_uncleansed_address_1,home_address_2,home_uncleansed_address_2,home_city,home_uncleansed_city,home_state_province_code,home_uncleansed_state_province_code,home_country_code,home_uncleansed_country_code,home_postal_code,home_uncleansed_postal_code,home_postal_code_plus,home_uncleansed_postal_code_plus,home_postal_final_dnm_flag,home_postal_primary_flag,home_postal_opt_out_flag,home_postal_opt_in_out_source,home_postal_opt_in_out_source_description,work_postal_comm_h_hid,work_address_1,work_uncleansed_address_1,work_address_2,work_uncleansed_address_2,work_city,work_uncleansed_city,work_state_province_code,work_uncleansed_state_province_code,work_country_code,work_uncleansed_country_code,work_postal_code,work_uncleansed_postal_code,work_postal_code_plus,work_uncleansed_postal_code_plus,work_postal_final_dnm_flag,work_postal_primary_flag,work_postal_opt_out_flag,work_postal_opt_in_out_source,work_postal_opt_in_out_source_description,bill_postal_comm_h_hid,bill_address_1,bill_uncleansed_address_1,bill_address_2,bill_uncleansed_address_2,bill_city,bill_uncleansed_city,bill_state_province_code,bill_uncleansed_state_province_code,bill_country_code,bill_uncleansed_country_code,bill_postal_code,bill_uncleansed_postal_code,bill_postal_code_plus,bill_uncleansed_postal_code_plus,bill_postal_final_dnm_flag,bill_postal_primary_flag,bill_postal_opt_out_flag,bill_postal_opt_in_out_source,bill_postal_opt_in_out_source_description,ship_postal_comm_h_hid,ship_address_1,ship_uncleansed_address_1,ship_address_2,ship_uncleansed_address_2,ship_city,ship_uncleansed_city,ship_state_province_code,ship_uncleansed_state_province_code,ship_country_code,ship_uncleansed_country_code,ship_postal_code,ship_uncleansed_postal_code,ship_postal_code_plus,ship_uncleansed_postal_code_plus,ship_postal_final_dnm_flag,ship_postal_primary_flag,ship_postal_opt_out_flag,ship_postal_opt_in_out_source,ship_postal_opt_in_out_source_description,vacation_postal_comm_h_hid,vacation_address_1,vacation_uncleansed_address_1,vacation_address_2,vacation_uncleansed_address_2,vacation_city,vacation_uncleansed_city,vacation_state_province_code,vacation_uncleansed_state_province_code,vacation_country_code,vacation_uncleansed_country_code,vacation_postal_code,vacation_uncleansed_postal_code,vacation_postal_code_plus,vacation_uncleansed_postal_code_plus,vacation_postal_final_dnm_flag,vacation_postal_primary_flag,vacation_postal_opt_out_flag,vacation_postal_opt_in_out_source,vacation_postal_opt_in_out_source_description,other_postal_comm_h_hid,other_address_1,other_uncleansed_address_1,other_address_2,other_uncleansed_address_2,other_city,other_uncleansed_city,other_state_province_code,other_uncleansed_state_province_code,other_country_code,other_uncleansed_country_code,other_postal_code,other_uncleansed_postal_code,other_postal_code_plus,other_uncleansed_postal_code_plus,other_postal_final_dnm_flag,other_postal_primary_flag,other_postal_opt_out_flag,other_postal_opt_in_out_source,other_postal_opt_in_out_source_description,home_phone_comm_h_hid,home_phone_country_code,home_phone_invalid_flag,home_phone_number,home_phone_final_dnc_flag,home_phone_final_dnf_flag,home_phone_primary_flag,home_phone_opt_out_flag,home_phone_opt_in_out_source,home_phone_opt_in_out_source_description,work_phone_comm_h_hid,work_phone_country_code,work_phone_invalid_flag,work_phone_number,work_phone_final_dnc_flag,work_phone_final_dnf_flag,work_phone_primary_flag,work_phone_opt_out_flag,work_phone_opt_in_out_source,work_phone_opt_in_out_source_description,bill_phone_comm_h_hid,bill_phone_country_code,bill_phone_invalid_flag,bill_phone_number,bill_phone_final_dnc_flag,bill_phone_final_dnf_flag,bill_phone_primary_flag,bill_phone_opt_out_flag,bill_phone_opt_in_out_source,bill_phone_opt_in_out_source_description,ship_phone_comm_h_hid,ship_phone_country_code,ship_phone_invalid_flag,ship_phone_number,ship_phone_final_dnc_flag,ship_phone_final_dnf_flag,ship_phone_primary_flag,ship_phone_opt_out_flag,ship_phone_opt_in_out_source,ship_phone_opt_in_out_source_description,cell_phone_comm_h_hid,cell_phone_country_code,cell_phone_invalid_flag,cell_phone_number,cell_phone_final_dnc_flag,cell_phone_final_dnf_flag,cell_phone_primary_flag,cell_phone_opt_out_flag,cell_phone_opt_in_out_source,cell_phone_opt_in_out_source_description,fax_phone_comm_h_hid,fax_phone_country_code,fax_phone_invalid_flag,fax_phone_number,fax_phone_final_dnc_flag,fax_phone_final_dnf_flag,fax_phone_primary_flag,fax_phone_opt_out_flag,fax_phone_opt_in_out_source,fax_phone_opt_in_out_source_description,preferred_communication_channel,preferred_communication_channel_description,addr_preference,phone_preference,email_preference,home_emailable_flag,home_mailable_flag,language_code,language_code_description,prefix_name,suffix_gen_name,suffix_pro_name,last_cust_source,last_cust_medium,last_cust_medium_description,last_cust_campaign,global_opt_out_flag,name_jdoe_flag,fname_lname_match_flag,name_missing_flag,profanity_flag,final_busid,final_deceased_date,final_deceased_flag,final_gaid,final_hholdid,final_individ,final_siteid,name_excluded_vals_flag,name_short_flag,name_spec_chars,last_cleanse_date,employee_flag,prospect_flag,pearle_franchise_flag,last_doctor_id,last_exam_date,last_prescription_expiration_date,last_prescription_id,last_prescription_type_code,profile_face_shape,profile_favorite_site,profile_last_instore_datetime,profile_last_instore_site_number,profile_last_login_datetime,profile_my_vision_benefits_exp_date,profile_my_vision_benefits_name,profile_style_type,profile_sync_datetime,age_certification,sale_safety_flag,suppressed_site_flag,usertype,loyalty_program,list_name,organization_enum,scope_enum,customer_status,sup_osi_group,service_status,department,sup_osi_rank,expiration_date,primary_email,organization,pro_schoolname,pro_schoolemail,pro_clubname,pro_appliedrewards,pro_benefitsid,pro_community,pro_companycontactfullname,pro_companyname,pro_completedtrainings,pro_expiration,pro_industry,pro_logoagreement,taxcode,load_date,record_creation_date,update_datetime
[/spoiler]
Heres the full list of columns, its really big just a warning for anyone opening the spoiler:
[spoiler]
persona_h_hid,persona_brand_h_hid,individual_h_hid,indv_brand_h_hid,household_h_hid,company_code,sales_organization,distribution_channel,customer_id_external,tax_code,first_name,middle_name,last_name,birth_date,death_date,gender_ind,last_transaction_datetime,home_email_comm_h_hid,home_email_address,home_uncleansed_email_address,home_email_primary_flag,home_email_opt_out_flag,home_email_opt_in_out_date,home_email_opt_in_out_source,home_email_opt_in_out_source_description,work_email_comm_h_hid,work_email_address,work_uncleansed_email_address,work_email_primary_flag,work_email_opt_out_flag,work_email_opt_in_out_source,work_email_opt_in_out_source_description,bill_email_comm_h_hid,bill_email_address,bill_uncleansed_email_address,bill_email_primary_flag,bill_email_opt_out_flag,bill_email_opt_in_out_source,bill_email_opt_in_out_source_description,ship_email_comm_h_hid,ship_email_address,ship_uncleansed_email_address,ship_email_primary_flag,ship_email_opt_out_flag,ship_email_opt_in_out_source,ship_email_opt_in_out_source_description,home_postal_comm_h_hid,home_address_1,home_uncleansed_address_1,home_address_2,home_uncleansed_address_2,home_city,home_uncleansed_city,home_state_province_code,home_uncleansed_state_province_code,home_country_code,home_uncleansed_country_code,home_postal_code,home_uncleansed_postal_code,home_postal_code_plus,home_uncleansed_postal_code_plus,home_postal_final_dnm_flag,home_postal_primary_flag,home_postal_opt_out_flag,home_postal_opt_in_out_source,home_postal_opt_in_out_source_description,work_postal_comm_h_hid,work_address_1,work_uncleansed_address_1,work_address_2,work_uncleansed_address_2,work_city,work_uncleansed_city,work_state_province_code,work_uncleansed_state_province_code,work_country_code,work_uncleansed_country_code,work_postal_code,work_uncleansed_postal_code,work_postal_code_plus,work_uncleansed_postal_code_plus,work_postal_final_dnm_flag,work_postal_primary_flag,work_postal_opt_out_flag,work_postal_opt_in_out_source,work_postal_opt_in_out_source_description,bill_postal_comm_h_hid,bill_address_1,bill_uncleansed_address_1,bill_address_2,bill_uncleansed_address_2,bill_city,bill_uncleansed_city,bill_state_province_code,bill_uncleansed_state_province_code,bill_country_code,bill_uncleansed_country_code,bill_postal_code,bill_uncleansed_postal_code,bill_postal_code_plus,bill_uncleansed_postal_code_plus,bill_postal_final_dnm_flag,bill_postal_primary_flag,bill_postal_opt_out_flag,bill_postal_opt_in_out_source,bill_postal_opt_in_out_source_description,ship_postal_comm_h_hid,ship_address_1,ship_uncleansed_address_1,ship_address_2,ship_uncleansed_address_2,ship_city,ship_uncleansed_city,ship_state_province_code,ship_uncleansed_state_province_code,ship_country_code,ship_uncleansed_country_code,ship_postal_code,ship_uncleansed_postal_code,ship_postal_code_plus,ship_uncleansed_postal_code_plus,ship_postal_final_dnm_flag,ship_postal_primary_flag,ship_postal_opt_out_flag,ship_postal_opt_in_out_source,ship_postal_opt_in_out_source_description,vacation_postal_comm_h_hid,vacation_address_1,vacation_uncleansed_address_1,vacation_address_2,vacation_uncleansed_address_2,vacation_city,vacation_uncleansed_city,vacation_state_province_code,vacation_uncleansed_state_province_code,vacation_country_code,vacation_uncleansed_country_code,vacation_postal_code,vacation_uncleansed_postal_code,vacation_postal_code_plus,vacation_uncleansed_postal_code_plus,vacation_postal_final_dnm_flag,vacation_postal_primary_flag,vacation_postal_opt_out_flag,vacation_postal_opt_in_out_source,vacation_postal_opt_in_out_source_description,other_postal_comm_h_hid,other_address_1,other_uncleansed_address_1,other_address_2,other_uncleansed_address_2,other_city,other_uncleansed_city,other_state_province_code,other_uncleansed_state_province_code,other_country_code,other_uncleansed_country_code,other_postal_code,other_uncleansed_postal_code,other_postal_code_plus,other_uncleansed_postal_code_plus,other_postal_final_dnm_flag,other_postal_primary_flag,other_postal_opt_out_flag,other_postal_opt_in_out_source,other_postal_opt_in_out_source_description,home_phone_comm_h_hid,home_phone_country_code,home_phone_invalid_flag,home_phone_number,home_phone_final_dnc_flag,home_phone_final_dnf_flag,home_phone_primary_flag,home_phone_opt_out_flag,home_phone_opt_in_out_source,home_phone_opt_in_out_source_description,work_phone_comm_h_hid,work_phone_country_code,work_phone_invalid_flag,work_phone_number,work_phone_final_dnc_flag,work_phone_final_dnf_flag,work_phone_primary_flag,work_phone_opt_out_flag,work_phone_opt_in_out_source,work_phone_opt_in_out_source_description,bill_phone_comm_h_hid,bill_phone_country_code,bill_phone_invalid_flag,bill_phone_number,bill_phone_final_dnc_flag,bill_phone_final_dnf_flag,bill_phone_primary_flag,bill_phone_opt_out_flag,bill_phone_opt_in_out_source,bill_phone_opt_in_out_source_description,ship_phone_comm_h_hid,ship_phone_country_code,ship_phone_invalid_flag,ship_phone_number,ship_phone_final_dnc_flag,ship_phone_final_dnf_flag,ship_phone_primary_flag,ship_phone_opt_out_flag,ship_phone_opt_in_out_source,ship_phone_opt_in_out_source_description,cell_phone_comm_h_hid,cell_phone_country_code,cell_phone_invalid_flag,cell_phone_number,cell_phone_final_dnc_flag,cell_phone_final_dnf_flag,cell_phone_primary_flag,cell_phone_opt_out_flag,cell_phone_opt_in_out_source,cell_phone_opt_in_out_source_description,fax_phone_comm_h_hid,fax_phone_country_code,fax_phone_invalid_flag,fax_phone_number,fax_phone_final_dnc_flag,fax_phone_final_dnf_flag,fax_phone_primary_flag,fax_phone_opt_out_flag,fax_phone_opt_in_out_source,fax_phone_opt_in_out_source_description,preferred_communication_channel,preferred_communication_channel_description,addr_preference,phone_preference,email_preference,home_emailable_flag,home_mailable_flag,language_code,language_code_description,prefix_name,suffix_gen_name,suffix_pro_name,last_cust_source,last_cust_medium,last_cust_medium_description,last_cust_campaign,global_opt_out_flag,name_jdoe_flag,fname_lname_match_flag,name_missing_flag,profanity_flag,final_busid,final_deceased_date,final_deceased_flag,final_gaid,final_hholdid,final_individ,final_siteid,name_excluded_vals_flag,name_short_flag,name_spec_chars,last_cleanse_date,employee_flag,prospect_flag,pearle_franchise_flag,last_doctor_id,last_exam_date,last_prescription_expiration_date,last_prescription_id,last_prescription_type_code,profile_face_shape,profile_favorite_site,profile_last_instore_datetime,profile_last_instore_site_number,profile_last_login_datetime,profile_my_vision_benefits_exp_date,profile_my_vision_benefits_name,profile_style_type,profile_sync_datetime,age_certification,sale_safety_flag,suppressed_site_flag,usertype,loyalty_program,list_name,organization_enum,scope_enum,customer_status,sup_osi_group,service_status,department,sup_osi_rank,expiration_date,primary_email,organization,pro_schoolname,pro_schoolemail,pro_clubname,pro_appliedrewards,pro_benefitsid,pro_community,pro_companycontactfullname,pro_companyname,pro_completedtrainings,pro_expiration,pro_industry,pro_logoagreement,taxcode,load_date,record_creation_date,update_datetime
[/spoiler]
UPDATE, price adjusted based on these stats.
home_email_address 114,988,931 emails (74,685,976 unique)
home_phone_number 198,688,366 numbers (82,424,522 unique)
230,220,931 addresses
305,432,618 names
(if you want additional info ask)
For people who dont know what Luxottica is:
"Luxottica is a vertically integrated company, which has been described as a monopoly—it designs, manufactures, distributes, and retails its eyewear brands through companies such as LensCrafters, Sunglass Hut, Apex by Sunglass Hut, Pearle Vision, Target Optical, and Glasses.com. It also owns EyeMed, one of the largest vision health insurance providers. Its best known brands are Costa, Ray-Ban, Persol, Oliver Peoples and Oakley. Luxottica's market power has allowed it to charge price markups of 1000%." https://en.wikipedia.org/wiki/Luxottica
samples (1,104,552 record sample raw & "pretty" version):
https://anonfiles.com/F1J9obGcy6/lux_zip
All sales will be done through telegram with @pompompurin as middle man.
XMPP/Jabber: [email protected]
No sales yet, if you want this purchased privately we can discuss price
(Serious buyers only, its not cheap)
